Lines 2818-2823
CREATE TABLE `deleteditems` (
Link Here
|
2818 |
`deleted_on` datetime DEFAULT NULL COMMENT 'date/time of deletion', |
2818 |
`deleted_on` datetime DEFAULT NULL COMMENT 'date/time of deletion', |
2819 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
2819 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
2820 |
`permanent_location` varchar(80) DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', |
2820 |
`permanent_location` varchar(80) DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', |
|
|
2821 |
`sub_location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the sublocation for this item', |
2821 |
`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', |
2822 |
`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', |
2822 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source used on this item (MARC21 952$2)', |
2823 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source used on this item (MARC21 952$2)', |
2823 |
`cn_sort` varchar(255) DEFAULT NULL COMMENT 'normalized form of the call number (MARC21 952$o) used for sorting', |
2824 |
`cn_sort` varchar(255) DEFAULT NULL COMMENT 'normalized form of the call number (MARC21 952$o) used for sorting', |
Lines 4139-4144
CREATE TABLE `items` (
Link Here
|
4139 |
`deleted_on` datetime DEFAULT NULL COMMENT 'date/time of deletion', |
4140 |
`deleted_on` datetime DEFAULT NULL COMMENT 'date/time of deletion', |
4140 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
4141 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
4141 |
`permanent_location` varchar(80) DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', |
4142 |
`permanent_location` varchar(80) DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', |
|
|
4143 |
`sub_location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the sublocation for this item', |
4142 |
`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', |
4144 |
`onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', |
4143 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source used on this item (MARC21 952$2)', |
4145 |
`cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source used on this item (MARC21 952$2)', |
4144 |
`cn_sort` varchar(255) DEFAULT NULL COMMENT 'normalized form of the call number (MARC21 952$o) used for sorting', |
4146 |
`cn_sort` varchar(255) DEFAULT NULL COMMENT 'normalized form of the call number (MARC21 952$o) used for sorting', |