Koha-DB tables: biblio, biblioitems, items, bibliosubject, bibliosubtitle, additionalauthors and their coresponding MARC21 subfields “biblio”
| Koha-DB fields | MARC21 tag & subfield | Interface Label | |||
| biblionumber | 090 c | Koha biblionumber (NR) | |||
| author | 100 a | Personal name | |||
| title | 245 a | Title | |||
| unititle | 246 a | Title proper/short title | |||
| notes | 500 a | General note | |||
| serial | |||||
| seriestitle | 440 a | Title | |||
| copyrightdate | 260 c | Date of publication, distribution, etc | |||
| timestamp | ⇒ unmapped, filled automatically by mySQL | ||||
| abstract | 520 a | Summary, etc |
“biblioitems”
| Koha-DB fields | MARC21 tag & subfield | Interface Label | |||
| biblioitemnumber | 090 d | Koha biblioitemnumber (NR) | |||
| biblionumber | |||||
| volume | 440 v | Volume number/sequential designation | |||
| number | 440 n | Number of part/section of a work | |||
| classification | 852 h | Classification part (NR) | |||
| itemtype | 300 f | Type of unit | |||
| isbn | 020 a | International Standard Book Number | |||
| issn | 022 a | International Standard Serial Number | |||
| dewey | 852 k | Call number prefix (NR) | |||
| subclass | 852 m | Call number suffix (NR) | |||
| publicationyear | |||||
| publishercode | 260 b | Name of publisher, distributor, etc | |||
| volumedate | |||||
| volumeddesc | |||||
| timestamp | ⇒ unmapped, filled automatically by mySQL | ||||
| illus | 300 b | Other physical details | |||
| pages | 300 a | Extent | |||
| notes | |||||
| size | 300 c | Dimensions | |||
| place | 260 a | Place of publication, distribution, etc | |||
| lccn | 010 a | LC control number | |||
| marc | ⇒ unmapped, field will be dropped soon. Should Contain the iso2709 form of a biblio. | ||||
| url | 856 u | Uniform Resource Identifier (R) |
“items”
| Koha-DB fields | MARC21 tag & subfield | Interface Label | |||
| itemnumber | 952 u | itemnumber | |||
| biblionumber | |||||
| multivolumepart | |||||
| biblioitemnumber | |||||
| barcode | 952 p | barcode | |||
| dateaccessioned | 952 v | dateaccessioned | |||
| booksellerid | |||||
| homebranch | 952 b | homebranch | |||
| price | 952 r | price | |||
| replacementprice | |||||
| replacementpricedate | |||||
| datelastborrowed | |||||
| datelastseen | |||||
| multivolume | |||||
| stack | |||||
| notforloan | 952 y | notforloan | |||
| itemlost | |||||
| wthdrawn | |||||
| bulk | ⇒ used for Call Number. Renamed itemcallnumber in 2.2 | ||||
| issues | |||||
| renewals | |||||
| reserves | |||||
| restricted | |||||
| binding | |||||
| itemnotes | |||||
| holdingbranch | 952 d | holdingbranch | |||
| paidfor | |||||
| timestamp | ⇒ unmapped, filled automatically by mySQL |
“bibliosubject”
| Koha-DB fields | MARC21 tag & subfield | Interface Label | |||
| subject | 650 a | Topical term or geographic name as entry element | |||
| biblionumber |
“bibliosubtitle”
| Koha-DB fields | MARC21 tag & subfield | Interface Label | |||
| subtitle | 245 b | Remainder of title | |||
| biblionumber |
“additionalauthors”
| Koha-DB fields | MARC21 tag & subfield | Interface Label | |||
| author | 700 a | Personal name | |||
| biblionumber |