Table testsql_comments.items
holdings/item information

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
itemnumber int 10  √ 
accountlines
branchtransfers
course_items
creator_batches
hold_fill_targets
issues
items_last_borrower
old_issues
old_reserves
reserves
serialitems
primary key and unique identifier added by Koha
biblionumber int 10 0
biblio
foreign key from biblio table used to link this item to the right bib record
biblioitemnumber int 10 0
biblioitems
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 mediumtext 16777215  √  null where the item was purchased (MARC21 952$e)
homebranch varchar 10  √  null
branches
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)
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 mediumtext 16777215  √  null public notes on this item (MARC21 952$x)
itemnotes_nonpublic mediumtext 16777215  √  null
holdingbranch varchar 10  √  null
branches
foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
paidfor mediumtext 16777215  √  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 checkout 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 10  √  null authorized value for the collection code associated with this item (MARC21 952$8)
materials text 65535  √  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 text 65535  √  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 at Tue Dec 27 16:10 NZDT 2016

Indexes:
Column(s) Type Sort Anomalies
itemnumber Primary key Asc  
holdingbranch Performance Asc  
homebranch Performance Asc  
barcode Must be unique Asc This unique column is also nullable
biblionumber Performance Asc  
biblioitemnumber Performance Asc  
itemcallnumber Performance Asc  
ccode Performance Asc  
location Performance Asc  
stocknumber Performance Asc  
itype Performance Asc  

Close relationships  within of separation: