ERD

erDiagram
  appointment_slot {
    slot_id INT PK
    organisation VARCHAR PK
    session_id INT FK
    patient_id INT FK
    session_organisation_id VARCHAR FK
  }
  appointment_slot }|--|{ appointment_session : session_id
  appointment_session {
    session_id INT PK
    organisation VARCHAR FK
  }
  appointment_slot }|--|{ patient : patient_id
  patient {
    patient_id INT PK
    organisation VARCHAR FK
  }
  appointment_slot }|--|{ organisation : session_organisation_id
  organisation {
    organisation_id INT PK
    organisation VARCHAR FK
    organisation_guid VARCHAR
  }