search_field

171 rows


Columns

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_2 C
name VARCHAR 255 null
items_search_fields.name Implied Constraint R

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', 'year', 'callnumber', 'geo_point') 10 √ NULL
weight DECIMAL 5,2 √ NULL
facet_order TINYINT 3 √ NULL

the order place of the field in facet list if faceted
staff_client BOOLEAN 3 1
opac BOOLEAN 3 1
mandatory BOOLEAN 3 √ NULL

if marked this field is not editable or removable
authorised_value_category VARCHAR 32 √ NULL

Indexes

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

Relationships

Close relationships within degrees of separation