Table testsql_comments.virtualshelfcontents
information about the titles in a list (or virtual shelf)

 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
shelfnumber int 10 0
virtualshelves.shelfnumber virtualshelfcontents_ibfk_1 C
foreign key linking to the virtualshelves table, defines the list that this record has been added to
biblionumber int 10 0
biblio.biblionumber shelfcontents_ibfk_2 C
foreign key linking to the biblio table, defines the bib record that has been added to the list
flags int 10  √  null
dateadded timestamp 19 CURRENT_TIMESTAMP date and time this bib record was added to the list
borrowernumber int 10  √  null
borrowers.borrowernumber shelfcontents_ibfk_3 N
borrower number that created this list entry (only the first one is saved: no need for use in/as key)

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
biblionumber Performance Asc biblionumber
borrowernumber Performance Asc shelfcontents_ibfk_3
shelfnumber Performance Asc shelfnumber

Close relationships  within of separation: