ERD

erDiagram
    mkb_mapping_dmdpreparation ||--o{ mkb_drugpack : "dmd preparation details"
    mkb_mapping_dmdpreparation  ||--o{ drug_code : "mapped to"

    mkb_mapping_dmdpreparation {
        boolean is_deleted
        bigint dmd_product_code_id
        bigint snomed_description_id
        bigint preparation_code_id
        varchar other_code
        varchar other_code_system
        varchar other_display
        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
        timestamp transform_datetime
        varchar _execution_date
    }

     mkb_drugpack {
        bigint preparation_pack_id PK
        bigint preparation_code_id FK
        varchar term
        bigint dmd_product_code_id FK
    }