config.record_attr_index_norm_map

↑ config schema

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

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.record_attr_index_norm_map_id_seq'::regclass)
attr FK	`text`	No		→ config.record_attr_definition(name)
norm FK	`integer`	No		→ config.index_normalizer(id)
params	`text`	Yes
pos	`integer`	No	0

id PK

integer

nextval('config.record_attr_index_norm_map_id_seq'::regclass)

attr FK

text

→ config.record_attr_definition(name)

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
`attr`	config.record_attr_definition(name)	CASCADE	NO ACTION	DEFERRED	`record_attr_index_norm_map_attr_fkey`
`norm`	config.index_normalizer(id)	CASCADE	NO ACTION	DEFERRED	`record_attr_index_norm_map_norm_fkey`

attr

config.record_attr_definition(name)

CASCADE

NO ACTION

DEFERRED

record_attr_index_norm_map_attr_fkey

norm

config.index_normalizer(id)

CASCADE

NO ACTION

DEFERRED

record_attr_index_norm_map_norm_fkey

Indexes

Index Method Definition

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

record_attr_index_norm_map_pkey PK

btree

CREATE UNIQUE INDEX record_attr_index_norm_map_pkey ON config.record_attr_index_norm_map USING btree (id)