| is_deleted | boolean | If this record should be considered soft deleted | FALSE |
| dmd_product_code_id | bigint | Dictionary of Medicines and Devices (dm+d) product identifier | 12354611500001104 |
| snomed_description_id | bigint | ID of the preferred SNOMED description | 330690010 |
| preparation_code_id | bigint | EMIS code_id - internal identifier for the drug preparation | 123546 |
| other_code | varchar | NULL | NULL |
| other_code_system | varchar | Other system http address | website link |
| other_display | varchar | NULL | NULL |
| organisation | varchar | The organisation that this data was replicated from | ’EMIS’ |
| transform_datetime | timestamp | The datetime that the data was made available in the model with a relevant change | ’2023-05-12 14:30:15.000 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 |
