config.metabib_search_alias

↑ config schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: metabib_search_alias_field_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Notes
alias PK	`text`	No
field_class FK	`text`	No	→ config.metabib_class(name)
field FK	`integer`	Yes	→ config.metabib_field(id)

alias PK

text

field_class FK

text

→ config.metabib_class(name)

field FK

integer

Yes

→ config.metabib_field(id)

Primary Key

(alias)

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_search_alias_field_class_fkey`
`field`	config.metabib_field(id)	NO ACTION	CASCADE	DEFERRED	`metabib_search_alias_field_fkey`

field_class

config.metabib_class(name)

NO ACTION

metabib_search_alias_field_class_fkey

field

config.metabib_field(id)

NO ACTION

CASCADE

DEFERRED

metabib_search_alias_field_fkey

Indexes

Index Method Definition

Index	Method	Definition
`metabib_search_alias_pkey` PK	btree	`CREATE UNIQUE INDEX metabib_search_alias_pkey ON config.metabib_search_alias USING btree (alias)`

metabib_search_alias_pkey PK

btree

CREATE UNIQUE INDEX metabib_search_alias_pkey ON config.metabib_search_alias USING btree (alias)