config.metabib_field

XPath used for record indexing ingest

This table contains the XPath used to chop up MODS into its indexable parts. Each XPath entry is named and assigned to a "class" of either title, subject, author, keyword, series or identifier.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.metabib_field_id_seq'::regclass)
field_class FK	`text`	No		→ config.metabib_class(name)
name	`text`	No
label	`text`	No
xpath	`text`	Yes
weight	`integer`	No	1
format FK	`text`	No	'mods33'::text	→ config.xml_transform(name)
search_field	`boolean`	No	true
facet_field	`boolean`	No	false
browse_field	`boolean`	No	true
browse_nocase	`boolean`	No	false
browse_xpath	`text`	Yes
browse_sort_xpath	`text`	Yes
facet_xpath	`text`	Yes
display_xpath	`text`	Yes
authority_xpath	`text`	Yes
joiner	`text`	Yes
restrict	`boolean`	No	false
display_field	`boolean`	No	true

id PK

integer

nextval('config.metabib_field_id_seq'::regclass)

field_class FK

text

→ config.metabib_class(name)

name

text

label

text

xpath

text

Yes

weight

integer

format FK

text

'mods33'::text

→ config.xml_transform(name)

search_field

boolean

true

facet_field

boolean

false

browse_field

boolean

true

browse_nocase

boolean

false

browse_xpath

text

Yes

browse_sort_xpath

text

Yes

facet_xpath

text

Yes

display_xpath

text

Yes

authority_xpath

text

Yes

joiner

text

Yes

restrict

boolean

false

display_field

boolean

true

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`field_class`	config.metabib_class(name)	NO ACTION	NO ACTION	No	`metabib_field_field_class_fkey`
`format`	config.xml_transform(name)	NO ACTION	NO ACTION	No	`metabib_field_format_fkey`

field_class

config.metabib_class(name)

NO ACTION

metabib_field_field_class_fkey

format

config.xml_transform(name)

NO ACTION

metabib_field_format_fkey

Indexes

Index Method Definition

Index	Method	Definition
`metabib_field_pkey` PK	btree	`CREATE UNIQUE INDEX metabib_field_pkey ON config.metabib_field USING btree (id)`
`config_metabib_field_class_name_idx` UNIQUE	btree	`CREATE UNIQUE INDEX config_metabib_field_class_name_idx ON config.metabib_field USING btree (field_class, name)`

metabib_field_pkey PK

btree

CREATE UNIQUE INDEX metabib_field_pkey ON config.metabib_field USING btree (id)

config_metabib_field_class_name_idx UNIQUE

btree

CREATE UNIQUE INDEX config_metabib_field_class_name_idx ON config.metabib_field USING btree (field_class, name)

Referenced By

The following tables have foreign keys pointing to config.metabib_field (16 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
authority.control_set_bib_field_metabib_field_map	`metabib_field`	`id`	`control_set_bib_field_metabib_field_map_metabib_field_fkey`
config.display_field_map	`field`	`id`	`display_field_map_field_fkey`
config.metabib_field_index_norm_map	`field`	`id`	`metabib_field_index_norm_map_field_fkey`
config.metabib_field_ts_map	`metabib_field`	`id`	`metabib_field_ts_map_metabib_field_fkey`
config.metabib_field_virtual_map	`real`	`id`	`metabib_field_virtual_map_real_fkey`
config.metabib_field_virtual_map	`virtual`	`id`	`metabib_field_virtual_map_virtual_fkey`
config.metabib_search_alias	`field`	`id`	`metabib_search_alias_field_fkey`
config.z3950_index_field_map	`metabib_field`	`id`	`z3950_index_field_map_metabib_field_fkey`
metabib.author_field_entry	`field`	`id`	`metabib_author_field_entry_field_pkey`
metabib.browse_entry_def_map	`def`	`id`	`browse_entry_def_map_def_fkey`
metabib.identifier_field_entry	`field`	`id`	`metabib_identifier_field_entry_field_pkey`
metabib.keyword_field_entry	`field`	`id`	`metabib_keyword_field_entry_field_pkey`
metabib.series_field_entry	`field`	`id`	`metabib_series_field_entry_field_pkey`
metabib.subject_field_entry	`field`	`id`	`metabib_subject_field_entry_field_pkey`
metabib.title_field_entry	`field`	`id`	`metabib_title_field_entry_field_pkey`
search.relevance_adjustment	`field`	`id`	`relevance_adjustment_field_fkey`