ores.refdata.counterparty_contact_information

uuid_gen()

// no_generator_suffix: validated enum, a "-<idx>" suffix would be invalid.
// Rotate so a batch of several contact rows for one counterparty gets
// distinct types (max one contact row per type per counterparty).
[idx]{
    static constexpr const char* types[] = {
        "Legal", "Operations", "Settlement", "Billing"};
    return std::string(types[idx % 4]);
}()

std::string("456 Test Avenue")

std::string("Floor 10")

std::string("New York")

std::string("NY")

// Left blank: validated against the tenant-scoped countries table, which
// isolated test tenants don't seed; empty skips validation.
std::string("")

-- Paste block: doesn't fit soft_fk_validations (joins on id, not
-- an alpha-2 code column) or the Validations table
-- (ores_refdata_validate_country_fn only checks non-null/empty,
-- not existence).
-- Validate country_code (nullable, inline check against countries table)
if NEW.country_code is not null and NEW.country_code != '' then
    if not exists (
        select 1 from ores_refdata_countries_tbl
        where tenant_id = NEW.tenant_id
          and alpha2_code = NEW.country_code
          and valid_to = ores_utility_infinity_timestamp_fn()
    ) then
        raise exception 'Invalid country_code: %. Must be a valid ISO 3166-1 alpha-2 code.',
            NEW.country_code
            using errcode = '23503';
    end if;
end if;

std::string("10001")

std::string("+1 212 555 0100")

std::string("info@example.com")

std::string("https://example.com")

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

#include <string>
#include "sqlgen/Timestamp.hpp"
#include "sqlgen/PrimaryKey.hpp"