measure_groups

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

PRIMARY KEY (`measure_group_id`)

Notes