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
Update row 1 in customers
id
Primary key.
INTEGER
username
fleming_190326
TEXT NOT NULL
name
Fleming
TEXT NOT NULL
phone
082156504558
TEXT NOT NULL
pppoe_username
pppoe_4558_6c
TEXT
email
flemingsyaifullah@gmail.com
TEXT
address
TEXT
latitude
DECIMAL(10,8)
longitude
DECIMAL(11,8)
package_id
INTEGER
pppoe_profile
default
TEXT
status
active
TEXT (default 'active'
join_date
DATETIME (default CURRENT_TIMESTAMP
cable_type
NULL
TEXT
cable_length
INTEGER
port_number
INTEGER
cable_status
connected
TEXT (default 'connected'
cable_notes
NULL
TEXT
billing_day
INTEGER (default 15
auto_suspension
BOOLEAN (default 1
odp_id
INTEGER
static_ip
NULL
TEXT
mac_address
NULL
TEXT
assigned_ip
NULL
TEXT
whatsapp_lid
NULL
TEXT
password
NULL
TEXT
Update
Cancel