ERD

erDiagram
    diary {
        bigint    code_id                     FK
        varbinary consultation_id             FK
        varbinary consultation_section_id     FK
        bigint    consultation_source_code_id FK
        varbinary diary_id                    PK
        varchar   duration_term
        timestamp effective_datetime
        boolean   is_active
        boolean   is_complete
        boolean   is_deleted
        timestamp model_updated_datetime
        varchar   organisation
        varbinary patient_id
        bigint    snomed_concept_id
        timestamp transform_datetime
    }

    clinical_code {
        bigint code_id PK
    }

    codeable_concept {
        bigint code_id PK
    }

    consultation {
        varbinary consultation_id PK
    }

    consultation_section {
        varbinary consultation_section_id PK
    }

    diary }o--|| clinical_code : "code_id"
    diary }o--|| codeable_concept : "code_id"
    diary }o--|| consultation : "consultation_id"
    diary }o--|| consultation_section : "consultation_section_id"
    diary }o--|| clinical_code : "consultation_source_code_id"
    diary }o--|| codeable_concept : "consultation_source_code_id"