ERD

erDiagram
  mart_rds {
    INT ods_order_id PK
    INT ods_order_item_id PK
    VARCHAR organisation PK
  }

  rds {
    INT ods_order_id PK
    INT ods_order_item_id PK
    VARCHAR organisation PK
  }

  stg_rds_ods_order {
    INT ods_order_id PK
    VARCHAR organisation PK
  }

  stg_rds_ods_order_item {
    INT ods_order_item_id PK
    VARCHAR organisation PK
  }

  stg_rds_ods_order_item_action {
    INT ods_order_item_action_id PK
    VARCHAR organisation PK
  }

  stg_rds_ods_order_item_status {
    INT ods_order_item_status_id PK
  }

  stg_rds_ods_order_item_tote {
    INT ods_order_item_tote_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_pharmacy_patient {
    INT patient_id PK
    VARCHAR organisation PK
  }

  stg_pharmacy_user {
    INT pharmacy_user_id PK
    VARCHAR organisation PK
  }

  stg_pharmacy_user_in_role {
    INT user_in_role_id PK
    VARCHAR organisation PK
  }

  stg_pharmacist {
    INT pharmacist_id PK
    VARCHAR organisation PK
  }

  active_pharmacy {
    INT pharmacy_id PK
    VARCHAR organisation PK
  }

  stg_rds_ods_order ||--o{ rds : source
  stg_rds_ods_order_item ||--o{ rds : source
  stg_rds_ods_order_item_action ||--o{ rds : action_context
  stg_rds_ods_order_item_status ||--o{ rds : status_context
  stg_rds_ods_order_item_tote ||--o{ rds : tote_context
  stg_prescription ||--o{ rds : prescription_context
  stg_prescription_item ||--o{ rds : prescription_item_context
  stg_pharmacy_patient ||--o{ rds : patient_context
  stg_pharmacy_user ||--o{ rds : user_context
  stg_pharmacy_user_in_role ||--o{ rds : role_context
  stg_pharmacist ||--o{ rds : pharmacist_context
  active_pharmacy ||--o{ rds : pharmacy_context
  rds ||--|| mart_rds : builds