ERD

erDiagram
    sensitive_snomed_code ||--o{ codeable_concept : "can get extra info"
    sensitive_snomed_code ||--o{ clinical_code : "for clinical code info"

    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
    }

    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
    }