Currency Pairs

Standardized currency pairs build for storing exchange rates following ISO 4217.

Semantic Contract

Definitions

Column	Description
base_currency_id	Reference to Currencies.
quote_currency_id	Reference to Currencies.

Sample & Implementation

A list of Currency Pairs
id	base_currency_id	quote_currency_id
1	1	2
2	1	3
3	1	4
4	3	2
5	3	4
6	2	4

CREATE TABLE IF NOT EXISTS currency_pairs (
    id INTEGER PRIMARY KEY,
    base_currency_id INTEGER NOT NULL,
    quote_currency_id INTEGER NOT NULL,
    FOREIGN KEY (base_currency_id) REFERENCES currencies(id),
    FOREIGN KEY (quote_currency_id) REFERENCES currencies(id)
)

Data Format

Field

Type

Dependencies

Currencies

Currency Pairs

Semantic Contract

Definitions

Sample & Implementation

Data Format

Dependencies

On this page