0 rows


Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
search_marc_to_field.search_field_id search_marc_to_field_ibfk_2C
name VARCHAR 255 null Implied ConstraintR

the name of the field as it will be stored in the search engine

label VARCHAR 255 null

the human readable name of the field, for display

type enum('', 'string', 'date', 'number', 'boolean', 'sum', 'isbn', 'stdno') 7 null

what type of data this holds, relevant when storing it in the search engine

weight DECIMAL 5,2 null
facet_order TINYINT 3 null

the order place of the field in facet list if faceted

staff_client BIT 0 1
opac BIT 0 1
mandatory BIT 0 null

if marked this field is not editable or removable


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
name Must be unique Asc name