search.symspell_dictionary_updates

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
transaction_id	`bigint`	Yes
keyword_count	`integer`	No	0
title_count	`integer`	No	0
author_count	`integer`	No	0
subject_count	`integer`	No	0
series_count	`integer`	No	0
identifier_count	`integer`	No	0
prefix_key	`text`	No
keyword_suggestions	`text[]`	Yes
title_suggestions	`text[]`	Yes
author_suggestions	`text[]`	Yes
subject_suggestions	`text[]`	Yes
series_suggestions	`text[]`	Yes
identifier_suggestions	`text[]`	Yes

transaction_id

bigint

Yes

keyword_count

integer

title_count

integer

author_count

integer

subject_count

integer

series_count

integer

identifier_count

integer

prefix_key

text

keyword_suggestions

text[]

Yes

title_suggestions

text[]

Yes

author_suggestions

text[]

Yes

subject_suggestions

text[]

Yes

series_suggestions

text[]

Yes

identifier_suggestions

text[]

Yes

Index Method Definition

Index	Method	Definition
`symspell_dictionary_updates_tid_idx`	btree	`CREATE INDEX symspell_dictionary_updates_tid_idx ON search.symspell_dictionary_updates USING btree (transaction_id)`

symspell_dictionary_updates_tid_idx

btree

CREATE INDEX symspell_dictionary_updates_tid_idx ON search.symspell_dictionary_updates USING btree (transaction_id)