Lines 2933-2938
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
2933 |
`claimed_date` date default NULL, -- last date a claim was generated |
2933 |
`claimed_date` date default NULL, -- last date a claim was generated |
2934 |
`subscriptionid` int(11) default NULL, -- links this order line to a subscription (subscription.subscriptionid) |
2934 |
`subscriptionid` int(11) default NULL, -- links this order line to a subscription (subscription.subscriptionid) |
2935 |
parent_ordernumber int(11) default NULL, -- ordernumber of parent order line, or same as ordernumber if no parent |
2935 |
parent_ordernumber int(11) default NULL, -- ordernumber of parent order line, or same as ordernumber if no parent |
|
|
2936 |
branchcode varchar(10) default NULL, -- library where the order will be sent |
2936 |
PRIMARY KEY (`ordernumber`), |
2937 |
PRIMARY KEY (`ordernumber`), |
2937 |
KEY `basketno` (`basketno`), |
2938 |
KEY `basketno` (`basketno`), |
2938 |
KEY `biblionumber` (`biblionumber`), |
2939 |
KEY `biblionumber` (`biblionumber`), |
Lines 2940-2946
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
2940 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
2941 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
2941 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2942 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2942 |
CONSTRAINT aqorders_ibfk_3 FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE SET NULL ON UPDATE CASCADE, |
2943 |
CONSTRAINT aqorders_ibfk_3 FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE SET NULL ON UPDATE CASCADE, |
2943 |
CONSTRAINT `aqorders_subscriptionid` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE |
2944 |
CONSTRAINT `aqorders_subscriptionid` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
2945 |
CONSTRAINT `aqorders_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
2944 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2946 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2945 |
|
2947 |
|
2946 |
|
2948 |
|