Schema

Schema Overview

Column Name	Data Type	Description	Example
is_deleted	boolean	If this record should be considered soft deleted	FALSE
code_id	bigint	PK EMIS code - internal identifier for the drug code	123456789
old_code	varchar	Original code of entity assigned within CDI authoring platform - read code, drug code etc.	‘PICC555’
term	varchar	Description of the drug or medication	’Paracetamol 500mg tablets’
dmd_product_code_id	bigint	Dictionary of Medicines and Devices (dm+d) product identifier	12354611500001104
organisation	varchar	The organisation that this data was replicated from	’EMIS’
transform_datetime	timestamp(6) with time zone	The datetime that the data was made available in the model with a relevant change	’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