Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
|
|
the librarian who approved the tag (borrowers.borrowernumber) |
|||
| weight_total | INT | 10 | 1 |
|
|
the total number of times this tag was used |
Table contained 0 rows
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
