ERD

erDiagram
  drug_record {
    emis_drug_guid VARCHAR PK
    emis_registration_guid VARCHAR FK
    patient_id VARCHAR FK
    emis_medication_organisation_guid VARCHAR FK
    emis_code_id VARCHAR FK
    study_id VARCHAR FK
  }

  patient {
    emis_registration_id VARCHAR PK
  }

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  drug_code {
    emis_code_id VARCHAR PK
  }

  recruit_included_patients_view {
    emis_patient_id VARCHAR PK
    study_id VARCHAR
  }

  user_studies {
    study_id VARCHAR PK
  }

  drug_record }|--|{ patient : "registered_to"
  drug_record }|--|{ organisation : "prescribed_at"
  drug_record }|--|{ drug_code : "uses_code"
  drug_record }|--|{ recruit_included_patients_view : "for_patient"
  drug_record }|--|{ user_studies : "in_study"