|
Lines 651-657
CREATE TABLE `deleteditems` (
Link Here
|
| 651 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) |
651 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) |
| 652 |
`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) |
652 |
`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) |
| 653 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
653 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
| 654 |
`paidfor` LONGTEXT, |
|
|
| 655 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
654 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
| 656 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
655 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
| 657 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
656 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
|
Lines 860-866
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
| 860 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) |
859 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) |
| 861 |
`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) |
860 |
`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) |
| 862 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
861 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
| 863 |
`paidfor` LONGTEXT, |
|
|
| 864 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
862 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
| 865 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
863 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) |
| 866 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
864 |
`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
| 867 |
- |
|
|