items_search_fields


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name VARCHAR 255 null
additional_fields.name Implied Constraint R
borrower_files.file_name Implied Constraint R
courses.course_name Implied Constraint R
misc_files.file_name Implied Constraint R
patron_lists.name Implied Constraint R
reports_dictionary.name Implied Constraint R
saved_sql.report_name Implied Constraint R
search_field.name Implied Constraint R
sms_providers.name Implied Constraint R
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_category N

Table contained 0 rows

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