Table testsql_comments.auth_subfield_structure Generated by
SchemaSpy
Legend: SourceForge.net
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_subfield_structure_ibfk_1 C
tagfield varchar 3
tagsubfield varchar 1
liblibrarian varchar 255
libopac varchar 255
repeatable tinyint 3 0
mandatory tinyint 3 0
tab bit 0  √  null
authorised_value varchar 10  √  null
value_builder varchar 80  √  null
seealso varchar 255  √  null
isurl bit 0  √  null
hidden tinyint 3 0
linkid bit 0 0
kohafield varchar 45  √ 
frameworkcode varchar 10
defaultvalue text 65535  √  null

Table contained 0 rows at Mon Jun 26 09:07 NZST 2017

Indexes:
Column(s) Type Sort Constraint Name
authtypecode + tagfield + tagsubfield Primary key Asc/Asc/Asc PRIMARY
authtypecode + tab Performance Asc/Asc tab

Close relationships  within of separation: