| 
      
            Lines 1045-1050
          CREATE TABLE `items` ( -- holdings/item information
      
      
        Link Here
      
     | 
  
        
          | 1045 | 
            KEY `itembibnoidx` (`biblionumber`),  | 
          1045 | 
            KEY `itembibnoidx` (`biblionumber`),  | 
        
        
          | 1046 | 
            KEY `homebranch` (`homebranch`),  | 
          1046 | 
            KEY `homebranch` (`homebranch`),  | 
        
        
          | 1047 | 
            KEY `holdingbranch` (`holdingbranch`),  | 
          1047 | 
            KEY `holdingbranch` (`holdingbranch`),  | 
        
            
               | 
               | 
              1048 | 
                KEY (itemcallnumber),  | 
            
        
          | 1048 | 
            CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          1049 | 
            CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 1049 | 
            CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,  | 
          1050 | 
            CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,  | 
        
        
          | 1050 | 
            CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE  | 
          1051 | 
            CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE  |