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 |
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
