From e2bcaa7ba865c6e604bd7273d280527a8b287ec5 Mon Sep 17 00:00:00 2001 From: Nicole C. Engard Date: Wed, 11 Jul 2012 23:32:47 -0400 Subject: [PATCH] Bug 6716: Document aqbasket table --- installer/data/mysql/kohastructure.sql | 24 ++++++++++++------------ 1 files changed, 12 insertions(+), 12 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3b9827a..7dc85fe 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2555,18 +2555,18 @@ CREATE TABLE `aqbasketgroups` ( -- DROP TABLE IF EXISTS `aqbasket`; -CREATE TABLE `aqbasket` ( - `basketno` int(11) NOT NULL auto_increment, - `basketname` varchar(50) default NULL, - `note` mediumtext, - `booksellernote` mediumtext, - `contractnumber` int(11), - `creationdate` date default NULL, - `closedate` date default NULL, - `booksellerid` int(11) NOT NULL default 1, - `authorisedby` varchar(10) default NULL, - `booksellerinvoicenumber` mediumtext, - `basketgroupid` int(11), +CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions + `basketno` int(11) NOT NULL auto_increment, -- primary key, Koha defined number + `basketname` varchar(50) default NULL, -- name given to the basket at creation + `note` mediumtext, -- the internal note added at basket creation + `booksellernote` mediumtext, -- the vendor note added at basket creation + `contractnumber` int(11), -- links this basket to the aqcontract table (aqcontract.contractnumber) + `creationdate` date default NULL, -- the date the basket was created + `closedate` date default NULL, -- the date the basket was closed + `booksellerid` int(11) NOT NULL default 1, -- the Koha assigned ID for the vendor (aqbooksellers.id) + `authorisedby` varchar(10) default NULL, -- the borrowernumber of the person who created the basket + `booksellerinvoicenumber` mediumtext, -- appears to always be NULL + `basketgroupid` int(11), -- links this basket to its group (aqbasketgroups.id) PRIMARY KEY (`basketno`), KEY `booksellerid` (`booksellerid`), KEY `basketgroupid` (`basketgroupid`), -- 1.7.2.3