SaaS multi-tenant data model

erDiagram
    ORGANIZATION ||--o{ USER : employs
    ORGANIZATION ||--o{ SUBSCRIPTION : has
    PLAN ||--o{ SUBSCRIPTION : "priced by"
    ORGANIZATION ||--o{ PROJECT : owns
    USER }o--o{ PROJECT : "member of"
    ORGANIZATION {
        int id PK
        string name
        string billing_email
    }
    USER {
        int id PK
        int org_id FK
        string email
        string role
    }
    SUBSCRIPTION {
        int id PK
        int org_id FK
        int plan_id FK
        string status
        date renews_at
    }
    PLAN {
        int id PK
        string name
        decimal monthly_price
    }
    PROJECT {
        int id PK
        int org_id FK
        string name
    }