auth_subfield_structure


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 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

Table contained 0 rows

Indexes

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

Relationships