Page Comparison

Summary

This table provides information on the group of measures. It includes data on the measure group's identifying number, its name, and the times at which it was created and modified.

This table only exists in the pellucid database and is linked to the measure_groups_measures table.

Table Creation

CREATE TABLE measure_groups ( 
`measure_group_id` int(11) NOT NULL AUTO_INCREMENT, 
`name` varchar(255) NOT NULL DEFAULT,
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, 
PRIMARY KEY(`measure_group_id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Field Information

`measure_group_id` Identifying number that is assigned for each group. It is primary and unique 
`name` text details regarding the name and details of the group 
`created` timestamp in 'YYYY-MM-DD HH:MM:SS' Format. Default is '0000-00-00 00:00:00' 
`modified` timestamp in 'YYYY-MM-DD HH:MM:SS' Format. Default is '0000-00-00 00:00:00'

 

Fields

field	type	attributes	notes	example
measure_group_id	int(11)	NOT NULL AUTO_INCREMENT	provided by Pellucid	00000000001
name	varchar(255)	NOT NULL DEFAULT	Name of set	'Preventative Quality Indicators'
created	timestamp	NOT NULL DEFAULT '0000-00-00 00:00:00'	The date and time the row was created	2010-09-16 09:15:36
modified	timestamp	NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP	the date and time the row was edited	2010-09-16 09:15:36

PRIMARY KEY (`measure_group_id`)

 

Notes