Table testsql_comments.reviews
patron opac comments

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
reviewid int 10  √  unique identifier for this comment
borrowernumber int 10  √  null
borrowers.borrowernumber reviews_ibfk_1 N
foreign key from the borrowers table defining which patron left this comment
biblionumber int 10  √  null
biblio.biblionumber reviews_ibfk_2 C
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 Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
reviewid Primary key Asc PRIMARY
borrowernumber Performance Asc reviews_ibfk_1
biblionumber Performance Asc reviews_ibfk_2

Close relationships  within of separation: