Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
search_marc_to_field.search_field_id search_marc_to_field_ibfk_2 C
name VARCHAR 255 null Implied Constraint R

the name of the field as it will be stored in the search engine

label VARCHAR 255 null

the human readable name of the field, for display

type enum('', 'string', 'date', 'number', 'boolean', 'sum', 'isbn', 'stdno') 7 null

what type of data this holds, relevant when storing it in the search engine

weight DECIMAL 5,2 null

Table contained 0 rows


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