Table testsql_comments.biblio 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
biblionumber int 10  √ 
aqorders.biblionumber aqorders_ibfk_2 N
biblioimages.biblionumber bibliocoverimage_fk1 C
biblioitems.biblionumber biblioitems_ibfk_1 C
hold_fill_targets.biblionumber hold_fill_targets_ibfk_2 C
oai_sets_biblios.biblionumber oai_sets_biblios_ibfk_1 C
old_reserves.biblionumber old_reserves_ibfk_2 N
ratings.biblionumber ratings_ibfk_2 C
reserves.biblionumber reserves_ibfk_2 C
reviews.biblionumber reviews_ibfk_2 C
tags_all.biblionumber tags_biblionumber_fk_1 C
tags_index.biblionumber tags_index_biblionumber_fk_1 C
virtualshelfcontents.biblionumber shelfcontents_ibfk_2 C
deletedbiblio.biblionumber Implied Constraint R
unique identifier assigned to each bibliographic record
frameworkcode varchar 4
biblio_framework.frameworkcode Implied Constraint R
foriegn key from the biblio_framework table to identify which framework was used in cataloging this record
author mediumtext 16777215  √  null statement of responsibility from MARC record (100$a in MARC21)
title mediumtext 16777215  √  null title (without the subtitle) from the MARC record (245$a in MARC21)
unititle mediumtext 16777215  √  null uniform title (without the subtitle) from the MARC record (240$a in MARC21)
notes mediumtext 16777215  √  null values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
serial bit 0  √  null Boolean indicating whether biblio is for a serial
seriestitle mediumtext 16777215  √  null
copyrightdate smallint 5  √  null publication or copyright date from the MARC record
timestamp timestamp 19 CURRENT_TIMESTAMP date and time this record was last touched
datecreated date 10 the date this record was added to Koha
abstract mediumtext 16777215  √  null summary from the MARC record (520$a in MARC21)

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

Indexes:
Column(s) Type Sort Constraint Name
biblionumber Primary key Asc PRIMARY
biblionumber Performance Asc blbnoidx

Close relationships  within of separation: