ERD

erDiagram
  observation {
    emis_observation_guid VARCHAR PK
    emis_registration_guid VARCHAR FK
    patient_id VARCHAR FK
    emis_registration_organisation_guid VARCHAR FK
    emis_authorising_userinrole_guid VARCHAR FK
    emis_enteredby_userinrole_guid VARCHAR FK
    emis_parent_observation_guid VARCHAR FK
    emis_code_id VARCHAR FK
    emis_problem_observation_guid VARCHAR FK
    emis_consultation_guid VARCHAR FK
    study_id VARCHAR FK
  }

  patient {
    emis_registration_id VARCHAR PK
  }

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  user_in_role {
    emis_userinrole_guid VARCHAR PK
  }

  consultation {
    emis_consultation_guid VARCHAR PK
  }

  observation || -- o{ observation : "parent_observation"

  clinical_code {
    emis_code_id VARCHAR PK
  }

  recruit_included_patients_view {
    emis_patient_id VARCHAR PK
    study_id VARCHAR
  }

  user_studies {
    study_id VARCHAR PK
  }

  problem {
    emis_observation_guid VARCHAR PK
  }

  observation }|--|{ patient : "registered_to"
  observation }|--|{ organisation : "in_organisation"
  observation }|--|{ user_in_role : "authorised_by"
  observation }|--|{ user_in_role : "entered_by"
  observation }|--|{ observation : "parent_observation"
  observation }|--|{ problem : "for_problem"
  observation }|--|{ consultation : "part_of"
  observation }|--|{ clinical_code : "uses_code"
  observation }|--|{ recruit_included_patients_view : "for_patient"
  observation }|--|{ user_studies : "in_study"