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.
1. Flags
2. Left
ISO 4217 alpha-3 code of the currency.
References ores_refdata_currencies_tbl.iso_code (soft FK).
std::string("EUR")
3. 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")
4. Columns
5. SQL
5.1. Flags
6. Repository
7. C++
7.1. Flags
7.2. Domain includes
#include <chrono> #include <string>
7.3. Entity includes
#include <string> #include "sqlgen/Timestamp.hpp" #include "sqlgen/PrimaryKey.hpp"
7.4. Conventions
7.5. Table display
| column | header |
|---|---|
| currency_iso_code | Currency |
| country_alpha2_code | Country |
| modified_by | Modified By |
| version | Version |
8. See also
- ores.refdata — component group overview.
- Model calendars as proper ORE Studio reference data — parent story.