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)
device_id bigint(20)
connector_instance_id bigint(20)
ingestion_source enum('CONNECTOR', 'DEVICE_PUSH') utf8mb4_unicode_ci
source_protocol varchar(50) ascii_bin
employee_mapping_id bigint(20)
employee_id int(10)
external_event_id varchar(128) ascii_bin
event_fingerprint char(64) ascii_bin
event_type varchar(30) utf8mb4_unicode_ci
verify_mode varchar(30) utf8mb4_unicode_ci
direction enum('IN', 'OUT', 'UNKNOWN') utf8mb4_unicode_ci
device_person_id varchar(80) ascii_bin
occurred_at_utc datetime
device_local_time datetime
device_timezone varchar(64) ascii_bin
raw_payload_json longtext utf8mb4_unicode_ci
processing_status enum('UNPROCESSED', 'UNMAPPED', 'PROCESSED', 'REJECTED') utf8mb4_unicode_ci
received_at_utc datetime
processed_at_utc datetime
processing_error varchar(500) utf8mb4_unicode_ci
created_at datetime