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)
visit_uuid char(36) ascii_bin
tracking_session_id bigint(20)
employee_id int(10)
branch_id int(10)
finance_year_id int(10)
visit_type varchar(20) utf8mb4_unicode_ci
customer_ledger_id bigint(20)
service_ticket_id bigint(20)
planned_crm_visit_id int(11)
customer_location_id bigint(20)
checkin_at datetime(3)
checkout_at datetime(3)
checkin_latitude decimal(10,7)
checkin_longitude decimal(10,7)
checkin_accuracy decimal(10,2)
checkout_latitude decimal(10,7)
checkout_longitude decimal(10,7)
checkout_accuracy decimal(10,2)
customer_latitude decimal(10,7)
customer_longitude decimal(10,7)
checkin_distance_meters decimal(12,2)
checkout_distance_meters decimal(12,2)
geofence_radius_meters int(10)
geofence_status varchar(40) utf8mb4_unicode_ci
status varchar(20) utf8mb4_unicode_ci
active_session_id bigint(20)
outcome varchar(40) utf8mb4_unicode_ci
remarks text utf8mb4_unicode_ci
row_version int(10)
created_at datetime(3)
updated_at datetime(3)