ERD

erDiagram
    observation {
        bigint    code_id                      FK
        varbinary consultation_id              FK
        varbinary consultation_section_id      FK
        bigint    consultation_source_code_id  FK
        timestamp effective_datetime
        bigint    episodicity
        varchar   episodicity_description
        boolean   is_deleted
        boolean   is_parent
        boolean   is_problem
        boolean   is_referral
        timestamp model_updated_datetime
        varchar   numeric_operator
        varchar   numeric_unit
        decimal   numeric_value
        varbinary observation_id               PK
        varchar   observation_type_description
        bigint    observation_type_id
        varchar   organisation
        varbinary parent_observation_id
        varbinary patient_id                   FK
        timestamp problem_end_datetime
        boolean   problem_is_deleted
        varbinary problem_observation_id       FK
        decimal   range_maximum
        varchar   range_maximum_operator
        varchar   range_maximum_text
        decimal   range_minimum
        varchar   range_minimum_operator
        varchar   range_minimum_text
        varchar   range_qualifier_description
        varchar   range_units
        bigint    snomed_concept_id
        timestamp transform_datetime
    }

    codeable_concept {
        bigint code_id PK
    }

    clinical_code {
        bigint code_id PK
    }

    consultation {
        varbinary consultation_id PK
    }

    consultation_section {
        varbinary consultation_section_id PK
    }

    patient {
        varbinary patient_id PK
    }

    problem {
        varbinary observation_id PK
    }

    observation }o--|| codeable_concept : "code_id"
    observation }o--|| clinical_code : "code_id"
    observation }o--|| consultation : "consultation_id"
    observation }o--|| consultation_section : "consultation_section_id"
    observation }o--|| codeable_concept : "consultation_source_code_id"
    observation }o--|| clinical_code : "consultation_source_code_id"
    observation }o--|| patient : "patient_id"
    observation }o--o| problem : "problem_observation_id"