ERD

erDiagram
  mart_mds {
    INT mds_item_id PK
    VARCHAR organisation PK
  }

  mds {
    INT mds_item_id PK
    VARCHAR organisation PK
  }

  stg_mds_item {
    INT mds_item_id PK
    VARCHAR organisation PK
  }

  stg_prescription {
    INT prescription_id PK
    VARCHAR organisation PK
  }

  stg_prescription_item {
    INT prescription_item_id PK
    VARCHAR organisation PK
  }

  stg_prescription_item_dispensed {
    INT prescription_item_dispensed_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_mds_item ||--o{ mds : source
  stg_prescription ||--o{ mds : prescription_context
  stg_prescription_item ||--o{ mds : prescription_item_context
  stg_prescription_item_dispensed ||--o{ mds : dispensing_context
  stg_pharmacy_patient ||--o{ mds : patient_context
  stg_nursing_home ||--o{ mds : nursing_home_context
  stg_nursing_home_type ||--o{ mds : nursing_home_type_context
  dim_product_pack ||--o{ mds : product_context
  active_pharmacy ||--o{ mds : pharmacy_context
  mds ||--|| mart_mds : builds