Chapter 22. Schema search

Table of Contents

Tables in search
best_tsconfig
relevance_adjustment
Functions in search

Below are the tables, views and functions for search

Tables in search

best_tsconfig

  • id integer
  • ts_config text

relevance_adjustment

  • id serial PRIMARY KEY
  • active boolean NOT NULL DEFAULT true
  • field integer NOT NULL REFERENCES config.table.metabib-field
  • bump_type text NOT NULL
  • multiplier numeric NOT NULL DEFAULT 1.0

Constraints on relevance_adjustment

  • relevance_adjustment_bump_type_check CHECK bump_type = ANY (ARRAY['word_order'::text