Create
Query
billing.db
—
installation_jobs
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
Add Index
Indexed Columns
id (INTEGER)
job_number (VARCHAR(50))
customer_name (VARCHAR(255))
customer_phone (VARCHAR(20))
customer_address (TEXT)
package_id (INTEGER)
installation_date (DATE)
installation_time (VARCHAR(20))
assigned_technician_id (INTEGER)
status (VARCHAR(50))
priority (VARCHAR(20))
notes (TEXT)
equipment_needed (TEXT)
estimated_duration (INTEGER)
created_by_admin_id (INTEGER)
completed_at (DATETIME)
completion_notes (TEXT)
customer_latitude (DECIMAL(10, 8))
customer_longitude (DECIMAL(11, 8))
created_at (DATETIME)
updated_at (DATETIME)
Unique?
No
Yes
Add index
Cancel