acq.fund_allocation

Cascading Deletes: Deleting rows from this table will cascade to: acq.fund, acq.funding_source.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.fund_allocation_id_seq'::regclass)
funding_source FK	`integer`	No		→ acq.funding_source(id)
fund FK	`integer`	No		→ acq.fund(id)
amount	`numeric`	No
allocator FK	`integer`	No		→ actor.usr(id)
note	`text`	Yes
create_time	`timestamp with time zone`	No	now()

id PK

integer

nextval('acq.fund_allocation_id_seq'::regclass)

funding_source FK

integer

→ acq.funding_source(id)

fund FK

integer

→ acq.fund(id)

amount

numeric

allocator FK

integer

→ actor.usr(id)

note

text

Yes

create_time

timestamp with time zone

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`allocator`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`fund_allocation_allocator_fkey`
`fund`	acq.fund(id)	CASCADE	CASCADE	DEFERRED	`fund_allocation_fund_fkey`
`funding_source`	acq.funding_source(id)	CASCADE	CASCADE	DEFERRED	`fund_allocation_funding_source_fkey`

allocator

actor.usr(id)

NO ACTION

DEFERRED

fund_allocation_allocator_fkey

fund

acq.fund(id)

CASCADE

DEFERRED

fund_allocation_fund_fkey

funding_source

acq.funding_source(id)

CASCADE

DEFERRED

fund_allocation_funding_source_fkey

Indexes

Index Method Definition

Index	Method	Definition
`fund_allocation_pkey` PK	btree	`CREATE UNIQUE INDEX fund_allocation_pkey ON acq.fund_allocation USING btree (id)`
`fund_alloc_allocator_idx`	btree	`CREATE INDEX fund_alloc_allocator_idx ON acq.fund_allocation USING btree (allocator)`

fund_allocation_pkey PK

btree

CREATE UNIQUE INDEX fund_allocation_pkey ON acq.fund_allocation USING btree (id)

fund_alloc_allocator_idx

btree

CREATE INDEX fund_alloc_allocator_idx ON acq.fund_allocation USING btree (allocator)