auth_subfield_structure

13280 rows


Columns

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 BOOLEAN 3 √ NULL
authorised_value VARCHAR 32 √ NULL
value_builder VARCHAR 80 √ NULL
seealso VARCHAR 255 √ NULL
isurl BOOLEAN 3 √ NULL
hidden TINYINT 3 0
linkid BOOLEAN 3 0
kohafield VARCHAR 45 √ ''
frameworkcode VARCHAR 10 ''
defaultvalue MEDIUMTEXT 16777215 √ NULL
display_order INT 10 0

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