Drug


Contents

Description

Attributes

Column Name Type Default Description
Primary Key drug_id int
Required concept_id concept.concept_id int
name varchar(50) NULL
Required combination bit
dosage_form concept.concept_id int NULL
dose_strength double NULL
maximum_daily_dose double NULL
minimum_daily_dose double NULL
route concept.concept_id int NULL
units varchar(50) NULL
Required creator users.user_id int
Required date_created datetime 0000-00-00 00:00:00
Required voided bit
voided_by users.user_id int NULL
date_voided datetime NULL
void_reason varchar(255) NULL
Primary Key primary key, Required required