0 rows


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
itemtypes.itemtype Implied ConstraintR

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
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 ConstraintR

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


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