ores.refdata.currency_group
Table of Contents
Reference data defining desk-style currency groupings. Unlike
currency.market_tier (single-valued primary liquidity tier), a
currency can belong to any number of groups simultaneously via
ores.refdata.currency_currency_group_junction (e.g. NOK: G11 and
SCANDIES and COMMODITY). Seeded with G11, SCANDIES, ANTIPODEANS,
COMMODITY, ASIANS, LATAMS — extensible by inserting a row, no schema
change needed for a new group.
Flags
Columns
code
Unique currency group code.
Examples: 'G11', 'SCANDIES', 'ANTIPODEANS', 'COMMODITY', 'ASIANS', 'LATAMS'.
name
Human-readable name for the currency group.
std::string(faker::word::adjective()) + " Group"
description
Detailed description of the currency group.
std::string(faker::lorem::sentence())
display_order
Order for UI display purposes.
faker::number::integer(1, 100)
SQL
Flags
Extra drops
drop function if exists ores_refdata_validate_currency_group_fn;
Validation function
Insert trigger
Validations
| column | validation_function |
|---|---|
| change_reason_code | ores_dq_validate_change_reason_fn |
C++
Flags
Repository
Domain includes
#include <chrono> #include <string>
Entity includes
#include <string> #include "sqlgen/Timestamp.hpp"
Conventions
Table display
| column | header |
|---|---|
| code | Code |
| name | Name |
| description | Description |
| display_order | Order |
| modified_by | Modified By |
| version | Version |
Qt
Columns (Qt model)
| enum_name | field | header | type | width |
|---|---|---|---|---|
| Code | code | Code | string | 150 |
| Name | name | Name | string | 200 |
| Description | description | Description | string | 300 |
| DisplayOrder | display_order | Order | int | 80 |
| Version | version | Version | int | 80 |
| ModifiedBy | modified_by | Modified By | string | 120 |
| RecordedAt | recorded_at | Recorded At | timestamp | 150 |
Custom repository methods
See also
- ores.refdata — component group overview.
- Currency pair support in reference data — parent story.