ERD

erDiagram
  patient {
    emis_registration_id VARCHAR PK
    emis_registration_organisation_guid VARCHAR FK
    emis_usualgp_userinrole_guid VARCHAR FK
    ethnic_category_snomed_concept_id VARCHAR FK
    address_guid VARCHAR FK
    external_usualgp_guid VARCHAR FK
    study_id VARCHAR FK
    person_guid VARCHAR FK
  }

  organisation {
    emis_organisation_guid VARCHAR PK
  }

  user_in_role {
    emis_userinrole_guid VARCHAR PK
  }

  snomed_concept {
    snomed_concept_id VARCHAR PK
  }

  recruit_included_patients_view {
    emis_patient_id VARCHAR PK
    study_id VARCHAR
  }

  user_studies {
    study_id VARCHAR PK
  }

  patient }|--|{ organisation : "registered_at"
  patient }|--|{ user_in_role : "usual_gp"
  patient }|--|{ snomed_concept : "ethnic_category"
  patient }|--|{ recruit_included_patients_view : "in_study"
  patient }|--|{ user_studies : "in_study"