Create
Query
billing.db
—
technicians
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 technicians
name
TEXT NOT NULL
phone
TEXT NOT NULL
role
TEXT NOT NULL
email
TEXT
notes
TEXT
is_active
INTEGER (default 1)
area_coverage
TEXT
created_at
DATETIME (default CURRENT_TIMESTAMP)
updated_at
DATETIME (default CURRENT_TIMESTAMP)
last_login
DATETIME
whatsapp_group_id
TEXT
join_date
DATETIME
Insert
Cancel