gbif_name_words

0 rows


Description

Inverted index of lower-cased words from species and family names in the GBIF backbone dataset. Used to support fast per-word prefix searches.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
gbif_name_id int8 19 null
gbif_names.id gbif_name_words_gbif_name_id_fkeyR
word text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
gbif_name_words_gbif_name_id_idx Performance Asc gbif_name_id
gbif_name_words_word_gbif_name_id_idx Performance Asc/Asc word + gbif_name_id

Relationships