acq.debit_attribution

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Notes
id PK	`integer`	No
fund_debit FK	`integer`	No	→ acq.fund_debit(id)
debit_amount	`numeric`	No
funding_source_credit FK	`integer`	Yes	→ acq.funding_source_credit(id)
credit_amount	`numeric`	Yes

id PK

integer

fund_debit FK

integer

→ acq.fund_debit(id)

debit_amount

numeric

funding_source_credit FK

integer

Yes

→ acq.funding_source_credit(id)

credit_amount

numeric

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`fund_debit`	acq.fund_debit(id)	NO ACTION	NO ACTION	DEFERRED	`debit_attribution_fund_debit_fkey`
`funding_source_credit`	acq.funding_source_credit(id)	NO ACTION	NO ACTION	DEFERRED	`debit_attribution_funding_source_credit_fkey`

fund_debit

acq.fund_debit(id)

NO ACTION

DEFERRED

debit_attribution_fund_debit_fkey

funding_source_credit

acq.funding_source_credit(id)

NO ACTION

DEFERRED

debit_attribution_funding_source_credit_fkey

Indexes

Index Method Definition

Index	Method	Definition
`debit_attribution_pkey` PK	btree	`CREATE UNIQUE INDEX debit_attribution_pkey ON acq.debit_attribution USING btree (id)`
`acq_attribution_credit_idx`	btree	`CREATE INDEX acq_attribution_credit_idx ON acq.debit_attribution USING btree (funding_source_credit)`
`acq_attribution_debit_idx`	btree	`CREATE INDEX acq_attribution_debit_idx ON acq.debit_attribution USING btree (fund_debit)`

debit_attribution_pkey PK

btree

CREATE UNIQUE INDEX debit_attribution_pkey ON acq.debit_attribution USING btree (id)

acq_attribution_credit_idx

btree

CREATE INDEX acq_attribution_credit_idx ON acq.debit_attribution USING btree (funding_source_credit)

acq_attribution_debit_idx

btree

CREATE INDEX acq_attribution_debit_idx ON acq.debit_attribution USING btree (fund_debit)