acq.edi_attr_set_map

↑ acq schema

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: acq.edi_attr, acq.edi_attr_set.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.edi_attr_set_map_id_seq'::regclass)
attr_set FK	`integer`	No		→ acq.edi_attr_set(id)
attr FK	`text`	No		→ acq.edi_attr(key)

id PK

integer

nextval('acq.edi_attr_set_map_id_seq'::regclass)

attr_set FK

integer

→ acq.edi_attr_set(id)

attr FK

text

→ acq.edi_attr(key)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`attr`	acq.edi_attr(key)	CASCADE	NO ACTION	DEFERRED	`edi_attr_set_map_attr_fkey`
`attr_set`	acq.edi_attr_set(id)	CASCADE	NO ACTION	DEFERRED	`edi_attr_set_map_attr_set_fkey`

attr

acq.edi_attr(key)

CASCADE

NO ACTION

DEFERRED

edi_attr_set_map_attr_fkey

attr_set

acq.edi_attr_set(id)

CASCADE

NO ACTION

DEFERRED

edi_attr_set_map_attr_set_fkey

Unique Constraints

edi_attr_set_map_attr_once: (attr_set, attr)

Indexes

Index Method Definition

Index	Method	Definition
`edi_attr_set_map_pkey` PK	btree	`CREATE UNIQUE INDEX edi_attr_set_map_pkey ON acq.edi_attr_set_map USING btree (id)`
`edi_attr_set_map_attr_once` UNIQUE	btree	`CREATE UNIQUE INDEX edi_attr_set_map_attr_once ON acq.edi_attr_set_map USING btree (attr_set, attr)`

edi_attr_set_map_pkey PK

btree

CREATE UNIQUE INDEX edi_attr_set_map_pkey ON acq.edi_attr_set_map USING btree (id)

edi_attr_set_map_attr_once UNIQUE

btree

CREATE UNIQUE INDEX edi_attr_set_map_attr_once ON acq.edi_attr_set_map USING btree (attr_set, attr)