Schema

Schema Overview

Column Name	Data Type	Description	Example
is_deleted	boolean	If this record should be considered soft deleted	FALSE
preparation_code_id	bigint	EMIS code_id - internal identifier for the drug preparation	123456
preparation_pack_id	bigint	PK The identifier for the preparation in a given pack	78901
supplier_name	varchar	The name of the supplier/manufacturer	’Examplus Healthcare Ltd’
term	varchar	Description of the drug or medication	’Metformin 500mg tablets’
dmd_product_code_id	bigint	Dictionary of Medicines and Devices (dm+d) product identifier	123456789
pack_description	varchar	A description of the pack	’28 tablet’
units_per_pack	double	How many of the unit of measure is contained in the pack	28.0
unit_of_measure	varchar	The unit type for the medication (e.g., tablets, ml)	‘tablet’
pack_price	real	How much the pack costs	1.42
price_per_unit	real	Cost of an individual unit of measure (pack price / units per pack)	0.0507
is_guide_price_pack	boolean	Indicates if pack price is the amount NHS will reimburse prescriber	TRUE
is_breakable	boolean	If you can break a pack i.e. it comes in 12, you only need 10, can you do this?	FALSE
is_divisible	boolean	If this preparation is divisible	FALSE
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.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