ERD

erDiagram
    medication_issue_record {
        timestamp cancellation_datetime
        bigint    code_id                         FK
        varbinary consultation_id                 FK
        bigint    consultation_source_code_id     FK
        bigint    course_duration_in_days
        bigint    dmd_product_code_id
        varchar   dosage
        varbinary drug_record_id                  FK
        timestamp effective_datetime
        decimal   estimated_nhs_cost
        boolean   is_cancelled
        boolean   is_deleted
        boolean   is_prescribed_as_contraceptive
        boolean   is_privately_prescribed
        varchar   issue_method_description
        varbinary issue_record_id                 PK
        varchar   local_mixture_name
        bigint    max_next_issue_days
        bigint    min_next_issue_days
        timestamp model_updated_datetime
        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
    }

    consultation {
        varbinary consultation_id PK
    }

    medication_drug_record {
        varbinary drug_record_id PK
    }

    drug_code {
        bigint code_id PK
    }

    mkb_mapping_dmd_preparation {
        bigint preparation_code_id PK
    }

    clinical_code {
        bigint code_id PK
    }

    codeable_concept {
        bigint code_id PK
    }

    medication_issue_record }o--|| patient : "patient_id"
    medication_issue_record }o--|| consultation : "consultation_id"
    medication_issue_record }o--|| drug_record : "drug_record_id"
    medication_issue_record }o--|| drug_code : "code_id"
    medication_issue_record }o--|| mkb_mapping_dmd_preparation : "code_id"
    medication_issue_record }o--|| clinical_code : "consultation_source_code_id"
    medication_issue_record }o--|| codeable_concept : "consultation_source_code_id"