Table testsql_comments.reviews
patron opac comments

 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
reviewid int 10  √  unique identifier for this comment
borrowernumber int 10  √  null
borrowers
foreign key from the borrowers table defining which patron left this comment
biblionumber int 10  √  null
biblio
foreign key from the biblio table defining which bibliographic record this comment is for
review text 65535  √  null the body of the comment
approved tinyint 3  √  0 whether this comment has been approved by a librarian (1 for yes, 0 for no)
datereviewed datetime 19  √  null the date the comment was left

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

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

Close relationships  within of separation: