Table testsql_comments.items_search_fields Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
name varchar 255
additional_fields.name Implied Constraint R
patron_lists.name Implied Constraint R
reports_dictionary.name Implied Constraint R
search_field.name Implied Constraint R
sms_providers.name Implied Constraint R
label varchar 255
tagfield char 3
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 at Mon Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: