Create
Query
billing.db
—
invoices
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 4 from invoices
id
4
customer_id
1
package_id
1
invoice_number
INV-202603-0066
amount
110000
due_date
2026-04-18
status
paid
payment_date
2026-03-19T17:31:32.607Z
payment_method
online
payment_gateway
midtrans
payment_token
21b9d02e-9c2d-4a5c-ade0-4e6f5bb298c0
payment_url
https://app.sandbox.midtrans.com/snap/v4/redirecti
https://app.sandbox.midtrans.com/snap/v4/redirection/21b9d02e-9c2d-4a5c-ade0-4e6f5bb298c0
...
payment_status
pending
notes
created_at
2026-03-19 17:27:27
description
NULL
invoice_type
monthly
package_name
NULL
base_amount
100000
tax_rate
10
Delete
Cancel