search_marc_to_field

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

search

BIT

0

1

search_marc_map_id

INT

10

null

search_marc_map.id

search_marc_to_field_ibfk_1C

search_field_id

INT

10

null

search_field.id

search_marc_to_field_ibfk_2C

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

1

Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this

Showing 1 to 6 of 6 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation