The living blueprint of our sanctuary. Every table, every relationship, every column—always accurate, always transparent.
| Column | Type | Nullable | Description |
|---|---|---|---|
| avatar_url | TEXT | ✓ | — |
| banner_url | TEXT | ✓ | — |
| bio | TEXT | ✓ | — |
| created_at | TEXT | ✗ | — |
| created_by | TEXT | ✓ | — |
| display_name | TEXT | ✗ | — |
| icon_emoji | TEXT | ✓ | — |
| id | TEXT | ✗ | — |
| sensory_hints | TEXT | ✓ | — |
| slug | TEXT | ✗ | — |
| social_links | JSONB | ✓ | — |
| sovereign_tier | SovereignTier | ✗ | — |
| status | ProfileStatus | ✗ | — |
| updated_at | TEXT | ✗ | — |
| updated_by | TEXT | ✓ | — |
| website_url | TEXT | ✓ | — |
| Column | Type | Nullable | Description |
|---|---|---|---|
| cover_url | TEXT | ✓ | — |
| created_at | TEXT | ✗ | — |
| created_by | TEXT | ✗ | — |
| currency | TEXT | ✗ | — |
| description | TEXT | ✓ | — |
| icon_emoji | TEXT | ✓ | — |
| id | TEXT | ✗ | — |
| media_urls | string[] | ✓ | — |
| metadata | JSONB | ✓ | — |
| name | TEXT | ✗ | — |
| price | DECIMAL | ✓ | — |
| pricing_model | PricingModel | ✗ | — |
| quantity_available | DECIMAL | ✓ | — |
| quantity_sold | DECIMAL | ✗ | — |
| requires_shipping | BOOLEAN | ✗ | — |
| residual_pool_percent | DECIMAL | ✓ | — |
| shipping_info | JSONB | ✓ | — |
| slug | TEXT | ✗ | — |
| status | ContentStatus | ✗ | — |
| updated_at | TEXT | ✗ | — |
| updated_by | TEXT | ✓ | — |
| ware_type | WareType | ✗ | — |
Every table has Row Level Security enabled. Vessels can only access their own data. Admins have elevated access. All policies are public and auditable.