ores.trading.trade_identifier

Table of Contents

Junction entity assigning external identifiers to trades. Each trade can have multiple identifiers of different types. The issuing_party_id references either a party or counterparty.

Flags

Primary key

UUID uniquely identifying this trade identifier record.

Surrogate key for the trade identifier record.

Natural keys

Columns

trade_id

Trade this identifier belongs to.

Soft FK to ores_trading_trades_tbl.

ctx.generate_uuid()

issuing_party_id

Party or counterparty that issued this identifier.

Soft FK to parties or counterparties. Absent if issuer unknown.

std::nullopt

id_value

The identifier value.

e.g., UTI value, internal trade reference.

std::string("ID-") + std::to_string(++counter)

id_type

Type of identifier (e.g. UTI, USI, Internal).

Soft FK to ores_trading_trade_id_types_tbl.

std::string("Internal")

id_scheme

Optional scheme qualifier for the identifier.

e.g., the LEI namespace for UTI schemes.

std::string()

SQL

Flags

C++

Flags

Repository

Domain includes

#include <chrono>
#include <optional>
#include <string>
#include <boost/uuid/uuid.hpp>

Conventions

Table display

column header
id_value ID Value
id_type ID Type
id_scheme Scheme
modified_by Modified By
version Version

Custom repository methods

See also

Emacs 29.1 (Org mode 9.6.6)