0 rows


Column Type Size Nulls Auto Default Children Parents Comments
search BIT 0 1
search_marc_map_id INT 10 null search_marc_to_field_ibfk_1C
search_field_id INT 10 null search_marc_to_field_ibfk_2C
facet BIT 0 0

true if a facet field should be generated for this

suggestible BIT 0 0

true if this field can be used to generate suggestions for browse

sort BIT 0 1

Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc search_marc_map_id + search_field_id
search_field_id Performance Asc search_field_id