marc_subfield_structure


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tagfield VARCHAR 3
tagsubfield VARCHAR 1
liblibrarian VARCHAR 255
libopac VARCHAR 255
repeatable TINYINT 3 0
mandatory TINYINT 3 0
kohafield VARCHAR 40 √ null
tab BIT 0 √ null
authorised_value VARCHAR 32 √ null
authorised_value_categories.category_name marc_subfield_structure_ibfk_1 N
authtypecode VARCHAR 20 √ null
value_builder VARCHAR 80 √ null
isurl BIT 0 √ null
hidden BIT 0 8
frameworkcode VARCHAR 4
seealso VARCHAR 1100 √ null
link VARCHAR 80 √ null
defaultvalue MEDIUMTEXT 16777215 √ null
maxlength INT 10 9999

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc frameworkcode + tagfield + tagsubfield
kohafield Performance Asc/Asc frameworkcode + kohafield
kohafield_2 Performance Asc kohafield
marc_subfield_structure_ibfk_1 Performance Asc authorised_value
tab Performance Asc/Asc frameworkcode + tab

Relationships

Close relationships within degrees of separation