auth_subfield_structure

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
authtypecode VARCHAR 10
auth_types.authtypecode auth_subfield_structure_ibfk_1C
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 MEDIUMTEXT 16777215 √ null

Indexes

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

Relationships

Close relationships within degrees of separation