| is_deleted | boolean | Deletion status flag | true/false |
| code_id | bigint | EMIS Web Code ID | 2986010 |
| term | varchar | Code ID term | Solar retinopathy |
| snomed_concept_id | bigint | SNOMED Concept ID | 123456789 |
| snomed_description_id | bigint | SNOMED Concept ID description | 0358791000 |
| fully_specified_name | varchar | SNOMED fully specified name | Solar retinopathy (disorder) |
| readv2_code | varchar | Old readv2 code | F404400 |
| other_code_system | varchar | Other system http address | website link |
| other_code | varchar | Other EMIS old codes | DRGC6020BRIDL |
| other_display | varchar | Other EMIS code terms | Aluminium Chlorhydroxide Complex |
| organisation | varchar | EMIS source | EMIS |
| transform_datetime | timestamp(6) with time zone | Transformation timestamp | 2023-05-12 14:30:15.000000 UTC |
| 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 |