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

Close relationships within degrees of separation