search_field


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') 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

Table contained 0 rows

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