0 rows


Column Type Size Nulls Auto Default Children Parents Comments
biblionumber INT 10 null
aqorders.biblionumber aqorders_ibfk_2N
article_requests.biblionumber article_requests_ibfk_2C
biblio_metadata.biblionumber record_metadata_fk_1C
biblioitems.biblionumber biblioitems_ibfk_1C
club_holds.biblio_id clubs_holds_ibfk_2C
cover_images.biblionumber bibliocoverimage_fk1C
hold_fill_targets.biblionumber hold_fill_targets_ibfk_2C
items.biblionumber items_ibfk_4C
old_reserves.biblionumber old_reserves_ibfk_2N
ratings.biblionumber ratings_ibfk_2C
reserves.biblionumber reserves_ibfk_2C
reviews.biblionumber reviews_ibfk_2C
serial.biblionumber serial_ibfk_1C
subscription.biblionumber subscription_ibfk_3C
subscriptionhistory.biblionumber subscription_history_ibfk_1C
suggestions.biblionumber suggestions_ibfk_biblionumberN
tags_all.biblionumber tags_biblionumber_fk_1C
tags_index.biblionumber tags_index_biblionumber_fk_1C
virtualshelfcontents.biblionumber shelfcontents_ibfk_2C

unique identifier assigned to each bibliographic record

frameworkcode VARCHAR 4
biblio_framework.frameworkcode Implied ConstraintR

foreign 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)

medium LONGTEXT 2147483647 null

medium from the MARC record (245$h in MARC21)

subtitle LONGTEXT 2147483647 null

remainder of the title from the MARC record (245$b in MARC21)

part_number LONGTEXT 2147483647 null

part number from the MARC record (245$n in MARC21)

part_name LONGTEXT 2147483647 null

part name from the MARC record (245$p 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)


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