| blob | 9d5955157fa7f3616ba71cf9825ef917fd22f186 |
1 CREATE TABLE IF NOT EXISTS procedure_order (
2 `procedure_order_id` bigint(20) NOT NULL AUTO_INCREMENT,
3 `procedure_type_id` bigint(20) NOT NULL COMMENT 'references procedure_type.procedure_type_id',
4 `provider_id` bigint(20) NOT NULL DEFAULT 0 COMMENT 'references users.id',
5 `patient_id` bigint(20) NOT NULL COMMENT 'references patient_data.pid',
6 `encounter_id` bigint(20) NOT NULL DEFAULT 0 COMMENT 'references form_encounter.encounter',
7 `date_collected` datetime DEFAULT NULL COMMENT 'time specimen collected',
8 `date_ordered` date DEFAULT NULL,
9 `order_priority` varchar(31) NOT NULL DEFAULT '',
10 `order_status` varchar(31) NOT NULL DEFAULT '' COMMENT 'pending,routed,complete,canceled',
11 `patient_instructions` text NOT NULL DEFAULT '',
12 `activity` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 if deleted',
13 PRIMARY KEY (`procedure_order_id`)
14 ) ENGINE=MyISAM;