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 |
- |
|
|