db_diagram.md

Database Diagram

erDiagram
    auth_users {
        uuid id PK
        text email
        text encrypted_password
        text phone
        timestamptz created_at
        timestamptz updated_at
        timestamptz last_sign_in_at
        timestamptz email_confirmed_at
        timestamptz phone_confirmed_at
        boolean is_active
    }
    profiles {
        uuid id PK
        text first_name
        text last_name
        text email
        boolean isAdmin
        boolean isStaff
        timestamptz created_at
    }
    classes {
        uuid id PK
        text title
        text description
        timestamptz created_at
        timestamptz updated_at
        uuid created_by
    }
    resources {
        uuid id PK
        text title
        text description
        text url
        timestamptz created_at
        timestamptz updated_at
        uuid class_id FK
        uuid created_by
    }
    projects {
        uuid id PK
        text title
        text description
        uuid class_id FK
        jsonb requirements
        jsonb passing_criteria
        timestamptz created_at
        timestamptz updated_at
        uuid created_by
    }
    submissions {
        uuid id PK
        uuid project_id FK
        uuid student_id FK
        text demo_video_url
        text github_url
        text deployed_url
        text planning_doc_url
        text social_post_url
        boolean is_passing
        text feedback
        jsonb evaluation_results
        integer submission_number
        timestamptz created_at
        timestamptz updated_at
        timestamptz reviewed_at
        uuid reviewed_by FK
    }

    auth_users ||--|| profiles : ""
    classes ||--o{ resources : "class_id"
    classes ||--o{ projects : "class_id"
    projects ||--o{ submissions : "project_id"
    profiles ||--o{ submissions : "student_id"
    profiles ||--o{ classes : "created_by"
    profiles ||--o{ projects : "created_by"
    profiles ||--o{ resources : "created_by"
    profiles ||--o{ submissions : "reviewed_by"

Loading