acq.exchange_rate

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.exchange_rate_id_seq'::regclass)
from_currency FK	`text`	No		→ acq.currency_type(code)
to_currency FK	`text`	No		→ acq.currency_type(code)
ratio	`numeric`	No

id PK

integer

nextval('acq.exchange_rate_id_seq'::regclass)

from_currency FK

text

→ acq.currency_type(code)

to_currency FK

text

→ acq.currency_type(code)

ratio

numeric

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`from_currency`	acq.currency_type(code)	NO ACTION	CASCADE	DEFERRED	`exchange_rate_from_currency_fkey`
`to_currency`	acq.currency_type(code)	NO ACTION	CASCADE	DEFERRED	`exchange_rate_to_currency_fkey`

from_currency

acq.currency_type(code)

NO ACTION

CASCADE

DEFERRED

exchange_rate_from_currency_fkey

to_currency

acq.currency_type(code)

NO ACTION

CASCADE

DEFERRED

exchange_rate_to_currency_fkey

Unique Constraints

exchange_rate_from_to_once: (from_currency, to_currency)

Indexes

Index Method Definition

Index	Method	Definition
`exchange_rate_pkey` PK	btree	`CREATE UNIQUE INDEX exchange_rate_pkey ON acq.exchange_rate USING btree (id)`
`exchange_rate_from_to_once` UNIQUE	btree	`CREATE UNIQUE INDEX exchange_rate_from_to_once ON acq.exchange_rate USING btree (from_currency, to_currency)`

exchange_rate_pkey PK

btree

CREATE UNIQUE INDEX exchange_rate_pkey ON acq.exchange_rate USING btree (id)

exchange_rate_from_to_once UNIQUE

btree

CREATE UNIQUE INDEX exchange_rate_from_to_once ON acq.exchange_rate USING btree (from_currency, to_currency)