authority.heading_field_norm_map

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

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

Columns

Column Type Nullable Default Notes

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

id PK

integer

nextval('authority.heading_field_norm_map_id_seq'::regclass)

field FK

integer

→ authority.heading_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`	authority.heading_field(id)	CASCADE	NO ACTION	DEFERRED	`heading_field_norm_map_field_fkey`
`norm`	config.index_normalizer(id)	CASCADE	NO ACTION	DEFERRED	`heading_field_norm_map_norm_fkey`

field

authority.heading_field(id)

CASCADE

NO ACTION

DEFERRED

heading_field_norm_map_field_fkey

norm

config.index_normalizer(id)

CASCADE

NO ACTION

DEFERRED

heading_field_norm_map_norm_fkey

Indexes

Index Method Definition

Index	Method	Definition
`heading_field_norm_map_pkey` PK	btree	`CREATE UNIQUE INDEX heading_field_norm_map_pkey ON authority.heading_field_norm_map USING btree (id)`

heading_field_norm_map_pkey PK

btree

CREATE UNIQUE INDEX heading_field_norm_map_pkey ON authority.heading_field_norm_map USING btree (id)