| tag_id |
INT |
10 |
|
√ |
null |
|
|
unique id and primary key |
| borrowernumber |
INT |
10 |
√ |
|
null |
|
| borrowers.borrowernumber |
tags_borrowers_fk_1N |
|
the patron who added the tag (borrowers.borrowernumber) |
| biblionumber |
INT |
10 |
|
|
null |
|
| biblio.biblionumber |
tags_biblionumber_fk_1C |
|
the bib record this tag was left on (biblio.biblionumber) |
| term |
VARCHAR |
191 |
|
|
null |
|
|
the tag |
| language |
INT |
10 |
√ |
|
null |
|
|
the language the tag was left in |
| date_created |
DATETIME |
19 |
|
|
null |
|
|
the date the tag was added |
