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 modifiedwas 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

measure_group_id` 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` `created` timestamp in 'YYYY-MM-DD HH:MM:SS' Format. Default is '0000-00-00 00:00:00' 
`modified` `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_groups.measure_group_id	int(11)	NOT NULL AUTO_INCREMENT	provided by Pellucid. FOREIGN KEY: links to measure_groups	00000000001
measure_groups.name	varchar(255)	NOT NULL DEFAULT	Name of

...

group	'Preventative Quality Indicators'
measure_groups.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
measure_groups.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