tags_approval

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
term VARCHAR 191 null
tags_all.term Implied Constraint R
tags_index.term tags_index_term_fk_1 C

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc term
tags_approval_borrowers_fk_1 Performance Asc approved_by

Relationships