Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id bigint(20)
customer_id bigint(20) Browse foreign values Browse foreign values
subscriber_id bigint(20) Browse foreign values Browse foreign values
plan_id bigint(20)
plan_price_id bigint(20)
service_type enum('broadband', 'hotspot', 'static_ip') utf8mb4_general_ci
auth_protocol enum('pppoe', 'ipoe', 'hotspot') utf8mb4_general_ci
billing_type enum('prepaid', 'postpaid', 'free', 'demo') utf8mb4_general_ci
ip_mode enum('dynamic', 'static', 'pool', 'pool_static') utf8mb4_general_ci
ip_pool_id bigint(20) Browse foreign values Browse foreign values
mac_address varchar(32) utf8mb4_general_ci
circuit_id varchar(100) utf8mb4_general_ci
router_serial varchar(100) utf8mb4_general_ci
installation_amount decimal(12,2)
security_deposit decimal(12,2)
auto_renew tinyint(1)
dont_suspend tinyint(1)
activated_at datetime
expires_at datetime
status enum('pending', 'active', 'expired', 'suspended', 'on_hold', 'disconnected') utf8mb4_general_ci
created_at timestamp
updated_at timestamp
erp_franchisee_id bigint(20)