Summary
The footnotes table provides information on footnotes while assigning them an ID that can be linked to the footnotes_values table. The data stored relating to the footnote include its footnote_id, its source and the dates it was created or modified.
Table Creation
CREATE TABLE IF NOT EXISTS `footnotes` (
`footnote_id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`source_text` text,
`source` varchar(16) DEFAULT NULL,
`last_edit_date` date DEFAULT NULL,
`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 (`footnote_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=131 ;
Fields
| field | type | attributes | notes | example |
|---|---|---|---|---|
| footnote_id | int(11) | NOT NULL AUTO_INCREMENT | Provided by Pellucid | 101 |
| text | text | NOT NULL | Provides details on the footnote | 'Incomplete Reporting' |
| source_text | text | DEFAULT NULL | Name or Information on the source | 'IPRO' |
| source | varchar(16) | DEFAULT NULL | Identifying source information | 12345ABCDE |
| last_edit_date | date | DEFAULT NULL | date of last upload | 2010-05-18 |
| created | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' | creation date and time | 2010-05-18 09:15:36 |
| modified | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP | date and time of modification | 2010-05-18 09:15:36 |