| 
      
            Lines 638-644
          CREATE TABLE `deleteditems` (
      
      
        Link Here
      
     | 
  
        
          | 638 | 
            `withdrawn_on` datetime DEFAULT NULL, -- the date and time an item was last marked as withdrawn, NULL if not withdrawn  | 
          638 | 
            `withdrawn_on` datetime DEFAULT NULL, -- the date and time an item was last marked as withdrawn, NULL if not withdrawn  | 
        
        
          | 639 | 
            `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)  | 
          639 | 
            `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)  | 
        
        
          | 640 | 
            `coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)  | 
          640 | 
            `coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)  | 
        
          
            
              | 641 | 
                `issues` smallint(6) default NULL, -- number of times this item has been checked out  | 
              641 | 
                `issues` smallint(6) default 0, -- number of times this item has been checked out  | 
            
        
          | 642 | 
            `renewals` smallint(6) default NULL, -- number of times this item has been renewed  | 
          642 | 
            `renewals` smallint(6) default NULL, -- number of times this item has been renewed  | 
        
        
          | 643 | 
            `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved  | 
          643 | 
            `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved  | 
        
        
          | 644 | 
            `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)  | 
          644 | 
            `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)  | 
        
  
    | 
      
            Lines 843-849
          CREATE TABLE `items` ( -- holdings/item information
      
      
        Link Here
      
     | 
  
        
          | 843 | 
            `withdrawn_on` datetime DEFAULT NULL, -- the date and time an item was last marked as withdrawn, NULL if not withdrawn  | 
          843 | 
            `withdrawn_on` datetime DEFAULT NULL, -- the date and time an item was last marked as withdrawn, NULL if not withdrawn  | 
        
        
          | 844 | 
            `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)  | 
          844 | 
            `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)  | 
        
        
          | 845 | 
            `coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)  | 
          845 | 
            `coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)  | 
        
          
            
              | 846 | 
                `issues` smallint(6) default NULL, -- number of times this item has been checked out/issued  | 
              846 | 
                `issues` smallint(6) default 0, -- number of times this item has been checked out/issued  | 
            
        
          | 847 | 
            `renewals` smallint(6) default NULL, -- number of times this item has been renewed  | 
          847 | 
            `renewals` smallint(6) default NULL, -- number of times this item has been renewed  | 
        
        
          | 848 | 
            `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved  | 
          848 | 
            `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved  | 
        
        
          | 849 | 
            `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)  | 
          849 | 
            `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5)  | 
        
            
              | 850 | 
              -   | 
               | 
               |