config.metabib_field_ts_map

↑ config schema

Text Search Configs for metabib field indexing

This table contains text search config definitions for storing index_vector values.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.metabib_field_ts_map_id_seq'::regclass)

metabib_field FK

integer

No

→ config.metabib_field(id)

ts_config FK

text

No

→ config.ts_config_list(id)

active

boolean

No

true

index_weight

character(1)

No

'C'::bpchar

index_lang

text

Yes

search_lang

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

metabib_field

config.metabib_field(id)

NO ACTION

CASCADE

DEFERRED

metabib_field_ts_map_metabib_field_fkey

ts_config

config.ts_config_list(id)

NO ACTION

NO ACTION

No

metabib_field_ts_map_ts_config_fkey

Check Constraints

  • metabib_field_ts_map_index_weight_check: CHECK index_weight = ANY (ARRAY['A'::bpchar, 'B'::bpchar, 'C'::bpchar, 'D'::bpchar])

Indexes

Index Method Definition

metabib_field_ts_map_pkey PK

btree

CREATE UNIQUE INDEX metabib_field_ts_map_pkey ON config.metabib_field_ts_map USING btree (id)
Previous
Next