config.metabib_field_virtual_map

Maps between real (physically extracted) index definitions and virtual (target sync, no required extraction of its own) index definitions.

The virtual side may not extract any data of its own, but will collect data from all of the real fields. This reduces extraction (ingest) overhead by eliminating duplcated extraction, and allows for searching across novel combinations of fields, such as names used as either subjects or authors. By preserving this mapping rather than defining duplicate extractions, information about the originating, "real" index definitions can be used in interesting ways, such as highlighting in search results.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.metabib_field_virtual_map_id_seq'::regclass)

real FK

integer

No

config.metabib_field(id)

virtual FK

integer

No

config.metabib_field(id)

weight

integer

No

1

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

real

config.metabib_field(id)

NO ACTION

NO ACTION

No

metabib_field_virtual_map_real_fkey

virtual

config.metabib_field(id)

NO ACTION

NO ACTION

No

metabib_field_virtual_map_virtual_fkey

Indexes

Index Method Definition

metabib_field_virtual_map_pkey PK

btree

CREATE UNIQUE INDEX metabib_field_virtual_map_pkey ON config.metabib_field_virtual_map USING btree (id)