items_search_fields

0 rows


Columns

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

Indexes

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

Relationships

Close relationships within degrees of separation