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