Column    |   Type   | Collation | Nullable |                     Default                      | Storage  | Stats target | Description
--------------+----------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
 id           | bigint   |           | not null | nextval('metabib.browse_entry_id_seq'::regclass) | plain    |              |
 value        | text     |           |          |                                                  | extended |              |
 index_vector | tsvector |           |          |                                                  | extended |              |
 sort_value   | text     |           | not null |                                                  | extended |              |
Indexes:
    "browse_entry_pkey" PRIMARY KEY, btree (id)
    "browse_entry_sort_value_value_key" UNIQUE CONSTRAINT, btree (sort_value, value)
    "browse_entry_sort_value_idx" btree (sort_value)
    "metabib_browse_entry_index_vector_idx" gin (index_vector)
Referenced by:
    TABLE "metabib.browse_entry_def_map" CONSTRAINT "browse_entry_def_map_entry_fkey" FOREIGN KEY (entry) REFERENCES metabib.browse_entry(id)
    TABLE "metabib.browse_entry_simple_heading_map" CONSTRAINT "browse_entry_simple_heading_map_entry_fkey" FOREIGN KEY (entry) REFERENCES metabib.browse_entry(id)
Triggers:
    metabib_browse_entry_fti_trigger BEFORE INSERT OR UPDATE ON metabib.browse_entry FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('keyword')