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