Changes

| app_display_version app_version || varchar || Firefox version (e.g. 50.0a2)- corresponds to the MOZ_APP_VERSION configure value

| app_name app_display_version || varchar || Platform?The application version as shown in the about dialog. Almost always identical to app_version. Corresponds to the MOZ_APP_VERSION_DISPLAY configure value.

| app_version app_name || varchar || What's Will always be the difference with app_display_version?string "Firefox" in desktop submitted pings.

| deviceid || varchar || Browser profile id? Not currently capturedHashed FxA device ID.

| when || bigint || Unix timestamp of when sync occurred. Make sure to put in "quotes" since when is a reserved SQL word. Note that because this is taken from the client's clock, the time may be wildly inaccurate.

| took || bigint || Time Number of milli-seconds it took to Sync?.

| failurereason || row(name varchar, value varchar) || Sync failure reason, or null if no failure.

| status || row(sync varchar, service varchar) || ??The status of sync after completion, or null is both statuses record success.

| why || varchar || Always Currently always null because XYZ and is meant for ABC, but eventually should be the reason the sync was performed (eg, timer, button press, score update, etc)

| engines || array(row(name varchar, took bigint, status varchar, failureReason row(name varchar, value varcharengine_record), incoming row(applied bigint, failed bigint, newFailed bigint, reconciled bigint), outgoing || A record of the engines that synced. Each element of the array(row(sent bigint, failed bigint)))) |is in the format of an [[#Engine Record| ??engine record]].

| submission_date_s3 || varchar || ??The date this ping was submitted to the telemetry servers. Because a ping will typically be sent for a previous session immediately after a browser restart, this submission date may be later than the date recorded in the ping. Note also that this is a timestamp supplied by the server so is likely to be more reliable than the dates recorded in the ping itself.|} ==== Engine Record ==== An engine record is defined as: {| class="wikitable"|-! Field Name!! Data Type !! Description|-| name || varchar || The name of the engine.|-| took || bigint || How many milliseconds this engine took to sync.|-| status || varchar || The status of this engine after sync completed, or null is the status reflects success.|-| failureReason || row(name varchar, value varchar) || Details of any errors recorded during the sync of this engine, or null on success.|-| incoming || row(applied bigint, failed bigint, newFailed bigint, reconciled bigint) || Details of how many incoming records were applied, failed, failed for the first time in this sync, and reconciled.|-| outgoing || array(row(sent bigint, failed bigint))) || For each batch of records uploaded as part of a Sync, how many records were sent in that batch and how many failed.