org.organization_settings
Presentation-layer data for the org — legal name, address, logo, contact info. Singleton: one row per org, keyed by org_id.
Columns
| Column | Type | Notes |
|---|---|---|
org_id | UUID PK FK | → platform.organizations(id) ON DELETE CASCADE. |
legal_name | VARCHAR(255) | Often differs from platform.organizations.name. |
address | TEXT | |
city | VARCHAR(150) | |
state | VARCHAR(100) | |
country | CHAR(2) | ISO 3166-1 alpha-2. |
zip_code | VARCHAR(20) | |
logo_url | TEXT | GCS URL. Used on UI and documents. |
contact_email | VARCHAR(320) | |
contact_phone | VARCHAR(20) | |
created_at | TIMESTAMPTZ | NOT NULL. Default NOW(). |
updated_at | TIMESTAMPTZ | NOT NULL. Default NOW(). Auto-updated by trigger. |