| id |
bigint(20)
|
|
|
|
| event_uuid |
char(36)
|
ascii_bin
|
|
|
| payload_hash |
char(64)
|
ascii_bin
|
|
|
| tracking_session_id |
bigint(20)
|
|
|
Browse foreign values
|
| sequence_no |
bigint(20)
|
|
|
|
| employee_id |
int(10)
|
|
|
|
| user_id |
smallint(5)
|
|
|
|
| device_id |
bigint(20)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| finance_year_id |
int(10)
|
|
|
|
| latitude |
decimal(10,7)
|
|
|
|
| longitude |
decimal(10,7)
|
|
|
|
| accuracy |
decimal(10,2)
|
|
|
|
| altitude |
decimal(12,2)
|
|
|
|
| speed |
decimal(10,3)
|
|
|
|
| heading |
decimal(6,2)
|
|
|
|
| recorded_at_device |
datetime(3)
|
|
|
|
| received_at_server |
datetime(3)
|
|
|
|
| monotonic_elapsed_ms |
bigint(20)
|
|
|
|
| is_mocked |
tinyint(1)
|
|
|
|
| source |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| activity_context |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| quality_flags |
int(10)
|
|
|
|
| accepted_for_metrics |
tinyint(1)
|
|
|
|
| created_at |
datetime(3)
|
|
|
|