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 BOOLEAN 3 0

whether this filter is shown on OPAC
staff_client BOOLEAN 3 0

whether this filter is shown in staff client

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc search_filter_id

Relationships

Close relationships within degrees of separation