Column Type Size Nulls Auto Default Children Parents Comments
biblioitemnumber INT 10 0

primary key, unique identifier assigned by Koha

biblionumber INT 10 0

foreign key linking this table to the biblio table

volume LONGTEXT 2147483647 null
number LONGTEXT 2147483647 null
itemtype VARCHAR 10 null

biblio level item type (MARC21 942$c)

isbn LONGTEXT 2147483647 null

ISBN (MARC21 020$a)

issn LONGTEXT 2147483647 null

ISSN (MARC21 022$a)

ean LONGTEXT 2147483647 null
publicationyear MEDIUMTEXT 16777215 null
publishercode VARCHAR 255 null

publisher (MARC21 260$b)

volumedate DATE 10 null
volumedesc MEDIUMTEXT 16777215 null

volume information (MARC21 362$a)

collectiontitle LONGTEXT 2147483647 null
collectionissn MEDIUMTEXT 16777215 null
collectionvolume LONGTEXT 2147483647 null
editionstatement MEDIUMTEXT 16777215 null
editionresponsibility MEDIUMTEXT 16777215 null
timestamp TIMESTAMP 19 current_timestamp()
illus VARCHAR 255 null

illustrations (MARC21 300$b)

pages VARCHAR 255 null

number of pages (MARC21 300$c)

notes LONGTEXT 2147483647 null
size VARCHAR 255 null

material size (MARC21 300$c)

place VARCHAR 255 null

publication place (MARC21 260$a)

lccn VARCHAR 25 null

library of congress control number (MARC21 010$a)

url MEDIUMTEXT 16777215 null

url (MARC21 856$u)

cn_source VARCHAR 10 null
class_sources.cn_source Implied Constraint R

classification source (MARC21 942$2)

cn_class VARCHAR 30 null
cn_item VARCHAR 10 null
cn_suffix VARCHAR 10 null
cn_sort VARCHAR 255 null

normalized version of the call number used for sorting

agerestriction VARCHAR 255 null

target audience/age restriction from the bib record (MARC21 521$a)

totalissues INT 10 null

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc biblioitemnumber
bibinoidx Performance Asc biblioitemnumber
bibnoidx Performance Asc biblionumber
ean Performance Asc ean
isbn Performance Asc isbn
itemtype_idx Performance Asc itemtype
publishercode Performance Asc publishercode
timestamp Performance Asc timestamp