|
Lines 679-686
CREATE TABLE `deleteditems` (
Link Here
|
| 679 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
679 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
| 680 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
680 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
| 681 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
681 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
| 682 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x) |
682 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) |
| 683 |
`itemnotes_nonpublic` LONGTEXT default NULL, |
683 |
`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) |
| 684 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
684 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
| 685 |
`paidfor` LONGTEXT, |
685 |
`paidfor` LONGTEXT, |
| 686 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
686 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
|
Lines 942-949
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
| 942 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
942 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
| 943 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
943 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
| 944 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
944 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
| 945 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x) |
945 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) |
| 946 |
`itemnotes_nonpublic` LONGTEXT default NULL, |
946 |
`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) |
| 947 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
947 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
| 948 |
`paidfor` LONGTEXT, |
948 |
`paidfor` LONGTEXT, |
| 949 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
949 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
| 950 |
- |
|
|