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 *