ERD

erDiagram
    referral {
        bigint    code_id                      FK
        varbinary consultation_id
        bigint    consultation_source_code_id  FK
        varchar   direction
        timestamp effective_datetime
        timestamp ended_datetime
        boolean   is_deleted
        timestamp model_updated_datetime
        varchar   organisation
        varbinary patient_id
        timestamp referral_made_datetime
        varchar   referral_mode_description
        varbinary referral_observation_id
        bigint    service_type_id              FK
        timestamp transform_datetime
        bigint    urgency
        varchar   urgency_description
    }

    codeable_concept {
        bigint code_id PK
    }

    clinical_code {
        bigint code_id PK
    }

    referral }o--|| codeable_concept : "code_id"
    referral }o--|| clinical_code : "code_id"
    referral }o--|| codeable_concept : "consultation_source_code_id"
    referral }o--|| clinical_code : "consultation_source_code_id"
    referral }o--|| codeable_concept : "service_type_id"
    referral }o--|| clinical_code : "service_type_id"