Lines 2232-2238
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
2232 |
collectiontitle text default NULL, -- collection name for the suggested item |
2232 |
collectiontitle text default NULL, -- collection name for the suggested item |
2233 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
2233 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
2234 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
2234 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
2235 |
currency VARCHAR(3) default NULL, -- suggested currency for the suggested price |
2235 |
currency VARCHAR(10) default NULL, -- suggested currency for the suggested price |
2236 |
price DECIMAL(28,6) default NULL, -- suggested price |
2236 |
price DECIMAL(28,6) default NULL, -- suggested price |
2237 |
total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency) |
2237 |
total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency) |
2238 |
PRIMARY KEY (`suggestionid`), |
2238 |
PRIMARY KEY (`suggestionid`), |
Lines 2921-2927
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
2921 |
`phone` varchar(30) default NULL, -- vendor phone number |
2921 |
`phone` varchar(30) default NULL, -- vendor phone number |
2922 |
`accountnumber` mediumtext, -- unused in Koha |
2922 |
`accountnumber` mediumtext, -- unused in Koha |
2923 |
`othersupplier` mediumtext, -- unused in Koha |
2923 |
`othersupplier` mediumtext, -- unused in Koha |
2924 |
`currency` varchar(3) NOT NULL default '', -- unused in Koha |
2924 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
2925 |
`booksellerfax` mediumtext, -- vendor fax number |
2925 |
`booksellerfax` mediumtext, -- vendor fax number |
2926 |
`notes` mediumtext, -- order notes |
2926 |
`notes` mediumtext, -- order notes |
2927 |
`bookselleremail` mediumtext, -- vendor email |
2927 |
`bookselleremail` mediumtext, -- vendor email |
Lines 3080-3086
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3080 |
`biblionumber` int(11) default NULL, -- links the order to the biblio being ordered (biblio.biblionumber) |
3080 |
`biblionumber` int(11) default NULL, -- links the order to the biblio being ordered (biblio.biblionumber) |
3081 |
`entrydate` date default NULL, -- the date the bib was added to the basket |
3081 |
`entrydate` date default NULL, -- the date the bib was added to the basket |
3082 |
`quantity` smallint(6) default NULL, -- the quantity ordered |
3082 |
`quantity` smallint(6) default NULL, -- the quantity ordered |
3083 |
`currency` varchar(3) default NULL, -- the currency used for the purchase |
3083 |
`currency` varchar(10) default NULL, -- the currency used for the purchase |
3084 |
`listprice` decimal(28,6) default NULL, -- the vendor price for this line item |
3084 |
`listprice` decimal(28,6) default NULL, -- the vendor price for this line item |
3085 |
`datereceived` date default NULL, -- the date this order was received |
3085 |
`datereceived` date default NULL, -- the date this order was received |
3086 |
invoiceid int(11) default NULL, -- id of invoice |
3086 |
invoiceid int(11) default NULL, -- id of invoice |