Lines 183-188
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in
Link Here
|
183 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
183 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
184 |
`totalissues` int(10), |
184 |
`totalissues` int(10), |
185 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
185 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
|
|
186 |
`datereceived` timestamp default NULL, --When the first Item for this Biblio is received. Updated only once when the first Item has been received. |
186 |
PRIMARY KEY (`biblioitemnumber`), |
187 |
PRIMARY KEY (`biblioitemnumber`), |
187 |
KEY `bibinoidx` (`biblioitemnumber`), |
188 |
KEY `bibinoidx` (`biblioitemnumber`), |
188 |
KEY `bibnoidx` (`biblionumber`), |
189 |
KEY `bibnoidx` (`biblionumber`), |
Lines 815-820
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t
Link Here
|
815 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
816 |
`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) |
816 |
`totalissues` int(10), |
817 |
`totalissues` int(10), |
817 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
818 |
`marcxml` longtext, -- full bibliographic MARC record in MARCXML |
|
|
819 |
`datereceived` timestamp default NULL, -- When the first Item for this Biblio is received. Updated only once when the first Item has been received. |
818 |
PRIMARY KEY (`biblioitemnumber`), |
820 |
PRIMARY KEY (`biblioitemnumber`), |
819 |
KEY `bibinoidx` (`biblioitemnumber`), |
821 |
KEY `bibinoidx` (`biblioitemnumber`), |
820 |
KEY `bibnoidx` (`biblionumber`), |
822 |
KEY `bibnoidx` (`biblionumber`), |
Lines 911-916
CREATE TABLE `deleteditems` (
Link Here
|
911 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
913 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
912 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
914 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
913 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
915 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
|
|
916 |
`datereceived` timestamp default NULL, -- When this Item was received. |
914 |
`booksellerid` mediumtext default NULL, -- where the item was purchased (MARC21 952$e) |
917 |
`booksellerid` mediumtext default NULL, -- where the item was purchased (MARC21 952$e) |
915 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
918 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
916 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |
919 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |
Lines 1213-1218
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1213 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
1216 |
`biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the biblioitems table to link to item to additional information |
1214 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
1217 |
`barcode` varchar(20) default NULL, -- item barcode (MARC21 952$p) |
1215 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
1218 |
`dateaccessioned` date default NULL, -- date the item was acquired or added to Koha (MARC21 952$d) |
|
|
1219 |
`datereceived` timestamp default NULL, -- When this Item was received. |
1216 |
`booksellerid` mediumtext default NULL, -- where the item was purchased (MARC21 952$e) |
1220 |
`booksellerid` mediumtext default NULL, -- where the item was purchased (MARC21 952$e) |
1217 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
1221 |
`homebranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this item (MARC21 952$a) |
1218 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |
1222 |
`price` decimal(8,2) default NULL, -- purchase price (MARC21 952$g) |