measure_group_measures

Owned by Joseph Gulotta
Last updated: Jun 09, 2015
1 min read

Summary

measure_groups_measures stores information on groups of measures, referencing the 'measures' table. This table also stores information regarding which measures comprise a measure set. Information on the measure groups can be found in the 'measure_groups' table.
'measure_group_id' is unique to each measure set, but 'measure_id' can be used across multiple measure_sets. By definition, a measure group will generally contain multiple measure_ids. 


Table Creation:


CREATE TABLE IF NOT EXISTS `measure_groups_measures` (
`measure_group_id` int(11) NOT NULL,
`measure_id` int(11) NOT NULL,
PRIMARY KEY (`measure_group_id`,`measure_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Field Information:


'measure_group_id' the ID associated with the measure_group. Links to measures_groups table. Combines with the measure_id to form a concatenated key 'measure_id' the ID associated with the individual measures. Links to the measures table. Combines with the measure_group_id to form a unique combination

Fields

fieldtypeattributesnotesexample
 measure_group_measures.measure_group_id int(11)    NOT NULL Provided by Pellucid. FOREIGN KEY: links to measure_groups    1
measure_group_measures.measure_id     int(11)     NOT NULL Provided by Pellucid. FOREIGN KEY: links to measures 10001