ERD

erDiagram
    drug_code ||--o{ mkb_mapping_dmd_preparation : "mapped to"
    drug_code ||--o{ mkb_drug_pack : "supplies pack info for"

    drug_code {
        bigint    code_id                PK
        bigint    dmd_product_code_id
        boolean   is_deleted
        timestamp model_updated_datetime
        varchar   old_code
        varchar   organisation
        varchar   term
        timestamp transform_datetime
    }

    mkb_mapping_dmd_preparation {
        bigint dmd_product_code_id
        bigint preparation_code_id PK
        varchar organisation
    }

    mkb_drug_pack {
        bigint preparation_pack_id
        bigint preparation_code_id PK
        varchar term
        bigint dmd_product_code_id
    }