ERD

erDiagram
  drug_record_problem_link {
    emis_observation_guid VARCHAR PK
    emis_drug_guid VARCHAR FK
    pseudo_registration_guid VARCHAR FK
    pseudo_patient_id VARCHAR FK
    emis_registration_organisation_guid VARCHAR FK
    study_id VARCHAR FK
  }

  patient {
    registration_guid VARCHAR PK
  }

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  drug_record {
    emis_drug_guid VARCHAR PK
  }

  problem {
    emis_observation_guid VARCHAR PK
  }

  recruit_included_patients_view {
    emis_patient_id VARCHAR PK
  }

  user_studies {
    study_id VARCHAR PK
  }

  drug_record_problem_link }|--|{ patient : "registered_to"
  drug_record_problem_link }|--|{ organisation : "in_organisation"
  drug_record_problem_link }|--|{ drug_record : "for_drug"
  drug_record_problem_link }|--|{ problem : "for_problem"
  drug_record_problem_link }|--|{ recruit_included_patients_view : patient_link
  drug_record_problem_link }|--|{ user_studies : study_link