search.relevance_adjustment

↑ search schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: relevance_adjustment_field_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('search.relevance_adjustment_id_seq'::regclass)
active	`boolean`	No	true
field FK	`integer`	No		→ config.metabib_field(id)
bump_type	`text`	No
multiplier	`numeric`	No	1.0

id PK

integer

nextval('search.relevance_adjustment_id_seq'::regclass)

active

boolean

true

field FK

integer

→ config.metabib_field(id)

bump_type

text

multiplier

numeric

1.0

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`field`	config.metabib_field(id)	NO ACTION	NO ACTION	DEFERRED	`relevance_adjustment_field_fkey`

field

config.metabib_field(id)

NO ACTION

DEFERRED

relevance_adjustment_field_fkey

Check Constraints

relevance_adjustment_bump_type_check: CHECK bump_type = ANY (ARRAY['word_order'::text, 'first_word'::text, 'full_match'::text])

Indexes

Index Method Definition

Index	Method	Definition
`relevance_adjustment_pkey` PK	btree	`CREATE UNIQUE INDEX relevance_adjustment_pkey ON search.relevance_adjustment USING btree (id)`
`bump_once_per_field_idx` UNIQUE	btree	`CREATE UNIQUE INDEX bump_once_per_field_idx ON search.relevance_adjustment USING btree (field, bump_type)`

relevance_adjustment_pkey PK

btree

CREATE UNIQUE INDEX relevance_adjustment_pkey ON search.relevance_adjustment USING btree (id)

bump_once_per_field_idx UNIQUE

btree

CREATE UNIQUE INDEX bump_once_per_field_idx ON search.relevance_adjustment USING btree (field, bump_type)