0 rows


Column Type Size Nulls Auto Default Children Parents Comments
itemnumber INT 10 null
accountlines.itemnumber accountlines_ibfk_itemsN
article_requests.itemnumber article_requests_ibfk_3N
branchtransfers.itemnumber branchtransfers_ibfk_3C
club_holds.item_id clubs_holds_ibfk_3C
course_items.itemnumber course_items_ibfk_1C
cover_images.itemnumber bibliocoverimage_fk2C
creator_batches.item_number creator_batches_ibfk_3C
hold_fill_targets.itemnumber hold_fill_targets_ibfk_3C
issues.itemnumber issues_ibfk_2R item_bundles_ibfk_2C
item_bundles.item item_bundles_ibfk_1C
item_group_items.item_id item_group_items_iifk_1C
items_last_borrower.itemnumber items_last_borrower_ibfk_1C
linktracker.itemnumber linktracker_item_ibfkN
old_issues.itemnumber old_issues_ibfk_2N
old_reserves.itemnumber old_reserves_ibfk_3N
recalls.item_id recalls_ibfk_3C
reserves.itemnumber reserves_ibfk_3C
return_claims.itemnumber rc_items_ibfkC
serialitems.itemnumber serialitems_sfk_2C
stockrotationitems.itemnumber_id stockrotationitems_iifkC
tmp_holdsqueue.itemnumber tmp_holdsqueue_ibfk_1C

primary key and unique identifier added by Koha

biblionumber INT 10 0
biblio.biblionumber items_ibfk_4C

foreign key from biblio table used to link this item to the right bib record

biblioitemnumber INT 10 0
biblioitems.biblioitemnumber items_ibfk_1C

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
branches.branchcode items_ibfk_2R

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 0

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$z)

itemnotes_nonpublic LONGTEXT 2147483647 null

non-public notes on this item (MARC21 952$x)

holdingbranch VARCHAR 10 null
branches.branchcode items_ibfk_3R

foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)


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
class_sources.cn_source Implied ConstraintR

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


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