Table testsql_comments.ratings
information related to the star ratings in the OPAC

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 Tue Dec 27 17:18 NZDT 2016

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

Close relationships  within of separation: