ratings

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber INT 10 null
borrowers.borrowernumber ratings_ibfk_1C

the borrowernumber of the patron who left this rating (borrowers.borrowernumber)

biblionumber INT 10 null
biblio.biblionumber ratings_ibfk_2C

the biblio this rating is for (biblio.biblionumber)

rating_value BIT 0 null

the rating, from 1 to 5

timestamp TIMESTAMP 19 current_timestamp()

Indexes

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

Relationships