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
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
shelfnumber int 10 0
virtualshelves
foreign key linking to the virtualshelves table, defines the list that this record has been added to
biblionumber int 10 0
biblio
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
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 Jun 26 10:02 NZST 2017

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

Close relationships  within of separation: