config.metabib_field_index_norm_map

Cascading Deletes: Deleting rows from this table will cascade to: config.metabib_field, config.index_normalizer.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.metabib_field_index_norm_map_id_seq'::regclass)
field FK	`integer`	No		→ config.metabib_field(id)
norm FK	`integer`	No		→ config.index_normalizer(id)
params	`text`	Yes
pos	`integer`	No	0

id PK

integer

nextval('config.metabib_field_index_norm_map_id_seq'::regclass)

field FK

integer

→ config.metabib_field(id)

norm FK

integer

→ config.index_normalizer(id)

params

text

Yes

pos

integer

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`field`	config.metabib_field(id)	CASCADE	NO ACTION	DEFERRED	`metabib_field_index_norm_map_field_fkey`
`norm`	config.index_normalizer(id)	CASCADE	NO ACTION	DEFERRED	`metabib_field_index_norm_map_norm_fkey`

field

config.metabib_field(id)

CASCADE

NO ACTION

DEFERRED

metabib_field_index_norm_map_field_fkey

norm

config.index_normalizer(id)

CASCADE

NO ACTION

DEFERRED

metabib_field_index_norm_map_norm_fkey

Indexes

Index Method Definition

Index	Method	Definition
`metabib_field_index_norm_map_pkey` PK	btree	`CREATE UNIQUE INDEX metabib_field_index_norm_map_pkey ON config.metabib_field_index_norm_map USING btree (id)`

metabib_field_index_norm_map_pkey PK

btree

CREATE UNIQUE INDEX metabib_field_index_norm_map_pkey ON config.metabib_field_index_norm_map USING btree (id)