items_search_fields

0 rows

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

name

VARCHAR

255

null

additional_fields.name	Implied ConstraintR
borrower_files.file_name	Implied ConstraintR
courses.course_name	Implied ConstraintR
misc_files.file_name	Implied ConstraintR
patron_lists.name	Implied ConstraintR
reports_dictionary.name	Implied ConstraintR
saved_sql.report_name	Implied ConstraintR
search_field.name	Implied ConstraintR
sms_providers.name	Implied ConstraintR

label

VARCHAR

255

null

tagfield

CHAR

3

null

tagsubfield

CHAR

1

√

null

authorised_values_category

VARCHAR

32

√

null

authorised_value_categories.category_name

items_search_fields_authorised_values_categoryN

Showing 1 to 5 of 5 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	name
items_search_fields_authorised_values_category	Performance	Asc	authorised_values_category

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation