SQL reference: 03_finance

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

Source: Database/03_finance.sql

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

Migration ID: 03_finance. SHA-256 (LF): b153e68c9098f75d4c1bb7f9e3eeef2231f3b899e68db0cad8ad06c5dac54ad6.

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

Source overview

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

Finance: balances, transactions, M-Pesa integration, subscriptions IMPORTANT: Critical financial logic SHOULD be moved to application layer!

Declared objects

• create_idx_mpesa_notif_checkout_id
• create_idx_mpesa_notif_created
• create_idx_subscriptions_user_id
• create_idx_transactions_method
• create_idx_transactions_type
• create_idx_transactions_user_created
• create_idx_transactions_user_id
• create_idx_user_balances_currency
• create_idx_user_balances_user_id
• currency_rates
• ensure_transactions_columns
• get_user_balance
• idx_mpesa_notif_checkout_id
• idx_mpesa_notif_created
• idx_subscriptions_user_id
• idx_transactions_method
• idx_transactions_type
• idx_transactions_user_created
• idx_transactions_user_id
• idx_user_balances_currency
• idx_user_balances_user_id
• mpesa_notifications
• payment_methods
• process_mpesa_webhook
• process_withdrawal
• subscription_plans
• subscriptions
• transactions
• update_user_balance
• user_balances

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