erDiagram
SUBJECT_TYPE {
any id PK
string name
}
SUBJECT {
any id PK
any subject_type_id FK
}
SUBJECT_SUBJECT_TYPE_PROPERTY {
any subject_id FK
any subject_type_property_id FK
any value
}
SUBJECT_TYPE_PROPERTY {
any id PK
any subject_type_id FK
any property_id FK
}
PROPERTY {
any id PK
string key
}
SUBJECT_TYPE ||--o{ SUBJECT: ""
SUBJECT_TYPE ||--o{ SUBJECT_TYPE_PROPERTY: ""
SUBJECT ||--o{ SUBJECT_SUBJECT_TYPE_PROPERTY: ""
SUBJECT_SUBJECT_TYPE_PROPERTY }o--|| SUBJECT_TYPE_PROPERTY: ""
SUBJECT_TYPE_PROPERTY }o--|| PROPERTY: ""
Last active
December 4, 2023 16:36
-
-
Save sscovil/eb863245a3c91d1636a5a32022038164 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment