biblioitems

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
biblioitemnumber INT 10 null
items.biblioitemnumber items_ibfk_1 C

primary key, unique identifier assigned by Koha

biblionumber INT 10 0
biblio.biblionumber biblioitems_ibfk_1 C

foreign key linking this table to the biblio table

volume LONGTEXT 2147483647 null
number LONGTEXT 2147483647 null
itemtype VARCHAR 10 null
itemtypes.itemtype Implied Constraint R

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 TEXT 65535 null

publisher (MARC21 260$b and 264$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 TEXT 65535 null

illustrations (MARC21 300$b)

pages TEXT 65535 null

number of pages (MARC21 300$a)

notes LONGTEXT 2147483647 null
size TEXT 65535 null

material size (MARC21 300$c)

place TEXT 65535 null

publication place (MARC21 260$a and 264$a)

lccn LONGTEXT 2147483647 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

Indexes

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
issn Performance Asc issn
itemtype_idx Performance Asc itemtype
publishercode Performance Asc publishercode
timestamp Performance Asc timestamp

Relationships