ERD

erDiagram
  mart_nms {
    INT nms_id PK
    VARCHAR organisation PK
  }

  nms {
    INT nms_id PK
    VARCHAR organisation PK
  }

  stg_nms {
    INT nms_id PK
    VARCHAR organisation PK
  }

  stg_nms_drug {
    INT nms_id PK
    VARCHAR organisation PK
  }

  stg_nms_not_attended_reason {
    INT nms_not_attended_reason_id PK
  }

  stg_appointment_session_nms {
    INT appointment_session_nms_id PK
    VARCHAR organisation PK
  }

  stg_pharmacy_patient {
    INT patient_id PK
    VARCHAR organisation PK
  }

  stg_patient_identifier {
    VARCHAR unique_patient_id PK
    VARCHAR organisation PK
  }

  stg_patient_contact {
    VARCHAR unique_patient_id PK
    VARCHAR organisation PK
  }

  stg_pharmacist {
    INT pharmacist_id PK
    VARCHAR organisation PK
  }

  dim_preparation {
    INT preparation_code_id PK
  }

  active_pharmacy {
    INT pharmacy_id PK
    VARCHAR organisation PK
  }

  stg_nms ||--o{ nms : source
  stg_nms_drug ||--o{ nms : source
  stg_nms_not_attended_reason ||--o{ nms : reason_lookup
  stg_appointment_session_nms ||--o{ nms : session_context
  stg_pharmacy_patient ||--o{ nms : patient_context
  stg_patient_identifier ||--o{ nms : identifier_context
  stg_patient_contact ||--o{ nms : contact_context
  stg_pharmacist ||--o{ nms : pharmacist_context
  dim_preparation ||--o{ nms : product_context
  active_pharmacy ||--o{ nms : pharmacy_context
  nms ||--|| mart_nms : builds