Description

Concepts serve as the "codes" which drive the OpenMRS database. Whenever possible, data (both questions and answers) are codified using this concept table rather than stored as text.

Attributes

	Column Name	Type	Default	Description
	concept_id	int		Internal unique identifier for concept
	class_id concept_class.concept_class_id	int		Used to classify concepts into general categories (test, drug, anatomy, misc, etc.).
	datatype_id concept_datatype.concept_datatype_id	int		For question concepts, this defines the type of answer (coded, numeric, etc.) See list in concept_datatype for default values.
	is_set	bit		Bit that defines a set concept, or a concept which groups other similar concepts together. For example, Stauvdine is a potential member of the "Antiretroviral Medication" set concept.
	version	varchar(50)	NULL	Current version of the concept within the implementation.
	retired	bit		It's true if concept has been retired within a local implementation (for concepts that are not actively used any longer.
	creator users.user_id	int		Creator of the concept
	date_created	datetime	0000-00-00 00:00:00	Date the concept was created.
	changed_by users.user_id	int	NULL	Person who last changed the concept
	date_changed	datetime	NULL	Date the concept was last changed
	voided	bit		It's true if concept has been terminated for use in the system
	voided_by users.user_id	int	NULL	User who terminated the concept.
	date_voided	datetime	0000-00-00 00:00:000	Date the concept was voided.
	void_reason	varchar (255)	NULL	Reason why the concept was voided.
primary key, required