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)
service_id bigint(20) Browse foreign values Browse foreign values
customer_id bigint(20) Browse foreign values Browse foreign values
franchisee_profile_id bigint(20)
plan_price_id bigint(20)
invoice_id bigint(20) Browse foreign values Browse foreign values
business_model enum('deposit', 'revenue_share') utf8mb4_general_ci
sharing_price decimal(12,2)
selling_price decimal(12,2)
isp_share_percent decimal(5,2)
franchisee_share_percent decimal(5,2)
isp_share_amount decimal(12,2)
franchisee_share_amount decimal(12,2)
addon_amount decimal(12,2)
tax_percent decimal(5,2)
tax_amount decimal(12,2)
customer_total decimal(12,2)
wallet_deduction decimal(12,2)
wallet_transaction_id bigint(20) Browse foreign values Browse foreign values
previous_expiry datetime
new_expiry datetime
status enum('completed', 'reversed') utf8mb4_general_ci
created_by bigint(20)
created_at timestamp