Create
Query
billing.db
—
voucher_pricing
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 3 in voucher_pricing
id
Primary key.
INTEGER
package_name
10K - 7 Hari
TEXT NOT NULL
customer_price
DECIMAL(10,2) NOT NULL
agent_price
DECIMAL(10,2) NOT NULL
commission_amount
DECIMAL(10,2) NOT NULL
duration
INTEGER (default 0
description
Voucher 10K - 7 Hari
TEXT
is_active
BOOLEAN (default 1
created_at
DATETIME (default CURRENT_TIMESTAMP
updated_at
DATETIME (default CURRENT_TIMESTAMP
hotspot_profile
10k
TEXT
duration_type
days
TEXT (default 'hours'
account_type
voucher
TEXT (default 'voucher'
voucher_digit_type
numbers
TEXT (default 'mixed'
voucher_length
INTEGER (default 8
package_id
INTEGER
duration_hours
INTEGER (default 24
price
DECIMAL(10,2)
commission
DECIMAL(10,2)
Update
Cancel