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