Create
Query
billing.db
—
monthly_summary
admin_notifications
agent_balance_requests
agent_balances
agent_monthly_payments
agent_notifications
agent_payments
agent_transactions
agent_voucher_sales
agents
app_settings
cable_maintenance_logs
cable_routes
collector_assignments
collector_payments
collectors
customers
expenses
installation_job_equipment
installation_job_stat...
installation_jobs
invoices
migrations
monthly_summary
network_segments
odp_connections
odps
onu_devices
packages
payment_gateway_trans...
payments
sqlite_sequence
technician_activities
technician_sessions
technicians
telegram_sessions
trouble_reports
voucher_delivery_logs
voucher_generation_se...
voucher_online_settings
voucher_pricing
voucher_purchases
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Delete row 1 from monthly_summary
id
1
year
2025
month
10
total_customers
1
active_customers
1
monthly_invoices
0
voucher_invoices
0
paid_monthly_invoices
0
paid_voucher_invoices
0
unpaid_monthly_invoices
0
unpaid_voucher_invoices
0
monthly_revenue
0
voucher_revenue
0
monthly_unpaid
0
voucher_unpaid
0
total_revenue
0
total_unpaid
0
notes
Initial summary generated on 2025-10-23
created_at
2025-10-23 02:43:52
updated_at
2025-10-23 02:43:52
Delete
Cancel