Table testsql_comments.tags_all Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
tag_id int 10  √  unique id and primary key
borrowernumber int 10
borrowers
the patron who added the tag (borrowers.borrowernumber)
biblionumber int 10
biblio
the bib record this tag was left on (biblio.biblionumber)
term varchar 255
the tag
language int 10  √  null the language the tag was left in
date_created datetime 19 the date the tag was added

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

Indexes:
Column(s) Type Sort
tag_id Primary key Asc
biblionumber Performance Asc
borrowernumber Performance Asc

Close relationships  within of separation: