ERD

erDiagram
  mart_fridge_log {
    INT fridge_log_id PK
    VARCHAR organisation PK
  }

  fridge_log {
    INT fridge_log_id PK
    VARCHAR organisation PK
  }

  stg_fridge_log {
    INT fridge_log_id PK
    VARCHAR organisation PK
  }

  stg_location {
    INT location_id PK
    VARCHAR organisation PK
  }

  stg_pharmacy {
    INT pharmacy_id PK
    VARCHAR organisation PK
  }

  active_pharmacy {
    INT pharmacy_id PK
    VARCHAR organisation PK
  }

  stg_fridge_log ||--o{ fridge_log : source
  stg_location ||--o{ fridge_log : location_context
  stg_pharmacy ||--o{ active_pharmacy : source
  active_pharmacy ||--o{ fridge_log : pharmacy_context
  fridge_log ||--|| mart_fridge_log : builds