Lines 693-699
CREATE TABLE `aqorders` (
Link Here
|
693 |
`suppliers_reference_number` varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Suppliers unique edifact quote ref', |
693 |
`suppliers_reference_number` varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Suppliers unique edifact quote ref', |
694 |
`suppliers_reference_qualifier` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Type of number above usually ''QLI''', |
694 |
`suppliers_reference_qualifier` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Type of number above usually ''QLI''', |
695 |
`suppliers_report` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'reports received from suppliers', |
695 |
`suppliers_report` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'reports received from suppliers', |
696 |
`estimated_delivery_date` date default null, |
696 |
`estimated_delivery_date` date DEFAULT NULL COMMENT 'Estimated delivery date', |
697 |
PRIMARY KEY (`ordernumber`), |
697 |
PRIMARY KEY (`ordernumber`), |
698 |
KEY `basketno` (`basketno`), |
698 |
KEY `basketno` (`basketno`), |
699 |
KEY `biblionumber` (`biblionumber`), |
699 |
KEY `biblionumber` (`biblionumber`), |
700 |
- |
|
|