ERD

erDiagram

    codeable_concept ||--o{ clinical_code : "for other info"

   clinical_code {
        boolean is_deleted
        varchar organisation
        bigint code_id
        bigint parent_code_id
        varchar term
        varchar read_term_id
        varchar readv2_code
        bigint snomed_concept_id
        bigint snomed_description_id
        varchar national_code_category
        varchar national_code
        varchar national_description
        varchar emis_code_category_description
        timestamp transform_datetime
        varchar _execution_date
    }

    codeable_concept {
        boolean is_deleted
        bigint code_id PK
        varchar term
        bigint snomed_concept_id FK
        bigint snomed_description_id
        varchar fully_specified_name
        varchar readv2_code
        varchar other_code_system
        varchar other_code
        varchar other_display
        varchar organisation
        timestamp transform_datetime
        varchar _execution_date
    }