config.metabib_class_ts_map

↑ config schema

Text Search Configs for metabib class indexing

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.metabib_class_ts_map_id_seq'::regclass)
field_class FK	`text`	No		→ config.metabib_class(name)
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
always	`boolean`	No	true

id PK

integer

nextval('config.metabib_class_ts_map_id_seq'::regclass)

field_class FK

text

→ config.metabib_class(name)

ts_config FK

text

→ config.ts_config_list(id)

active

boolean

true

index_weight

character(1)

'C'::bpchar

index_lang

text

Yes

search_lang

text

Yes

always

boolean

true

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`field_class`	config.metabib_class(name)	NO ACTION	NO ACTION	No	`metabib_class_ts_map_field_class_fkey`
`ts_config`	config.ts_config_list(id)	NO ACTION	NO ACTION	No	`metabib_class_ts_map_ts_config_fkey`

field_class

config.metabib_class(name)

NO ACTION

metabib_class_ts_map_field_class_fkey

ts_config

config.ts_config_list(id)

NO ACTION

metabib_class_ts_map_ts_config_fkey

Check Constraints

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

Indexes

Index Method Definition

Index	Method	Definition
`metabib_class_ts_map_pkey` PK	btree	`CREATE UNIQUE INDEX metabib_class_ts_map_pkey ON config.metabib_class_ts_map USING btree (id)`

metabib_class_ts_map_pkey PK

btree

CREATE UNIQUE INDEX metabib_class_ts_map_pkey ON config.metabib_class_ts_map USING btree (id)