erDiagram
bulk_admin_patient {
UNIQUEIDENTIFIER patientguid PK
UNIQUEIDENTIFIER organisationguid FK
UNIQUEIDENTIFIER usualgpuserinroleguid FK
UNIQUEIDENTIFIER externalusualgpguid FK
UNIQUEIDENTIFIER externalusualgporganisation FK
}
bulk_admin_organisation {
UNIQUEIDENTIFIER organisationguid PK
}
bulk_admin_userinrole {
UNIQUEIDENTIFIER userinroleguid PK
}
bulk_admin_patient }o--|| bulk_admin_organisation : organisationguid
bulk_admin_patient }o--o| bulk_admin_userinrole : usualgpuserinroleguid
bulk_admin_patient }o--o| bulk_admin_userinrole : externalusualgpguid
bulk_admin_patient }o--o| bulk_admin_organisation : externalusualgporganisation