ores.refdata.currency_country

Table of Contents

Many-to-many junction between currency and country: a currency can be issued by more than one country (e.g. EUR spans DE, FR, IT, ES, …). Independent reference data in its own right, not a prerequisite for the calendar entity, which carries its own country_code rather than deriving a currency's calendars transitively through this junction.

Left

ISO 4217 alpha-3 code of the currency.

References ores_refdata_currencies_tbl.iso_code (soft FK). 

std::string("EUR")

Right

ISO 3166-1 alpha-2 code of the country that issues this currency.

References ores_refdata_countries_tbl.alpha2_code (soft FK). 

std::string("DE")

Columns

SQL

Flags

Repository

C++

Flags

Domain includes

#include <chrono>
#include <string>

Entity includes

#include <string>
#include "sqlgen/Timestamp.hpp"
#include "sqlgen/PrimaryKey.hpp"

Conventions

Table display

column header
currency_iso_code Currency
country_alpha2_code Country
modified_by Modified By
version Version

See also

Emacs 29.3 (Org mode 9.6.15)