term |
VARCHAR |
191 |
|
|
null |
|
|
the tag |
approved |
INT |
10 |
|
|
0 |
|
|
whether the tag is approved or not (1=yes, 0=pending, -1=rejected) |
date_approved |
DATETIME |
19 |
√ |
|
null |
|
|
the date this tag was approved |
approved_by |
INT |
10 |
√ |
|
null |
|
borrowers.borrowernumber
|
tags_approval_borrowers_fk_1 N
|
|
the librarian who approved the tag (borrowers.borrowernumber) |
weight_total |
INT |
10 |
|
|
1 |
|
|
the total number of times this tag was used |