Database Schema Hierarchy

import matplotlib.pyplot as plt
import numpy as np

fig, ax = plt.subplots(figsize=(12, 10), facecolor='#0a0a0f')
ax.set_facecolor('#0a0a0f')

# Inner ring - Schemas
schema_sizes = [35, 30, 20, 15]
schema_labels = ['public', 'analytics', 'auth', 'logs']
schema_colors = ['#27D3F5', '#F5276C', '#6CF527', '#F5B027']

# Outer ring - Tables
table_sizes = [12, 12, 11, 10, 10, 10, 10, 10, 8, 7]
table_colors = ['#27D3F5', '#4DE8FF', '#73EDFF',
                '#F5276C', '#FF5A94', '#FF8CB8',
                '#6CF527', '#8FFF5C',
                '#F5B027', '#FFCC5C']

wedges_outer, _ = ax.pie(table_sizes, radius=1, colors=table_colors,
       wedgeprops=dict(width=0.3, edgecolor='#0a0a0f', linewidth=2))

wedges_inner, _ = ax.pie(schema_sizes, radius=0.7, colors=schema_colors,
       wedgeprops=dict(width=0.3, edgecolor='#0a0a0f', linewidth=2))

# Add schema labels
for i, (wedge, label) in enumerate(zip(wedges_inner, schema_labels)):
    ang = (wedge.theta2 - wedge.theta1) / 2 + wedge.theta1
    x = 0.55 * np.cos(np.radians(ang))
    y = 0.55 * np.sin(np.radians(ang))
    ax.text(x, y, label, ha='center', va='center', fontsize=11, 
            color='white', fontweight='bold')

centre_circle = plt.Circle((0, 0), 0.4, fc='#0a0a0f', ec='#334155', linewidth=2)
ax.add_artist(centre_circle)
ax.text(0, 0, 'PostgreSQL\n42 Tables', ha='center', va='center',
        fontsize=12, color='white', fontweight='bold')

# Legend
table_labels = ['users', 'products', 'orders', 'events', 'sessions', 
                'metrics', 'credentials', 'tokens', 'app_logs', 'audit']
ax.legend(wedges_outer, table_labels, loc='center left', bbox_to_anchor=(1.05, 0.5),
          fontsize=9, frameon=True, facecolor='#1e293b', edgecolor='#334155',
          labelcolor='white', title='Tables', title_fontsize=10)

ax.set_title('Database Schema', fontsize=18, color='#f8fafc',
             fontweight='bold', pad=20)

plt.tight_layout()
plt.show()