ores.dq.badge_mapping

Left
Right
Columns
- badge_code
SQL
- Flags
Repository
C++
See also

Universal mapping table that associates any (code_domain, entity_code) pair with a badge definition. This is the single join point between domain values and their visual presentation.

Examples:

('party_status', 'ACTIVE') -> 'active'
('party_status', 'FROZEN') -> 'frozen'
('fsm_state', 'DRAFT') -> 'fsm_draft'
('login_status', 'Online') -> 'login_online'
('dq_nature', 'Actual') -> 'dq_actual'

Populated via seed scripts; no management UI needed.

Left

Code of the domain this mapping belongs to.

References code_domain.code (soft FK). Examples: 'party_status', 'fsm_state'.

std::string(faker::word::noun()) + "_status"

Right

The domain value being mapped to a badge.

Examples: 'ACTIVE', 'DRAFT', 'Online', 'Actual'.

std::string(faker::word::adjective()).substr(0, 1)

Columns

badge_code

The badge definition to use for this mapping.

References badge_definition.code (soft FK). Examples: 'active', 'fsm_draft'.

std::string(faker::word::adjective())

SQL

Flags

Repository

C++

Domain includes

#include <chrono>
#include <string>

Entity includes

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

Conventions

Table display

column	header
code_domain_code	Code Domain
entity_code	Entity Code
badge_code	Badge
modified_by	Modified By
version	Version