ERD

erDiagram

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

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

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