acq.fund_tag

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.fund_tag_id_seq'::regclass)
owner FK	`integer`	No		→ actor.org_unit(id)
name	`text`	No

id PK

integer

nextval('acq.fund_tag_id_seq'::regclass)

owner FK

integer

→ actor.org_unit(id)

name

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owner`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`fund_tag_owner_fkey`

owner

actor.org_unit(id)

NO ACTION

DEFERRED

fund_tag_owner_fkey

Unique Constraints

acqft_tag_once_per_owner: (name, owner)

Indexes

Index Method Definition

Index	Method	Definition
`fund_tag_pkey` PK	btree	`CREATE UNIQUE INDEX fund_tag_pkey ON acq.fund_tag USING btree (id)`
`acqft_tag_once_per_owner` UNIQUE	btree	`CREATE UNIQUE INDEX acqft_tag_once_per_owner ON acq.fund_tag USING btree (name, owner)`

fund_tag_pkey PK

btree

CREATE UNIQUE INDEX fund_tag_pkey ON acq.fund_tag USING btree (id)

acqft_tag_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX acqft_tag_once_per_owner ON acq.fund_tag USING btree (name, owner)

Referenced By

The following tables have foreign keys pointing to acq.fund_tag (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.fund_tag_map	`tag`	`id`	`fund_tag_map_tag_fkey`

acq.fund_tag_map

tag

id

fund_tag_map_tag_fkey