erDiagram
bulk_appointment_slot {
UNIQUEIDENTIFIER slotguid PK
UNIQUEIDENTIFIER patientguid FK
UNIQUEIDENTIFIER organisationguid FK
UNIQUEIDENTIFIER sessionguid FK
BIGINT dnareasoncodeid FK
}
bulk_admin_patient {
UNIQUEIDENTIFIER patientguid PK
}
bulk_admin_organisation {
UNIQUEIDENTIFIER organisationguid PK
}
bulk_appointment_session {
UNIQUEIDENTIFIER appointmentsessionguid PK
}
bulk_clinicalcode {
BIGINT codeid PK
}
bulk_appointment_slot }o--|| bulk_admin_patient : patientguid
bulk_appointment_slot }o--|| bulk_admin_organisation : organisationguid
bulk_appointment_slot }o--|| bulk_appointment_session : sessionguid
bulk_appointment_slot }o--o| bulk_clinicalcode : dnareasoncodeid