erDiagram
mkb_drug_pack {
bigint dmd_product_code_id
boolean is_breakable
boolean is_deleted
boolean is_divisible
boolean is_guide_price_pack
timestamp model_updated_datetime
varchar organisation
varchar pack_description
real pack_price
bigint preparation_code_id FK
bigint preparation_pack_id PK
real price_per_unit
varchar supplier_name
varchar term
timestamp transform_datetime
varchar unit_of_measure
double units_per_pack
}
drug_code {
bigint code_id PK
}
mkb_mapping_dmd_preparation {
bigint preparation_code_id PK
}
mkb_drug_pack }o--|| drug_code : "preparation_code_id"
mkb_drug_pack }o--|| mkb_mapping_dmd_preparation : "preparation_code_id"