reviewid |
INT |
10 |
|
√ |
null |
|
|
unique identifier for this comment |
borrowernumber |
INT |
10 |
√ |
|
null |
|
|
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 |
MEDIUMTEXT |
16777215 |
√ |
|
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 |