Create
Query
billing.db
—
customers
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
Drop Column
Column name
Select column
id (INTEGER)
username (TEXT)
name (TEXT)
phone (TEXT)
pppoe_username (TEXT)
email (TEXT)
address (TEXT)
latitude (DECIMAL(10,8))
longitude (DECIMAL(11,8))
package_id (INTEGER)
pppoe_profile (TEXT)
status (TEXT)
join_date (DATETIME)
cable_type (TEXT)
cable_length (INTEGER)
port_number (INTEGER)
cable_status (TEXT)
cable_notes (TEXT)
billing_day (INTEGER)
auto_suspension (BOOLEAN)
odp_id (INTEGER)
static_ip (TEXT)
mac_address (TEXT)
assigned_ip (TEXT)
whatsapp_lid (TEXT)
password (TEXT)
Drop column
Cancel