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 |