Lines 177-184
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
177 |
`cn_class` varchar(30) default NULL, |
177 |
`cn_class` varchar(30) default NULL, |
178 |
`cn_item` varchar(10) default NULL, |
178 |
`cn_item` varchar(10) default NULL, |
179 |
`cn_suffix` varchar(10) default NULL, |
179 |
`cn_suffix` varchar(10) default NULL, |
180 |
`cn_sort` varchar(30) default NULL, |
180 |
`cn_sort` varchar(30) default NULL, -- normalized version of the call number used for sorting |
181 |
`agerestriction` varchar(255) default NULL, |
181 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
182 |
`totalissues` int(10), |
182 |
`totalissues` int(10), |
183 |
`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML |
183 |
`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML |
184 |
PRIMARY KEY (`biblioitemnumber`), |
184 |
PRIMARY KEY (`biblioitemnumber`), |
Lines 650-657
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
650 |
`cn_class` varchar(30) default NULL, |
650 |
`cn_class` varchar(30) default NULL, |
651 |
`cn_item` varchar(10) default NULL, |
651 |
`cn_item` varchar(10) default NULL, |
652 |
`cn_suffix` varchar(10) default NULL, |
652 |
`cn_suffix` varchar(10) default NULL, |
653 |
`cn_sort` varchar(30) default NULL, |
653 |
`cn_sort` varchar(30) default NULL, -- normalized version of the call number used for sorting |
654 |
`agerestriction` varchar(255) default NULL, |
654 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
655 |
`totalissues` int(10), |
655 |
`totalissues` int(10), |
656 |
`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML |
656 |
`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML |
657 |
PRIMARY KEY (`biblioitemnumber`), |
657 |
PRIMARY KEY (`biblioitemnumber`), |
658 |
- |
|
|