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 |
- |
|
|