erDiagram
bulk_carerecord_problem {
UNIQUEIDENTIFIER observationguid PK
UNIQUEIDENTIFIER patientguid FK
UNIQUEIDENTIFIER organisationguid FK
UNIQUEIDENTIFIER parentproblemobservationguid FK
UNIQUEIDENTIFIER lastreviewuserinroleguid FK
}
bulk_carerecord_observation {
UNIQUEIDENTIFIER observationguid PK
}
bulk_admin_patient {
UNIQUEIDENTIFIER patientguid PK
}
bulk_admin_organisation {
UNIQUEIDENTIFIER organisationguid PK
}
bulk_admin_userinrole {
UNIQUEIDENTIFIER userinroleguid PK
}
bulk_carerecord_problem }o--|| bulk_carerecord_observation : observationguid
bulk_carerecord_problem }o--|| bulk_admin_patient : patientguid
bulk_carerecord_problem }o--|| bulk_admin_organisation : organisationguid
bulk_carerecord_problem }o--o| bulk_admin_userinrole : lastreviewuserinroleguid