ERD

erDiagram
    referral {
        boolean   is_deleted
        bigint    code_id                      FK
        varbinary consultation_id              FK
        bigint    consultation_source_code_id  FK
        varchar   direction
        timestamp effective_datetime
        timestamp ended_datetime
        timestamp model_updated_datetime
        varbinary patient_id                   FK
        timestamp referral_made_datetime
        varchar   referral_mode_description
        varbinary referral_observation_id      PK
        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
    }

    patient {
        varbinary patient_id PK
    }

    consultation {
        varbinary consultation_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"
    referral }o--|| patient : "patient_id"
    referral }o--o| consultation : "consultation_id"