acq.fund_tag_map

Cascading Deletes: Deleting rows from this table will cascade to: acq.fund_tag.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.fund_tag_map_id_seq'::regclass)
fund FK	`integer`	No		→ acq.fund(id)
tag FK	`integer`	Yes		→ acq.fund_tag(id)

id PK

integer

nextval('acq.fund_tag_map_id_seq'::regclass)

fund FK

integer

→ acq.fund(id)

tag FK

integer

Yes

→ acq.fund_tag(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`fund`	acq.fund(id)	NO ACTION	NO ACTION	DEFERRED	`fund_tag_map_fund_fkey`
`tag`	acq.fund_tag(id)	CASCADE	NO ACTION	DEFERRED	`fund_tag_map_tag_fkey`

fund

acq.fund(id)

NO ACTION

DEFERRED

fund_tag_map_fund_fkey

tag

acq.fund_tag(id)

CASCADE

NO ACTION

DEFERRED

fund_tag_map_tag_fkey

Unique Constraints

acqftm_fund_once_per_tag: (fund, tag)

Indexes

Index Method Definition

Index	Method	Definition
`fund_tag_map_pkey` PK	btree	`CREATE UNIQUE INDEX fund_tag_map_pkey ON acq.fund_tag_map USING btree (id)`
`acqftm_fund_once_per_tag` UNIQUE	btree	`CREATE UNIQUE INDEX acqftm_fund_once_per_tag ON acq.fund_tag_map USING btree (fund, tag)`

fund_tag_map_pkey PK

btree

CREATE UNIQUE INDEX fund_tag_map_pkey ON acq.fund_tag_map USING btree (id)

acqftm_fund_once_per_tag UNIQUE

btree

CREATE UNIQUE INDEX acqftm_fund_once_per_tag ON acq.fund_tag_map USING btree (fund, tag)