ERD

erDiagram
    drug_code ||--o{ mkb_drugpack : "preparation details"

    mkb_drugpack {
        boolean is_deleted
        bigint preparation_code_id
        bigint preparation_pack_id PK
        varchar supplier_name
        varchar term
        bigint dmd_product_code_id FK
        varchar pack_description
        double units_per_pack
        varchar unit_of_measure
        real pack_price
        real price_per_unit
        boolean is_guide_price_pack
        boolean is_breakable
        varchar organisation
        timestamp transform_datetime
        varchar _execution_date
    }

    drug_code {
        boolean is_deleted
        varchar organisation
        bigint code_id PK
        varchar old_code
        varchar term
        bigint dmd_product_code_id FK
    }