acq.funding_source

↑ acq schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.funding_source_id_seq'::regclass)

name

text

No

owner FK

integer

No

→ actor.org_unit(id)

currency_type FK

text

No

→ acq.currency_type(code)

code

text

No

active

boolean

No

true

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

currency_type

acq.currency_type(code)

NO ACTION

CASCADE

No

funding_source_currency_type_fkey

owner

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

funding_source_owner_fkey

Unique Constraints

  • funding_source_code_once_per_owner: (code, owner)

  • funding_source_name_once_per_owner: (name, owner)

Indexes

Index Method Definition

funding_source_pkey PK

btree

CREATE UNIQUE INDEX funding_source_pkey ON acq.funding_source USING btree (id)

funding_source_code_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX funding_source_code_once_per_owner ON acq.funding_source USING btree (code, owner)

funding_source_name_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX funding_source_name_once_per_owner ON acq.funding_source USING btree (name, owner)

Referenced By

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

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

acq.fund_allocation

funding_source

id

fund_allocation_funding_source_fkey

acq.fund_allocation_percent

funding_source

id

fund_allocation_percent_funding_source_fkey

acq.funding_source_credit

funding_source

id

funding_source_credit_funding_source_fkey
Previous
Next