measure_groups
- Joseph Gulotta
- Alex Laird (Unlicensed)
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_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`)