ERD

erDiagram
  mart_mds_emar {
    INT emar_history_id PK
    INT emar_history_item_id PK
    VARCHAR organisation PK
  }

  mds_emar {
    INT emar_history_id PK
    INT emar_history_item_id PK
    VARCHAR organisation PK
  }

  stg_emar_history {
    INT emar_history_id PK
    VARCHAR organisation PK
  }

  stg_emar_history_item {
    INT emar_history_item_id PK
    VARCHAR organisation PK
  }

  stg_pharmacy_patient {
    INT patient_id PK
    VARCHAR organisation PK
  }

  stg_nursing_home {
    INT nursing_home_id PK
    VARCHAR organisation PK
  }

  stg_nursing_home_type {
    INT nursing_home_type_id PK
  }

  dim_product_pack {
    INT pack_code_id PK
  }

  active_pharmacy {
    INT pharmacy_id PK
    VARCHAR organisation PK
  }

  stg_emar_history ||--o{ mds_emar : source
  stg_emar_history_item ||--o{ mds_emar : source
  stg_pharmacy_patient ||--o{ mds_emar : patient_context
  stg_nursing_home ||--o{ mds_emar : nursing_home_context
  stg_nursing_home_type ||--o{ mds_emar : nursing_home_type_context
  dim_product_pack ||--o{ mds_emar : product_context
  active_pharmacy ||--o{ mds_emar : pharmacy_context
  mds_emar ||--|| mart_mds_emar : builds