ERD

erDiagram
  appointment_session {
    session_id INT PK
    organisation VARCHAR PK
  }
  appointment_session }|--|{ appointment_session_user : session_id
  appointment_session_user {
    session_id INT PK
    organisation VARCHAR FK
  }
  appointment_session }|--|{ location : location_guid
  location {
    organisation VARCHAR FK
    location_guid INT FK
  }
  appointment_session }|--|{ organisation : organisation_id
  organisation {
    organisation_id INT PK
    organisation VARCHAR FK
    organisation_guid VARCHAR
  }