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  √ 
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 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 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 at Mon Jul 16 08:37 NZST 2018

Indexes:
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: