Table testsql_comments.search_marc_to_field Generated by
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
search_marc_map_id int 10 search_marc_to_field_ibfk_1 C
search_field_id int 10 search_marc_to_field_ibfk_2 C
facet bit 0  √  0 true if a facet field should be generated for this
suggestible bit 0  √  0 true if this field can be used to generate suggestions for browse
sort bit 0  √  null true/false creates special sort handling, null doesn't

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Column(s) Type Sort Constraint Name
search_marc_map_id + search_field_id Primary key Asc/Asc PRIMARY
search_field_id Performance Asc search_field_id

Close relationships: