config.metabib_class

Columns

Column Type Nullable Default Notes

name PK

text

No

label

text

No

buoyant

boolean

No

false

restrict

boolean

No

false

combined

boolean

No

false

a_weight

numeric

No

1.0

b_weight

numeric

No

0.4

c_weight

numeric

No

0.2

d_weight

numeric

No

0.1

variant_authority_suggestion

boolean

No

true

symspell_transfer_case

boolean

No

true

symspell_skip_correct

boolean

No

false

symspell_suggestion_verbosity

integer

No

2

max_phrase_edit_distance

integer

No

2

suggestion_word_option_count

integer

No

5

max_suggestions

integer

No

'-1'::integer

low_result_threshold

integer

No

0

min_suggestion_use_threshold

integer

No

1

soundex_weight

integer

No

0

pg_trgm_weight

integer

No

0

keyboard_distance_weight

integer

No

0

Primary Key

(name)

Unique Constraints

  • metabib_class_label_key: (label)

Indexes

Index Method Definition

metabib_class_pkey PK

btree

CREATE UNIQUE INDEX metabib_class_pkey ON config.metabib_class USING btree (name)

metabib_class_label_key UNIQUE

btree

CREATE UNIQUE INDEX metabib_class_label_key ON config.metabib_class USING btree (label)

Referenced By

The following tables have foreign keys pointing to config.metabib_class (3 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

config.metabib_class_ts_map

field_class

name

metabib_class_ts_map_field_class_fkey

config.metabib_field

field_class

name

metabib_field_field_class_fkey

config.metabib_search_alias

field_class

name

metabib_search_alias_field_class_fkey