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
Insert row into installation_jobs
job_number
VARCHAR(50) NOT NULL
customer_name
VARCHAR(255) NOT NULL
customer_phone
VARCHAR(20) NOT NULL
customer_address
TEXT NOT NULL
package_id
INTEGER NOT NULL
installation_date
DATE NOT NULL
installation_time
VARCHAR(20)
assigned_technician_id
INTEGER
status
VARCHAR(50) (default 'scheduled')
priority
VARCHAR(20) (default 'normal')
notes
TEXT
equipment_needed
TEXT
estimated_duration
INTEGER (default 120)
created_by_admin_id
INTEGER
completed_at
DATETIME
completion_notes
TEXT
customer_latitude
DECIMAL(10, 8)
customer_longitude
DECIMAL(11, 8)
created_at
DATETIME (default CURRENT_TIMESTAMP)
updated_at
DATETIME (default CURRENT_TIMESTAMP)
Insert
Cancel