footnotes

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