ERD

erDiagram
    medication_drug_record {
        timestamp authorised_course_datetime
        timestamp cancellation_datetime
        bigint    code_id                              FK
        bigint    course_duration_in_days
        bigint    dmd_product_code_id
        varchar   dosage
        varbinary drug_record_id                       PK
        timestamp effective_datetime
        timestamp expiry_datetime
        timestamp first_issue_datetime
        boolean   is_deleted
        boolean   is_prescribed_as_contraceptive
        boolean   is_privately_prescribed
        bigint    issued_count
        varchar   local_mixture_name
        bigint    max_next_issue_days
        bigint    min_next_issue_days
        timestamp model_updated_datetime
        timestamp most_recent_issue_datetime
        varchar   most_recent_issue_method_description
        bigint    number_of_issues_authorised
        varchar   organisation
        varbinary patient_id                           FK
        varchar   prescription_type_description
        decimal   quantity
        decimal   quantity_multiplicand
        decimal   quantity_multiplier
        varchar   quantity_multiplier_uom
        varchar   quantity_representation
        varchar   quantity_unit
        timestamp review_date
        timestamp transform_datetime
    }

    patient {
        varbinary patient_id PK
    }

    drug_code {
        bigint code_id PK
    }

    mkb_mapping_dmd_preparation {
        bigint preparation_code_id  PK
    }

    medication_drug_record }o--|| patient : "patient_id"
    medication_drug_record }o--|| drug_code : "code_id"
    medication_drug_record }o--|| mkb_mapping_dmd_preparation : "code_id"