Table testsql_comments.search_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
id int 10  √ 
search_marc_to_field.search_field_id search_marc_to_field_ibfk_2 C
fieldmapping.id Implied Constraint R
name varchar 255
items_search_fields.name Implied Constraint R
the name of the field as it will be stored in the search engine
label varchar 255 the human readable name of the field, for display
type enum 7 what type of data this holds, relevant when storing it in the search engine

Table contained 0 rows at Tue Dec 27 15:49 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
name Must be unique Asc name

Close relationships  within of separation: