ERD

erDiagram
    problem {
        bigint    code_id                              FK
        varbinary consultation_id                      FK
        bigint    consultation_source_code_id          FK
        timestamp effective_datetime
        bigint    expected_duration
        boolean   is_deleted
        timestamp last_review_datetime
        timestamp model_updated_datetime
        varbinary observation_id                       PK
        varchar   organisation
        varbinary parent_problem_id                    FK
        varchar   parent_problem_relationship_description
        varbinary patient_id                           FK
        timestamp problem_end_datetime
        varchar   problem_event_type
        varchar   problem_significance_description
        varchar   problem_status_description
        bigint    snomed_concept_id
        timestamp transform_datetime
    }

    codeable_concept {
        bigint code_id PK
    }

    clinical_code {
        bigint code_id PK
    }

    consultation {
        varbinary consultation_id PK
    }

    patient {
        varbinary patient_id PK
    }

    problem }o--|| codeable_concept : "code_id"
    problem }o--|| clinical_code : "code_id"
    problem }o--|| consultation : "consultation_id"
    problem }o--|| codeable_concept : "consultation_source_code_id"
    problem }o--|| clinical_code : "consultation_source_code_id"
    problem }o--|| patient : "patient_id"
    problem }o--o| problem : "parent_problem_id"