marc_subfield_structure

0 rows


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
important TINYINT 3 0
kohafield VARCHAR 40 √ NULL
tab TINYINT 3 √ 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 TINYINT 3 √ NULL
hidden TINYINT 3 8
frameworkcode VARCHAR 4 ''
seealso VARCHAR 1100 √ NULL
link VARCHAR 80 √ NULL
defaultvalue MEDIUMTEXT 16777215 √ NULL
maxlength INT 10 9999
display_order INT 10 0

Indexes

Constraint Name Type Sort Column(s)
marc_subfield_structure_s_pk 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
PRIMARY Must be unique Asc/Asc/Asc frameworkcode + tagfield + tagsubfield
tab Performance Asc/Asc frameworkcode + tab

Relationships

Close relationships within degrees of separation