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) |
||||
| bookable | TINYINT | 3 | √ | NULL |
|
|
nullable boolean value defining whether this this item is available for bookings or not |
||||
| 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 | DATETIME | 19 | √ | NULL |
|
|
the date the item was last see (usually the last time the barcode was scanned or inventory was done) |
||||
| stack | TINYINT | 3 | √ | NULL |
|
|
|||||
| notforloan | TINYINT | 3 | 0 |
|
|
authorized value defining why this item is not for loan (MARC21 952$7) |
|||||
| damaged | TINYINT | 3 | 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 | TINYINT | 3 | 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 | TINYINT | 3 | 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 |
||||
| localuse | SMALLINT | 5 | √ | NULL |
|
|
number of times this item has been recorded as localuse |
||||
| reserves | SMALLINT | 5 | √ | NULL |
|
|
number of times this item has been placed on hold/reserved |
||||
| restricted | TINYINT | 3 | √ | 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 | TINYINT | 3 | √ | NULL |
|
|
Exclude this item from local holds priority |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| deleteditems_s_pk | 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 |
| PRIMARY | Must be unique | Asc | itemnumber |
| timestamp | Performance | Asc | timestamp |
Relationships
Close relationships within degrees of separation
