acq.currency_type

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
code PK	`text`	No
label	`text`	Yes

code PK

text

label

text

Yes

(code)

Index Method Definition

Index	Method	Definition
`currency_type_pkey` PK	btree	`CREATE UNIQUE INDEX currency_type_pkey ON acq.currency_type USING btree (code)`

currency_type_pkey PK

btree

CREATE UNIQUE INDEX currency_type_pkey ON acq.currency_type USING btree (code)

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.exchange_rate	`from_currency`	`code`	`exchange_rate_from_currency_fkey`
acq.exchange_rate	`to_currency`	`code`	`exchange_rate_to_currency_fkey`
acq.fund	`currency_type`	`code`	`fund_currency_type_fkey`
acq.fund_debit	`origin_currency_type`	`code`	`fund_debit_origin_currency_type_fkey`
acq.funding_source	`currency_type`	`code`	`funding_source_currency_type_fkey`
acq.provider	`currency_type`	`code`	`provider_currency_type_fkey`