TNW System Specification

Database Engine Specification

High-performance relational schema engineered for course distribution, multi-tier affiliate tracking, ledger compliance, and user state security across global networks.

20+

core collections

100%

acid compliance

0ms

raw key exposure

Core Domain Entities

Identity and Course Framework

Relational entity mappings connecting authenticated users to learning content, structured package bundles, and granular lesson completion records.

Identity & Access Control

Curriculum & Packages

Learning & Progress Tracking

Enforces isolated roles for members and administrators, pairing core authentication references with encrypted profile states and session tracking.

Links modular courses and structured package mappings, managing video asset manifests, sequence indexes, and publication status.

Tracks individual lesson completion metrics, percentage indicators, and real-time state flags across active enrollment timelines.

— Financial Architecture

Transaction and Affiliate Ledger

Immutable transaction logs and deterministic multi-tier affiliate engines ensure complete auditability from order placement to final commission payout.

Transactions & Payments

Affiliate & Commissions

Settlements & Withdrawals

Unique transaction records with strict payment constraints preventing duplicate billing while maintaining provider status callbacks and timestamp references.

Snapshot-based commission calculation mapping referrers to sales amounts with strict rule versioning and multi-tier payout lifecycle states.

Managed withdrawal request records connecting available balances to external reference numbers following administrative review and security verifications.

• Data Integrity

System Verification Rules

Compliance and Security Controls

Automated KYC submission processing tracks verification steps while credential isolation policies shield primary auth keys from client runtime context.

Platform database constraints guarantee ledger accuracy, field-level encryption for sensitive credentials, and continuous administrative event recording across every system subsystem.

100%

audit log coverage