Table testsql_comments.biblioitems
information related to bibliographic records in Koha

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
biblioitemnumber int 10  √ 
deletedbiblioitems.biblioitemnumber Implied Constraint R
deleteditems.biblioitemnumber Implied Constraint R
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 mediumtext 16777215  √  null
number mediumtext 16777215  √  null
itemtype varchar 10  √  null
itemtypes.itemtype Implied Constraint R
biblio level item type (MARC21 942$c)
isbn mediumtext 16777215  √  null ISBN (MARC21 020$a)
issn mediumtext 16777215  √  null ISSN (MARC21 022$a)
ean mediumtext 16777215  √  null
publicationyear text 65535  √  null
publishercode varchar 255  √  null publisher (MARC21 260$b)
volumedate date 10  √  null
volumedesc text 65535  √  null volume information (MARC21 362$a)
collectiontitle mediumtext 16777215  √  null
collectionissn text 65535  √  null
collectionvolume mediumtext 16777215  √  null
editionstatement text 65535  √  null
editionresponsibility text 65535  √  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 mediumtext 16777215  √  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 text 65535  √  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 at Tue Jan 16 21:06 NZDT 2018

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

Close relationships  within of separation: