acq.funding_source_credit

↑ acq schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.funding_source_credit_id_seq'::regclass)

funding_source FK

integer

No

→ acq.funding_source(id)

amount

numeric

No

note

text

Yes

deadline_date

timestamp with time zone

Yes

effective_date

timestamp with time zone

No

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

funding_source

acq.funding_source(id)

NO ACTION

NO ACTION

DEFERRED

funding_source_credit_funding_source_fkey

Indexes

Index Method Definition

funding_source_credit_pkey PK

btree

CREATE UNIQUE INDEX funding_source_credit_pkey ON acq.funding_source_credit USING btree (id)

Referenced By

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

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

acq.debit_attribution

funding_source_credit

id

debit_attribution_funding_source_credit_fkey

acq.fund_transfer

funding_source_credit

id

fund_transfer_funding_source_credit_fkey
Previous
Next