erDiagram
    USER ||--o{ PROJECT : owns
    PROJECT ||--o{ TASK : contains
    USER o|--o{ TASK : assigned
    USER {
        int user_id PK
        string name
    }
    PROJECT {
        int project_id PK
        int owner_id FK
        string title
    }
    TASK {
        int task_id PK
        int project_id FK
        int assignee_id FK
        string status
    }