Lines 1047-1052
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1047 |
`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1) |
1047 |
`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1) |
1048 |
`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) |
1048 |
`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) |
1049 |
`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o) |
1049 |
`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o) |
|
|
1050 |
`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f) |
1050 |
`issues` smallint(6) default NULL, -- number of times this item has been checked out/issued |
1051 |
`issues` smallint(6) default NULL, -- number of times this item has been checked out/issued |
1051 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
1052 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
1052 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
1053 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |