Skip to content

Instantly share code, notes, and snippets.

@peteryates

peteryates/schema.md

Created November 30, 2023 14:11
Show Gist options
  • Save peteryates/8bb6cf9660461e8a9a0468f36395486e to your computer and use it in GitHub Desktop.
Save peteryates/8bb6cf9660461e8a9a0468f36395486e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
schema.md 
erDiagram
    User ||--o{ Application : makes
    Application ||--o{ Course : "for a"
    Application ||--o{ "Lead Provider" : "provides"
    School o|--o{ "Application" : ""
    "Private childcare provider" o|--o{ Application : ""
    Cohort ||--o{ Application : ""
    Cohort ||--o{ Statement : ""
    Cohort ||--o{ Schedule : "belongs to" 
    Milestone }o--o{ Schedule : ""
    Statement ||--o{ "Statement line item" : ""
    Declaration ||--o{ "Statement line item" : ""
    %% Contract ||--o{ Statement : "" - confirm with Shahad
    Contract ||--o{ Cohort : ""
    Contract ||--o{ "Lead provider"  : ""
    Contract ||--o{ Course : ""
Loading
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment