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 DEFAULT NULL,
`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 Date of last upload 2010-05-18 created timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' creation 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 Date and time of modification 2010-05-18 09:15:36
`footnote_id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`source_text` text DEFAULT NULL,
`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 ;
| 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 Date of last upload | 2010-05-18 |
| created | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' | creation 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 Date and time of modification | 2010-05-18 09:15:36 |