Table testsql_comments.auth_tag_structure Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
authtypecode varchar 10
auth_types.authtypecode auth_tag_structure_ibfk_1 C
tagfield varchar 3
liblibrarian varchar 255
libopac varchar 255
repeatable tinyint 3 0
mandatory tinyint 3 0
authorised_value varchar 10  √  null

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

Column(s) Type Sort Constraint Name
authtypecode + tagfield Primary key Asc/Asc PRIMARY

Close relationships: