Table testsql_comments.search_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
id int 10  √ 
search_marc_to_field.search_field_id search_marc_to_field_ibfk_2 C Implied Constraint R
name varchar 255 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 Mon Jul 16 08:37 NZST 2018

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

Close relationships  within of separation: