|
Lines 146-184
CREATE TABLE `biblio_framework` (
Link Here
|
| 146 |
-- |
146 |
-- |
| 147 |
|
147 |
|
| 148 |
DROP TABLE IF EXISTS `biblioitems`; |
148 |
DROP TABLE IF EXISTS `biblioitems`; |
| 149 |
CREATE TABLE `biblioitems` ( |
149 |
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Koha |
| 150 |
`biblioitemnumber` int(11) NOT NULL auto_increment, |
150 |
`biblioitemnumber` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha |
| 151 |
`biblionumber` int(11) NOT NULL default 0, |
151 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table |
| 152 |
`volume` mediumtext, |
152 |
`volume` mediumtext, |
| 153 |
`number` mediumtext, |
153 |
`number` mediumtext, |
| 154 |
`itemtype` varchar(10) default NULL, |
154 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
| 155 |
`isbn` varchar(30) default NULL, |
155 |
`isbn` varchar(30) default NULL, -- ISBN (MARC21 020$a) |
| 156 |
`issn` varchar(9) default NULL, |
156 |
`issn` varchar(9) default NULL, -- ISSN (MARC21 022$a) |
| 157 |
`publicationyear` text, |
157 |
`publicationyear` text, |
| 158 |
`publishercode` varchar(255) default NULL, |
158 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
| 159 |
`volumedate` date default NULL, |
159 |
`volumedate` date default NULL, |
| 160 |
`volumedesc` text, |
160 |
`volumedesc` text, -- volume information (MARC21 362$a) |
| 161 |
`collectiontitle` mediumtext default NULL, |
161 |
`collectiontitle` mediumtext default NULL, |
| 162 |
`collectionissn` text default NULL, |
162 |
`collectionissn` text default NULL, |
| 163 |
`collectionvolume` mediumtext default NULL, |
163 |
`collectionvolume` mediumtext default NULL, |
| 164 |
`editionstatement` text default NULL, |
164 |
`editionstatement` text default NULL, |
| 165 |
`editionresponsibility` text default NULL, |
165 |
`editionresponsibility` text default NULL, |
| 166 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
166 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 167 |
`illus` varchar(255) default NULL, |
167 |
`illus` varchar(255) default NULL, -- illustrations (MARC21 300$b) |
| 168 |
`pages` varchar(255) default NULL, |
168 |
`pages` varchar(255) default NULL, -- number of pages (MARC21 300$c) |
| 169 |
`notes` mediumtext, |
169 |
`notes` mediumtext, |
| 170 |
`size` varchar(255) default NULL, |
170 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
| 171 |
`place` varchar(255) default NULL, |
171 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
| 172 |
`lccn` varchar(25) default NULL, |
172 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
| 173 |
`marc` longblob, |
173 |
`marc` longblob, -- full bibliographic MARC record |
| 174 |
`url` varchar(255) default NULL, |
174 |
`url` varchar(255) default NULL, -- url (MARC21 856$u) |
| 175 |
`cn_source` varchar(10) default NULL, |
175 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
| 176 |
`cn_class` varchar(30) default NULL, |
176 |
`cn_class` varchar(30) default NULL, |
| 177 |
`cn_item` varchar(10) default NULL, |
177 |
`cn_item` varchar(10) default NULL, |
| 178 |
`cn_suffix` varchar(10) default NULL, |
178 |
`cn_suffix` varchar(10) default NULL, |
| 179 |
`cn_sort` varchar(30) default NULL, |
179 |
`cn_sort` varchar(30) default NULL, |
| 180 |
`totalissues` int(10), |
180 |
`totalissues` int(10), |
| 181 |
`marcxml` longtext NOT NULL, |
181 |
`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML |
| 182 |
PRIMARY KEY (`biblioitemnumber`), |
182 |
PRIMARY KEY (`biblioitemnumber`), |
| 183 |
KEY `bibinoidx` (`biblioitemnumber`), |
183 |
KEY `bibinoidx` (`biblioitemnumber`), |
| 184 |
KEY `bibnoidx` (`biblionumber`), |
184 |
KEY `bibnoidx` (`biblionumber`), |
|
Lines 609-647
CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records
Link Here
|
| 609 |
-- |
609 |
-- |
| 610 |
|
610 |
|
| 611 |
DROP TABLE IF EXISTS `deletedbiblioitems`; |
611 |
DROP TABLE IF EXISTS `deletedbiblioitems`; |
| 612 |
CREATE TABLE `deletedbiblioitems` ( |
612 |
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records that have been deleted |
| 613 |
`biblioitemnumber` int(11) NOT NULL default 0, |
613 |
`biblioitemnumber` int(11) NOT NULL default 0, -- primary key, unique identifier assigned by Koha |
| 614 |
`biblionumber` int(11) NOT NULL default 0, |
614 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table |
| 615 |
`volume` mediumtext, |
615 |
`volume` mediumtext, |
| 616 |
`number` mediumtext, |
616 |
`number` mediumtext, |
| 617 |
`itemtype` varchar(10) default NULL, |
617 |
`itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) |
| 618 |
`isbn` varchar(30) default NULL, |
618 |
`isbn` varchar(30) default NULL, -- ISBN (MARC21 020$a) |
| 619 |
`issn` varchar(9) default NULL, |
619 |
`issn` varchar(9) default NULL, -- ISSN (MARC21 022$a) |
| 620 |
`publicationyear` text, |
620 |
`publicationyear` text, |
| 621 |
`publishercode` varchar(255) default NULL, |
621 |
`publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) |
| 622 |
`volumedate` date default NULL, |
622 |
`volumedate` date default NULL, |
| 623 |
`volumedesc` text, |
623 |
`volumedesc` text, -- volume information (MARC21 362$a) |
| 624 |
`collectiontitle` mediumtext default NULL, |
624 |
`collectiontitle` mediumtext default NULL, |
| 625 |
`collectionissn` text default NULL, |
625 |
`collectionissn` text default NULL, |
| 626 |
`collectionvolume` mediumtext default NULL, |
626 |
`collectionvolume` mediumtext default NULL, |
| 627 |
`editionstatement` text default NULL, |
627 |
`editionstatement` text default NULL, |
| 628 |
`editionresponsibility` text default NULL, |
628 |
`editionresponsibility` text default NULL, |
| 629 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
629 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 630 |
`illus` varchar(255) default NULL, |
630 |
`illus` varchar(255) default NULL, -- illustrations (MARC21 300$b) |
| 631 |
`pages` varchar(255) default NULL, |
631 |
`pages` varchar(255) default NULL, -- number of pages (MARC21 300$c) |
| 632 |
`notes` mediumtext, |
632 |
`notes` mediumtext, |
| 633 |
`size` varchar(255) default NULL, |
633 |
`size` varchar(255) default NULL, -- material size (MARC21 300$c) |
| 634 |
`place` varchar(255) default NULL, |
634 |
`place` varchar(255) default NULL, -- publication place (MARC21 260$a) |
| 635 |
`lccn` varchar(25) default NULL, |
635 |
`lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a) |
| 636 |
`marc` longblob, |
636 |
`marc` longblob, -- full bibliographic MARC record |
| 637 |
`url` varchar(255) default NULL, |
637 |
`url` varchar(255) default NULL, -- url (MARC21 856$u) |
| 638 |
`cn_source` varchar(10) default NULL, |
638 |
`cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2) |
| 639 |
`cn_class` varchar(30) default NULL, |
639 |
`cn_class` varchar(30) default NULL, |
| 640 |
`cn_item` varchar(10) default NULL, |
640 |
`cn_item` varchar(10) default NULL, |
| 641 |
`cn_suffix` varchar(10) default NULL, |
641 |
`cn_suffix` varchar(10) default NULL, |
| 642 |
`cn_sort` varchar(30) default NULL, |
642 |
`cn_sort` varchar(30) default NULL, |
| 643 |
`totalissues` int(10), |
643 |
`totalissues` int(10), |
| 644 |
`marcxml` longtext NOT NULL, |
644 |
`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML |
| 645 |
PRIMARY KEY (`biblioitemnumber`), |
645 |
PRIMARY KEY (`biblioitemnumber`), |
| 646 |
KEY `bibinoidx` (`biblioitemnumber`), |
646 |
KEY `bibinoidx` (`biblioitemnumber`), |
| 647 |
KEY `bibnoidx` (`biblionumber`), |
647 |
KEY `bibnoidx` (`biblionumber`), |
| 648 |
- |
|
|