Development Tools
Advanced tools for monitoring system performance and integration testing.
Live System Status
System API
Checking connection...
Solver Engine
Solver is currently idle.
Diagnostic Tools
Database Tables
16 of 16 tables
| Table | Category | Used By | Used For |
|---|---|---|---|
| Currencies | Configuration | currencies router, solver, seed_data | Currency codes, spot rates vs base, and risk-free rates. Referenced by accounts, margins, and RCF facilities. |
| Banks | Configuration | banks router, accounts router, deals router, solver, seed_data | Bank entities. Parent for accounts, margins, overdraft facilities, and cash pools; also the counterparties of deals. |
| Accounts | Configuration | accounts router, solver, multiple routers, seed_data | Bank accounts with currency and borrowing/deposit margins. Core entity used by the solver to model cash positions. |
| Bank_Margins | Configuration | banks router, solver, seed_data | Per-bank per-currency borrowing and deposit margins. Loaded by the solver for interest cost calculations. |
| Overdraft_Facilities | Configuration | overdraft_facilities router, solver, seed_data | Overdraft credit lines per bank and currency with facility limits. Used by the solver for borrowing capacity. |
| Cash_Pools | Configuration | cash_pools router, solver, seed_data | Notional cash pool structures grouping accounts under a bank. Can reference an overdraft facility for pooled borrowing. |
| Routing_Rules | Configuration | routing_rules router, solver, seed_data | Allowed transfer edges between accounts. The solver only generates transactions along these permitted routes. |
| RCF_Facilities | Configuration | rcf_facilities router, deals router, solver, seed_data | Revolving credit facilities with limits, interest margins, and commitment fees. Solver models draw-downs and repayments. |
| Global_Settings | Configuration | settings router, solver, optimize router | Solver parameters (horizon, costs, spreads, penalties, timeout, gap, concurrency). Seeded with defaults on startup. |
| Optimization_Runs | Operations | runs router, optimize router, jobs router | Completed optimization results including JSON output, settings snapshot, gap, and runtime. |
| Deals | Deals | deals router, payment_schedule router | Deal headers (FX, FX swap, money market) with status and key terms. |
| Deal_Legs | Deals | deals router, payment_schedule router | Currency legs of each deal. Cashflows are projected from these on every read. |
| Deal_Amendments | Deals | deals router | Amendment history per deal with field-level diffs and full snapshots. |
| Deal_Views | Deals | saved_views router, deals router | Saved filter views for the Deals list. |
| Payment_Schedule_Views | Deals | saved_views router | Saved filter views for the Payment Schedule page. |
| Business_Audit_Log | Audit | audit.py, all entity routers, audit_logs router | Audit trail of all changes to business entities, settings, solver runs, and database backups/restores. |