Table testsql_comments.search_marc_to_field 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
search_marc_map_id int 10
search_marc_map.id search_marc_to_field_ibfk_1 C
search_field_id int 10
search_field.id 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 Jun 26 09:07 NZST 2017

Indexes:
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: