ERD

erDiagram
    consultation_section {
        varbinary consultation_id                          FK
        varbinary consultation_section_id                 PK
        varchar   consultation_section_original_heading
        bigint    consultation_source_code_id             FK
        timestamp effective_datetime
        varbinary event_id                                FK
        boolean   is_complete
        boolean   is_deleted
        timestamp model_updated_datetime
        varchar   organisation
        varbinary patient_id                              FK
        timestamp transform_datetime
    }

    consultation {
        varbinary consultation_id PK
    }

    clinical_code {
        bigint code_id PK
    }

    codeable_concept {
        bigint code_id PK
    }

    observation {
        varbinary observation_id PK
    }

    diary {
        varbinary diary_id PK
    }

    medication_issue_record {
        varbinary issue_record_id PK
    }

    patient {
        varbinary patient_id PK
    }

    consultation_section }o--|| consultation : "consultation_id"
    consultation_section }o--|| patient : "patient_id"
    consultation_section }o--|| clinical_code : "consultation_source_code_id"
    consultation_section }o--|| codeable_concept : "consultation_source_code_id"
    consultation_section }o--o| observation : "event_id"
    consultation_section }o--o| diary : "event_id"
    consultation_section }o--o| medication_issue_record : "event_id"