Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
codeid	bigint	Unique EMIS internal identifier for this drug code. Used as the join key in prescribing tables.	1026041000033110	8	False
term	varchar	The display name of the drug as shown in EMIS Web.	Metformin 500mg tablets	255	False
dmdproductcodeid	bigint	The dm+d (Dictionary of Medicines and Devices) product code — the NHS standard drug identifier.	318507003	8	True
bnfchapterref		BNF chapter reference. Discontinued — always NULL.	NULL		True