drugs


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of drugs.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Contains information about drugs that are dispensed/prescribed to patients. Also holds product inventory information if providers are internally managing their own drugs/medical supplies

Columns

Column Type Size Nulls Auto Default Children Parents Comments
drug_id INT 10 √ null
drug_sales.drug_id Defined in XML R
prescriptions.drug_id Defined in XML R
uuid BINARY 16 √ null
name VARCHAR 255
ndc_number VARCHAR 20
on_order INT 10 0
reorder_point FLOAT 12 0
max_level FLOAT 12 0
last_notify DATE 10 √ null
reactions TEXT 65535 √ null
form VARCHAR 31 0
size VARCHAR 25
unit VARCHAR 31 0
route VARCHAR 31 0
substitute INT 10 0
related_code VARCHAR 255

may reference a related codes.code
cyp_factor FLOAT 12 0

quantity representing a years supply
active BIT 1 √ 1

0 = inactive, 1 = active
allow_combining BIT 1 0

1 = allow filling an order from multiple lots
allow_multiple BIT 1 1

1 = allow multiple lots at one warehouse
drug_code VARCHAR 25 √ null
consumable BIT 1 0

1 = will not show on the fee sheet
dispensable BIT 1 1

0 = pharmacy elsewhere, 1 = dispensed here

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc drug_id
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation