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