Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
itemnumber | INT | 10 | √ | null |
|
|
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/issued |
|||||||||||||||||||||||||||
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 | √ | null |
|
|
number of times this item has been checked out/issued |
|||||||||||||||||||||||||||
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$x) |
|||||||||||||||||||||||||||
itemnotes_nonpublic | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||||||||||||||||||
holdingbranch | VARCHAR | 10 | √ | null |
|
|
foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
|||||||||||||||||||||||||||
paidfor | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||||||||||||||||||||||
timestamp | TIMESTAMP | 19 | current_timestamp() |
|
|
date and time this item was last altered |
||||||||||||||||||||||||||||
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 |
|
|
||||||||||||||||||||||||||||
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 | VARCHAR | 255 | √ | 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. |
Table contained 0 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | itemnumber |
holdingbranch | Performance | Asc | holdingbranch |
homebranch | Performance | Asc | homebranch |
itembarcodeidx | Must be unique | Asc | barcode |
itembibnoidx | Performance | Asc | biblionumber |
itembinoidx | Performance | Asc | biblioitemnumber |
itemcallnumber | Performance | Asc | itemcallnumber |
items_ccode | Performance | Asc | ccode |
items_location | Performance | Asc | location |
itemstocknumberidx | Performance | Asc | stocknumber |
itype_idx | Performance | Asc | itype |
timestamp | Performance | Asc | timestamp |