| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| itemnumber | INT | 10 | 0 |
|
|
primary key and unique identifier added by Koha |
||
| biblionumber | INT | 10 | 0 |
|
|
foreign key from biblio table used to link this item to the right bib record |
||
| biblioitemnumber | INT | 10 | 0 |
|
|
foreign key from the biblioitems table to link to item to additional information |
||
| barcode | VARCHAR | 20 | √ | null |
|
|
item barcode (MARC21 952$p) |
|
| dateaccessioned | DATE | 10 | √ | null |
|
|
date the item was acquired or added to Koha (MARC21 952$d) |
|
| booksellerid | LONGTEXT | 2147483647 | √ | null |
|
|
where the item was purchased (MARC21 952$e) |
|
| homebranch | VARCHAR | 10 | √ | null |
|
|
foreign key from the branches table for the library that owns this item (MARC21 952$a) |
|
| price | DECIMAL | 8,2 | √ | null |
|
|
purchase price (MARC21 952$g) |
|
| replacementprice | DECIMAL | 8,2 | √ | null |
|
|
cost the library charges to replace the item if it has been marked lost (MARC21 952$v) |
|
| replacementpricedate | DATE | 10 | √ | null |
|
|
the date the price is effective from (MARC21 952$w) |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | itemnumber |
| delholdingbranch | Performance | Asc | holdingbranch |
| delhomebranch | Performance | Asc | homebranch |
| delitembarcodeidx | Performance | Asc | barcode |
| delitembibnoidx | Performance | Asc | biblionumber |
| delitembinoidx | Performance | Asc | biblioitemnumber |
| delitemstocknumberidx | Performance | Asc | stocknumber |
| itype_idx | Performance | Asc | itype |
| timestamp | Performance | Asc | timestamp |
