| is_deleted | BOOLEAN | Flag indicating if the code is deleted (or deprecated) | false |
| code_id | BIGINT | Unique identifier for the ethnicity code (Primary Key) | 12345 |
| snomed_concept_id | BIGINT | SNOMED CT concept identifier (nullable) | 186034007 |
| snomed_description | VARCHAR | Human-readable description of the SNOMED concept | ’White British’ |
| snomed_description_id | BIGINT | ID of the preferred SNOMED description | 234567 |
| organisation | VARCHAR | Identifier for the data source, always ‘EMIS' | 'EMIS’ |
| transform_datetime | TIMESTAMP(6) WITH TIME ZONE | Timestamp when the record was last transformed | ’2023-05-12 14:30:15+00’ |
| model_last_update | timestamp(6) with time zone | Timestamp indicating when the model last updated this record (data type to be confirmed). | 2024-01-15 10:30:45 |