Summary
This table provides information regarding the relationships of the values of their measures and the footnotes that need to be associated with them. This table links both the 'measures' table and the 'entity_values' table to the 'footnotes' table.
...
Duplications can exist in this table for any of these fields, but all five can never be exact matches.
Table CreationCREATE TABLE IF NOT EXISTS `footnotes_values` (
`measure_id` int(11) NOT NULL,
`entity_id` bigint(20) unsigned NOT NULL,
`date_start` date NOT NULL,
`date_end` date NOT NULL,
`footnote_id` int(11) NOT NULL,
`batch_id` varchar(64) DEFAULT NULL,
UNIQUE KEY `footnote_id` (`measure_id`,`entity_id`,`date_start`,`date_end`,`footnote_id`),
KEY `footnotes_ibfk2` (`footnote_id`),
KEY `footnotes_batch` (`batch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `footnotes_values`
ADD CONSTRAINT `footnotes_ibfk2` FOREIGN KEY (`footnote_id`) REFERENCES `footnotes` (`footnote_id`) ON DELETE CASCADE,
ADD CONSTRAINT `footnotes_values_ibfk1` FOREIGN KEY (`measure_id`, `entity_id`, `date_start`, `date_end`) REFERENCES `entity_values` (`measure_id`, `entity_id`, `date_start`, `date_end`) ON DELETE CASCADE;
Fields
field type attributes notes example footnotes_values.measure_id int(11) NOT NULL Provided by Pellucid, FOREIGN KEY: links to measures 01234560 footnotes_values.entity_id bigint(20) UNSIGNED NOT NULL Provided by Pellucid, FOREIGN KEY: links to entity_hospitals or entity_ascsentities 01234567890 footnotes_values.date_start date NOT NULL Same as field in entity_values, YYYY-MM-DD 2009-01-01 footnotes_values.date_end date NOT NULL Same as field in entity_values, YYYY-MM-DD 2009-12-31 footnotes_values.footnote_id int(11) NOT NULL Provided by Pellucid, FOREIGN KEY: links to footnotes 2456 footnotes_values.batch_id varchar(64)
DEFAULT NULL Batch ID WNTB20120923
`measure_id` int(11) NOT NULL,
`entity_id` bigint(20) unsigned NOT NULL,
`date_start` date NOT NULL,
`date_end` date NOT NULL,
`footnote_id` int(11) NOT NULL,
`batch_id` varchar(64) DEFAULT NULL,
UNIQUE KEY `footnote_id` (`measure_id`,`entity_id`,`date_start`,`date_end`,`footnote_id`),
KEY `footnotes_ibfk2` (`footnote_id`),
KEY `footnotes_batch` (`batch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `footnotes_values`
ADD CONSTRAINT `footnotes_ibfk2` FOREIGN KEY (`footnote_id`) REFERENCES `footnotes` (`footnote_id`) ON DELETE CASCADE,
ADD CONSTRAINT `footnotes_values_ibfk1` FOREIGN KEY (`measure_id`, `entity_id`, `date_start`, `date_end`) REFERENCES `entity_values` (`measure_id`, `entity_id`, `date_start`, `date_end`) ON DELETE CASCADE;
| field | type | attributes | notes | example |
|---|---|---|---|---|
| footnotes_values.measure_id | int(11) | NOT NULL | Provided by Pellucid, FOREIGN KEY: links to measures | 01234560 |
| footnotes_values.entity_id | bigint(20) | UNSIGNED NOT NULL | Provided by Pellucid, FOREIGN KEY: links to entity_hospitals or entity_ascsentities | 01234567890 |
| footnotes_values.date_start | date | NOT NULL | Same as field in entity_values, YYYY-MM-DD | 2009-01-01 |
| footnotes_values.date_end | date | NOT NULL | Same as field in entity_values, YYYY-MM-DD | 2009-12-31 |
| footnotes_values.footnote_id | int(11) | NOT NULL | Provided by Pellucid, FOREIGN KEY: links to footnotes | 2456 |
| footnotes_values.batch_id | varchar(64) | DEFAULT NULL | Batch ID | WNTB20120923 |