ERD

erDiagram
    drug_code ||--o{ mkb_mapping_dmdpreparation : "mapped to"
    drug_code ||--o{ mkb_drugpack : "supplies pack info for"

    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_mapping_dmdpreparation {
        bigint dmd_product_code_id PK
        bigint preparation_code_id FK
        varchar organisation
    }

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

    dim_code_v1 ||--|{ drug_code : "sources"