Columns
| 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) |
|||
| datelastborrowed | DATE | 10 | √ | null |
|
|
the date the item was last checked out |
|||
| datelastseen | DATE | 10 | √ | null |
|
|
the date the item was last see (usually the last time the barcode was scanned or inventory was done) |
|||
| stack | BIT | 0 | √ | null |
|
|
||||
| notforloan | BIT | 0 | 0 |
|
|
authorized value defining why this item is not for loan (MARC21 952$7) |
||||
| damaged | BIT | 0 | 0 |
|
|
authorized value defining this item as damaged (MARC21 952$4) |
||||
| damaged_on | DATETIME | 19 | √ | null |
|
|
the date and time an item was last marked as damaged, NULL if not damaged |
|||
| itemlost | BIT | 0 | 0 |
|
|
authorized value defining this item as lost (MARC21 952$1) |
||||
| itemlost_on | DATETIME | 19 | √ | null |
|
|
the date and time an item was last marked as lost, NULL if not lost |
|||
| withdrawn | BIT | 0 | 0 |
|
|
authorized value defining this item as withdrawn (MARC21 952$0) |
||||
| withdrawn_on | DATETIME | 19 | √ | null |
|
|
the date and time an item was last marked as withdrawn, NULL if not withdrawn |
|||
| itemcallnumber | VARCHAR | 255 | √ | null |
|
|
call number for this item (MARC21 952$o) |
|||
| coded_location_qualifier | VARCHAR | 10 | √ | null |
|
|
coded location qualifier(MARC21 952$f) |
|||
| issues | SMALLINT | 5 | √ | 0 |
|
|
number of times this item has been checked out |
|||
| renewals | SMALLINT | 5 | √ | null |
|
|
number of times this item has been renewed |
|||
| reserves | SMALLINT | 5 | √ | null |
|
|
number of times this item has been placed on hold/reserved |
|||
| restricted | BIT | 0 | √ | null |
|
|
authorized value defining use restrictions for this item (MARC21 952$5) |
|||
| itemnotes | LONGTEXT | 2147483647 | √ | null |
|
|
public notes on this item (MARC21 952$z) |
|||
| itemnotes_nonpublic | LONGTEXT | 2147483647 | √ | null |
|
|
non-public notes on this item (MARC21 952$x) |
|||
| holdingbranch | VARCHAR | 10 | √ | null |
|
|
foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
|||
| timestamp | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
date and time this item was last altered |
||||
| deleted_on | DATETIME | 19 | √ | null |
|
|
date/time of deletion |
|||
| location | VARCHAR | 80 | √ | null |
|
|
authorized value for the shelving location for this item (MARC21 952$c) |
|||
| permanent_location | VARCHAR | 80 | √ | null |
|
|
linked to the CART and PROC temporary locations feature, stores the permanent shelving location |
|||
| onloan | DATE | 10 | √ | null |
|
|
defines if item is checked out (NULL for not checked out, and due date for checked out) |
|||
| cn_source | VARCHAR | 10 | √ | null |
|
|
classification source used on this item (MARC21 952$2) |
|||
| cn_sort | VARCHAR | 255 | √ | null |
|
|
normalized form of the call number (MARC21 952$o) used for sorting |
|||
| ccode | VARCHAR | 80 | √ | null |
|
|
authorized value for the collection code associated with this item (MARC21 952$8) |
|||
| materials | MEDIUMTEXT | 16777215 | √ | null |
|
|
materials specified (MARC21 952$3) |
|||
| uri | MEDIUMTEXT | 16777215 | √ | null |
|
|
URL for the item (MARC21 952$u) |
|||
| itype | VARCHAR | 10 | √ | null |
|
|
foreign key from the itemtypes table defining the type for this item (MARC21 952$y) |
|||
| more_subfields_xml | LONGTEXT | 2147483647 | √ | null |
|
|
additional 952 subfields in XML format |
|||
| enumchron | MEDIUMTEXT | 16777215 | √ | null |
|
|
serial enumeration/chronology for the item (MARC21 952$h) |
|||
| copynumber | VARCHAR | 32 | √ | null |
|
|
copy number (MARC21 952$t) |
|||
| stocknumber | VARCHAR | 32 | √ | null |
|
|
inventory number (MARC21 952$i) |
|||
| new_status | VARCHAR | 32 | √ | null |
|
|
‘new’ value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
|||
| exclude_from_local_holds_priority | BIT | 0 | √ | null |
|
|
Exclude this item from local holds priority |
Indexes
| 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 |
Relationships
Close relationships within degrees of separation
