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`measure_id` 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`measure_group_id` the 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 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
Fieldsfield type attributes notes example
measure
id id int(11) NOT NULL Provided by Pellucid 1
measure
id id int(11) NOT NULL Found in measures table 10001
`measure`measure_group_id` the 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 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
| field | type | attributes | notes | example |
|---|
| id | int(11) | NOT NULL | Provided by Pellucid | 1 |
| id | int(11) | NOT NULL | Found in measures table | 10001 |