ERD

erDiagram
  slot {
    emis_appointment_slot_guid VARCHAR PK
    pseudo_registration_guid VARCHAR FK
    pseudo_patient_id VARCHAR FK
    emis_session_organisation_guid VARCHAR FK
    emis_session_guid VARCHAR FK
    study_id VARCHAR FK
  }

  patient {
    registration_guid VARCHAR PK
  }

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  session {
    emis_session_guid VARCHAR PK
  }

  recruit_included_patients_view {
    emis_patient_id VARCHAR PK
    study_id VARCHAR
  }

  user_studies {
    study_id VARCHAR PK
  }

  user_studies {
    study_id VARCHAR PK
  }

  slot }|--|{ patient : "registered_to"
  slot }|--|{ organisation : "in_organisation"
  slot }|--|{ session : "in_session"
  slot }|--|{ recruit_included_patients_view : "for_patient"
  slot }|--|{ user_studies : "in_study"