Lines 2602-2608
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
2602 |
`gstrate` decimal(6,4) default NULL, -- the tax rate the library is charged |
2602 |
`gstrate` decimal(6,4) default NULL, -- the tax rate the library is charged |
2603 |
`discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor |
2603 |
`discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor |
2604 |
`fax` varchar(50) default NULL, -- vendor fax number |
2604 |
`fax` varchar(50) default NULL, -- vendor fax number |
2605 |
`deliverytime` int(11) default NULL, -- vendor delivery time |
2605 |
deliverytime int(11) default NULL, -- vendor delivery time |
2606 |
PRIMARY KEY (`id`), |
2606 |
PRIMARY KEY (`id`), |
2607 |
KEY `listprice` (`listprice`), |
2607 |
KEY `listprice` (`listprice`), |
2608 |
KEY `invoiceprice` (`invoiceprice`), |
2608 |
KEY `invoiceprice` (`invoiceprice`), |
2609 |
- |
|
|