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