Column Type Size Nulls Auto Default Children Parents Comments
biblionumber INT 10 null
deletedbiblio_metadata.biblionumber deletedrecord_metadata_fk_1 C

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

statement of responsibility from MARC record (100$a in MARC21)

title LONGTEXT 2147483647 null

title (without the subtitle) from the MARC record (245$a in MARC21)

unititle LONGTEXT 2147483647 null

uniform title (without the subtitle) from the MARC record (240$a in MARC21)

notes LONGTEXT 2147483647 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 LONGTEXT 2147483647 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 null

the date this record was added to Koha

abstract LONGTEXT 2147483647 null

summary from the MARC record (520$a in MARC21)

Table contained 0 rows


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