Lines 2716-2721
CREATE TABLE `deleteditems` (
Link Here
|
2716 |
`deleted_on` datetime DEFAULT NULL COMMENT 'date/time of deletion', |
2716 |
`deleted_on` datetime DEFAULT NULL COMMENT 'date/time of deletion', |
2717 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
2717 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
2718 |
`permanent_location` varchar(80) DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', |
2718 |
`permanent_location` varchar(80) DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', |
|
|
2719 |
`sub_location` varchar(10) DEFAULT NULL COMMENT 'authorized value for the sublocation for this item', |
2719 |
`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', |
2720 |
`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', |
2720 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source used on this item (MARC21 952$2)', |
2721 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source used on this item (MARC21 952$2)', |
2721 |
`cn_sort` varchar(255) DEFAULT NULL COMMENT 'normalized form of the call number (MARC21 952$o) used for sorting', |
2722 |
`cn_sort` varchar(255) DEFAULT NULL COMMENT 'normalized form of the call number (MARC21 952$o) used for sorting', |
Lines 3688-3693
CREATE TABLE `items` (
Link Here
|
3688 |
`deleted_on` datetime DEFAULT NULL COMMENT 'date/time of deletion', |
3689 |
`deleted_on` datetime DEFAULT NULL COMMENT 'date/time of deletion', |
3689 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
3690 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
3690 |
`permanent_location` varchar(80) DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', |
3691 |
`permanent_location` varchar(80) DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', |
|
|
3692 |
`sub_location` varchar(10) DEFAULT NULL COMMENT 'authorized value for the sublocation for this item', |
3691 |
`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', |
3693 |
`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', |
3692 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source used on this item (MARC21 952$2)', |
3694 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source used on this item (MARC21 952$2)', |
3693 |
`cn_sort` varchar(255) DEFAULT NULL COMMENT 'normalized form of the call number (MARC21 952$o) used for sorting', |
3695 |
`cn_sort` varchar(255) DEFAULT NULL COMMENT 'normalized form of the call number (MARC21 952$o) used for sorting', |