ores.refdata.currency_pair_classification

Table of Contents

Reference data defining valid currency pair liquidity classifications. Values include: major, minor, exotic — independent of either leg's own market_tier (e.g. USD/NOK is major by liquidity even though NOK is individually classified via the currency_group G11/Scandies system, not this classification).

Flags

Columns

code

Unique currency pair classification code.

Examples: 'major', 'minor', 'exotic'.

name

Human-readable name for the classification.

std::string(faker::word::adjective()) + " Classification"

description

Detailed description of the classification.

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_pair_classification_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

Emacs 29.3 (Org mode 9.6.15)