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
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 MEDIUMTEXT 16777215 √ 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 BOOLEAN 3 √ 1

0 = inactive, 1 = active
allow_combining BOOLEAN 3 0

1 = allow filling an order from multiple lots
allow_multiple BOOLEAN 3 1

1 = allow multiple lots at one warehouse
drug_code VARCHAR 25 √ NULL
consumable BOOLEAN 3 0

1 = will not show on the fee sheet
dispensable BOOLEAN 3 1

0 = pharmacy elsewhere, 1 = dispensed here
uuid BINARY 16 √ NULL
date_created DATETIME 19 current_timestamp()
last_updated DATETIME 19 current_timestamp()

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