Lines 1054-1059
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1054 |
KEY `homebranch` (`homebranch`), |
1054 |
KEY `homebranch` (`homebranch`), |
1055 |
KEY `holdingbranch` (`holdingbranch`), |
1055 |
KEY `holdingbranch` (`holdingbranch`), |
1056 |
KEY `itemcallnumber` (`itemcallnumber`), |
1056 |
KEY `itemcallnumber` (`itemcallnumber`), |
|
|
1057 |
KEY `items_location` (`location`), |
1058 |
KEY `items_ccode` (`ccode`), |
1057 |
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1059 |
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1058 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
1060 |
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE, |
1059 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE |
1061 |
CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE |