ERD

erDiagram
  mart_stock {
    INT stock_item_id PK
    VARCHAR organisation PK
  }

  stock {
    INT stock_item_id PK
    VARCHAR organisation PK
  }

  stg_stock_item {
    INT stock_item_id PK
    VARCHAR organisation PK
  }

  stg_pharmacy_pack_region {
    INT pack_code_id PK
  }

  stg_inventory_count_item {
    INT inventory_count_item_id PK
    VARCHAR organisation PK
  }

  stg_pharmacy_preparation {
    INT preparation_code_id PK
  }

  stg_pharmacy_preparation_region {
    INT preparation_code_id PK
  }

  dim_product_pack {
    INT pack_code_id PK
  }

  active_pharmacy {
    INT pharmacy_id PK
    VARCHAR organisation PK
  }

  stg_stock_item ||--o{ stock : source
  stg_pharmacy_pack_region ||--o{ stock : pack_region_context
  stg_inventory_count_item ||--o{ stock : inventory_context
  stg_pharmacy_preparation ||--o{ stock : prep_context
  stg_pharmacy_preparation_region ||--o{ stock : prep_region_context
  dim_product_pack ||--o{ stock : product_context
  active_pharmacy ||--o{ stock : pharmacy_context
  stock ||--|| mart_stock : builds