ERD

erDiagram
    mkb_mapping_dmd_preparation ||--o{ mkb_drug_pack : "dmd preparation details"
    mkb_mapping_dmd_preparation ||--o{ drug_code : "mapped to"

    mkb_mapping_dmd_preparation {
        bigint    dmd_product_code_id
        boolean   is_deleted
        timestamp model_updated_datetime
        varchar   organisation
        varchar   other_code_system
        bigint    preparation_code_id  PK
        bigint    snomed_description_id
        timestamp transform_datetime
    }

    drug_code {
        bigint code_id PK
    }

    mkb_drug_pack {
        bigint preparation_pack_id PK
        bigint preparation_code_id FK
    }