Orders

Contents

[edit]

Description

[edit]

Attributes

Column Name Type Default Description
Primary Key order_id int
Required order_type_id order_type.order_type_id int
Required concept_id int
orderer users.user_id int
encounter_id encounter.encounter_id int NULL
instructions text NULL
start_date datetime NULL
auto_expire_date datetime NULL
Required discontinued bit
discontinued_date datetime NULL
discontinued_by users.user_id int NULL
discontinued_reason concept.concept_id int 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
Retrieved from "http://openmrs.org/wiki/Orders"