ERD

erDiagram
  mart_dmr {
    INT dmr_id PK
    INT eligibility_criterium_id PK
    VARCHAR organisation PK
    VARCHAR unique_patient_id FK
  }

  dmr {
    INT dmr_id PK
    VARCHAR organisation PK
  }

  stg_dmr {
    INT dmr_id PK
    VARCHAR organisation PK
  }

  stg_pharmacist {
    INT pharmacist_id PK
    VARCHAR organisation PK
  }

  dmr_eligibility_criterium {
    INT dmr_id PK
    INT eligibility_criterium_id PK
    VARCHAR organisation PK
  }

  active_pharmacy {
    INT pharmacy_id PK
    VARCHAR organisation PK
  }

  mart_patient {
    VARCHAR unique_patient_id PK
    VARCHAR organisation PK
  }

  stg_dmr ||--o{ dmr : source
  stg_pharmacist ||--o{ dmr : pharmacist_context
  dmr_eligibility_criterium ||--o{ dmr : eligibility
  active_pharmacy ||--o{ dmr : pharmacy_context
  mart_patient ||--o{ dmr : patient_context
  dmr ||--|| mart_dmr : builds
  mart_dmr }o--|| mart_patient : unique_patient_id