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