metabib.combined_author_field_entry

↑ metabib schema

Columns

Column Type Nullable Default Notes

Column	Type	Nullable
record	`bigint`	No
metabib_field	`integer`	Yes
index_vector	`tsvector`	No

record

bigint

metabib_field

integer

Yes

index_vector

tsvector

Indexes

Index Method Definition

Index	Method	Definition
`metabib_combined_author_field_entry_fakepk_idx` UNIQUE	btree	`CREATE UNIQUE INDEX metabib_combined_author_field_entry_fakepk_idx ON metabib.combined_author_field_entry USING btree (record, COALESCEmetabib_field)::text, ''::text`
`metabib_combined_author_field_entry_index_vector_idx`	GIN	`CREATE INDEX metabib_combined_author_field_entry_index_vector_idx ON metabib.combined_author_field_entry USING gin (index_vector)`
`metabib_combined_author_field_source_idx`	btree	`CREATE INDEX metabib_combined_author_field_source_idx ON metabib.combined_author_field_entry USING btree (metabib_field)`

metabib_combined_author_field_entry_fakepk_idx UNIQUE

btree

CREATE UNIQUE INDEX metabib_combined_author_field_entry_fakepk_idx ON metabib.combined_author_field_entry USING btree (record, COALESCEmetabib_field)::text, ''::text

metabib_combined_author_field_entry_index_vector_idx

GIN

CREATE INDEX metabib_combined_author_field_entry_index_vector_idx ON metabib.combined_author_field_entry USING gin (index_vector)

metabib_combined_author_field_source_idx

btree

CREATE INDEX metabib_combined_author_field_source_idx ON metabib.combined_author_field_entry USING btree (metabib_field)