Table testsql_comments.biblioitems Generated by
SchemaSpy
Legend: SourceForge.net
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  √ 
items.biblioitemnumber items_ibfk_1 C
deletedbiblioitems.biblioitemnumber Implied Constraint R
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 varchar 13  √  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)
marc longblob 2147483647  √  null full bibliographic MARC record
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
marcxml longtext 2147483647  √  null full bibliographic MARC record in MARCXML

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

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

Close relationships  within of separation: