Confirmed users
98
edits
(First cut at describing the sync_events_v1 table.) |
(Filled out more fields.) |
||
Line 136: | Line 136: | ||
|- | |- | ||
| event_map_values || map(varchar, varchar) || Additional data specific to this event. | | event_map_values || map(varchar, varchar) || Additional data specific to this event. | ||
|- | |||
| event_flow_id || varchar || An ID used to identify a pair of commands which span multiple devices (todo: explain this!) | |||
|- | |- | ||
| event_device_id || varchar || If this event is being targeted at a different sync device, this is the ID of the target. | | event_device_id || varchar || If this event is being targeted at a different sync device, this is the ID of the target. | ||
|- | |- | ||
| | | event_device_version || varchar || If this event is being targeted at a different sync device, this is the Firefox version it is running. | ||
|- | |- | ||
| event_device_os || varchar || | | event_device_os || varchar || If this event is being targeted at a different sync device, this is the OS it is running | ||
|- | |- | ||
| submission_date_s3 || varchar || | | submission_date_s3 || varchar || The date this ping was submitted. | ||
|} | |} | ||
=== Query Examples === | === Query Examples === |