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
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber int 10
borrowers.borrowernumber ratings_ibfk_1 C
the borrowernumber of the patron who left this rating (borrowers.borrowernumber)
biblionumber int 10
biblio.biblionumber ratings_ibfk_2 C
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 09:22 NZST 2018

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

Close relationships  within of separation: