ores.refdata.party_contact_information
Table of Contents
Contact details for parties organised by purpose (Legal, Operations, Settlement, Billing). Each party can have one contact record per type.
Flags
Primary key
UUID uniquely identifying this contact information record.
Surrogate key for the party contact information record.
Natural keys
party_id
The party this contact information belongs to.
References the parent party 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("123 Test Street")
street_line_2
Second line of the street address.
Additional address line (suite, floor, etc.).
std::string("Suite 100")
city
City name.
City or town of the address.
std::string("London")
state
State or province.
State, province, or region.
std::string("")
country_code
ISO 3166-1 alpha-2 country code.
References the countries table (soft FK).
std::string("GB")
postal_code
Postal or ZIP code.
Postal code for the address.
std::string("EC2V 8AS")
phone
Phone number.
Contact phone number in international format.
std::string("+44 20 7000 0000")
Email address.
Contact email address.
std::string("contact@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 |
|---|---|
| party_id | Party |
| 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.