search_filters

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
search_filter_id INT 10 √ null
name VARCHAR 255 null
items_search_fields.name Implied Constraint R

filter name
query MEDIUMTEXT 16777215 √ NULL

filter query part
limits MEDIUMTEXT 16777215 √ NULL

filter limits part
opac TINYINT 3 0

whether this filter is shown on OPAC
staff_client TINYINT 3 0

whether this filter is shown in staff client

Indexes

Constraint Name Type Sort Column(s)
search_filters_s_pk Primary key Asc search_filter_id
PRIMARY Must be unique Asc search_filter_id

Relationships

Close relationships within degrees of separation