Schema

Schema Overview

Column Name	Data Type	Description	Example
dmd_product_code_id	bigint	Dictionary of Medicines and Devices (dm+d) product identifier; also a SNOMED CT concept identifier	12354611500001104
is_deleted	boolean	If this record should be considered soft deleted; all columns excluding primary keys will be NULL if TRUE	false
model_updated_datetime	timestamp(6) with time zone	Date and time the model last updated this record	2023-05-12 14:30:15.000000 UTC
organisation	varchar	The organisation that this data was replicated from. Will be ‘EMIS’ for all records in this table	EMIS
other_code_system	varchar	Other system http address	website link
preparation_code_id	bigint	EMIS code ID - internal identifier	123546
snomed_description_id	bigint	Dictionary of Medicines and Devices (dm+d) product identifier; also a SNOMED CT concept identifier	330690010
transform_datetime	timestamp(6) with time zone	Date and time the data was made available in the model with a relevant change	2023-05-12 14:30:15.000000 UTC