ERD

erDiagram
    clinical_code ||--o{ codeable_concept : "for other info"
    clinical_code ||--o{ sensitive_snomed_code : "for sensitive SNOMED codes only"


   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
    }


    sensitive_snomed_code {
        bigint  code_id            PK
        boolean is_deleted
        timestamp model_updated_datetime
        varchar organisation
        bigint  snomed_concept_id
        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
    }