list_items

Details of the items on a specific reading list.

Structure

CREATE TABLE `list_items` (
`listItemID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`itemID` mediumint(9) unsigned NOT NULL,
`listID` mediumint(9) unsigned NOT NULL,
`sectionID` mediumint(4) unsigned NOT NULL,
`itemOrder` smallint(6) unsigned NOT NULL,
`itemNotes` text,
`itemRelevance` varchar(5) DEFAULT NULL,
`itemSuitability` varchar(5) DEFAULT NULL,
PRIMARY KEY (`listitemID`,`itemID`,`listID`,`sectionID`)
) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=utf8

Foreign Keys

items.itemID
lists.listID
sections.sectionID

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>