SQL reference: 05_analytics

Production API: https://asi-database-node-api.arybit.co.ke

Source: Database/05_analytics.sql

Engine: MySQL legacy. Status: disabled; qualification pending.

Migration ID: 05_analytics. SHA-256 (LF): c3203a952570af315cd9d524992d73d1f86dd8f1b1fe6438bc7e8ce9792d7a9e.

Pending isolated MySQL/MariaDB compatibility, dependency and tenant-isolation validation.

Source overview

========================================================= Arybit Auth - Schema Module (MySQL Version) MODULE: 05_analytics VERSION: 2.1.0 • December 28, 2025 Production-Ready • MySQL / MariaDB Compatible

Analytics: user summary, withdrawal audit, LTV, M-Pesa summary Note: MySQL views are not materialized by default → performance

Declared objects

• update_engagement_score
• vw_ltv_breakdown
• vw_mpesa_summary
• vw_user_summary
• vw_withdrawal_audit

This is a static source reference, not a runtime qualification. Object extraction does not interpret SQL semantics. Review the source and manifest before any schema change.

Connection guide · Migration qualification · SQL catalog