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