ERD

erDiagram
  location {
    location_id BIGINT PK
    organisation VARCHAR PK, FK
    parent_location_id BIGINT FK
    location_guid VARCHAR
    address_id BIGINT
  }

  location }|--|| organisation : organisation
  organisation {
    organisation_id BIGINT PK
    organisation VARCHAR PK
    organisation_guid VARCHAR
  }

  location }|--|| location : parent_location_id

  location ||--o{ appointment_session : location_id
  appointment_session {
    session_id BIGINT PK
    organisation VARCHAR PK, FK
    location_id BIGINT FK
    location_guid VARCHAR
  }