ERD

erDiagram
  bulk_appointment_session {
    UNIQUEIDENTIFIER appointmentsessionguid PK
    UNIQUEIDENTIFIER locationguid FK
    UNIQUEIDENTIFIER organisationguid FK
  }

  bulk_admin_location {
    UNIQUEIDENTIFIER locationguid PK
  }

  bulk_admin_organisation {
    UNIQUEIDENTIFIER organisationguid PK
  }

  bulk_appointment_session }o--|| bulk_admin_location : locationguid
  bulk_appointment_session }o--|| bulk_admin_organisation : organisationguid