ERD

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


   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
    }


    sensitive_snomed_code {
        boolean is_deleted
        varchar organisation
        bigint concept_id
        bigint code_id PK
        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

    }