Table testsql_comments.ratings 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
borrowernumber int 10
borrowers
the borrowernumber of the patron who left this rating (borrowers.borrowernumber)
biblionumber int 10
biblio
the biblio this rating is for (biblio.biblionumber)
rating_value bit 0 the rating, from 1 to 5
timestamp timestamp 19 CURRENT_TIMESTAMP

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Indexes:
Column(s) Type Sort
borrowernumber + biblionumber Primary key Asc/Asc
biblionumber Performance Asc

Close relationships  within of separation: