ores.refdata.counterparty_contact_information
Table of Contents
Contact details for counterparties organised by purpose (Legal, Operations, Settlement, Billing). Each counterparty can have one contact record per type.
Flags
Primary key
UUID uniquely identifying this contact information record.
Surrogate key for the counterparty contact information record.
Natural keys
counterparty_id
The counterparty this contact information belongs to.
References the parent counterparty record.
uuid_gen()
contact_type
The type or purpose of this contact.
References the contact_type lookup table (e.g. Legal, Operations).
std::string("Legal")
Columns
street_line_1
First line of the street address.
Primary address line.
std::string("456 Test Avenue")
street_line_2
Second line of the street address.
Additional address line (suite, floor, etc.).
std::string("Floor 10")
city
City name.
City or town of the address.
std::string("New York")
state
State or province.
State, province, or region.
std::string("NY")
country_code
ISO 3166-1 alpha-2 country code.
References the countries table (soft FK).
std::string("US")
postal_code
Postal or ZIP code.
Postal code for the address.
std::string("10001")
phone
Phone number.
Contact phone number in international format.
std::string("+1 212 555 0100")
Email address.
Contact email address.
std::string("info@example.com")
web_page
Web page URL.
Contact web page address.
std::string("https://example.com")
SQL
Flags
C++
Flags
Repository
Domain includes
#include <chrono> #include <string> #include <boost/uuid/uuid.hpp>
Entity includes
#include <string> #include "sqlgen/Timestamp.hpp" #include "sqlgen/PrimaryKey.hpp"
Conventions
Table display
| column | header |
|---|---|
| counterparty_id | Counterparty |
| contact_type | Type |
| city | City |
| country_code | Country |
| phone | Phone |
| modified_by | Modified By |
| version | Version |
Custom repository methods
See also
- ores.refdata — component group overview.