ERD

erDiagram
  session {
    emis_session_guid VARCHAR PK
    emis_location_guid VARCHAR FK
    emis_session_organisation_guid VARCHAR FK
  }

  location {
    emis_location_guid VARCHAR PK
  }

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  session }|--|{ location : "held_at_location"
  session }|--|{ organisation : "in_organisation"