Schema

Schema Overview

Column Name	Data Type	Description	Example
code_id	bigint	EMIS code ID - internal identifier	123456789
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
old_code	varchar	EMIS old code	PICC555
organisation	varchar	The organisation that this data was replicated from. Will be ‘EMIS’ for all records in this table	EMIS
term	varchar	Description of EMIS Code ID	Paracetamol 500mg tablets
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