tag_id |
INT |
10 |
|
√ |
null |
|
|
unique id and primary key |
borrowernumber |
INT |
10 |
√ |
|
null |
|
borrowers.borrowernumber
|
tags_borrowers_fk_1 N
|
|
the patron who added the tag (borrowers.borrowernumber) |
biblionumber |
INT |
10 |
|
|
null |
|
biblio.biblionumber
|
tags_biblionumber_fk_1 C
|
|
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 |