data_dictionary.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

--
-- Data for Name: data_dictionary; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY data_dictionary (raw_field, transforms, product) FROM stdin;
test	{}	\N
AdapterDeviceID	{"data name": "AdapterDeviceID", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
AdapterVendorID	{"data name": "AdapterVendorID", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Add-ons	{"data name": "Add-ons", "mdsw pipe dump": "", "database": "", "pj transform": "addons", "ted's mdsw json": "extensions.extension_key, extensions.extension_id, extensions.extension_version ", "1.X processed json": "", "processor transform": "addons", "collector:raw json": "", "processed json 2012": "list of lists "}	\N
Android_Board	{"data name": "Android_Board", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Android_Brand	{"data name": "Android_Brand", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Android_CPU_ABI2	{"data name": "Android_CPU_ABI2", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Android_Device	{"data name": "Android_Device", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Android_Display	{"data name": "Android_Display", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Android_Fingerprint	{"data name": "Android_Fingerprint", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Android_Manufacturer	{"data name": "Android_Manufacturer", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Android_Model	{"data name": "Android_Model", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Android_Version	{"data name": "Android_Version", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
AvailablePhysicalMemory	{"data name": "AvailablePhysicalMemory", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
AvailableVirtualMemory	{"data name": "AvailableVirtualMemory", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
AvalablePageFile	{"data name": "AvalablePageFile", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
BuildID	{"data name": "BuildID", "mdsw pipe dump": "", "database": "", "pj transform": "build", "ted's mdsw json": "reports.build (16)", "1.X processed json": "", "processor transform": "build", "collector:raw json": "", "processed json 2012": ""}	\N
buildid	{"data name": "buildid", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "inadvertent extra value from breakpad, not used"}	\N
Comments	{"data name": "Comments", "mdsw pipe dump": "", "database": "truncated to 500 characters; None if missing", "pj transform": "user_comments", "ted's mdsw json": "reports.user_comments (500)", "1.X processed json": "truncated to 500 characters; None if missing", "processor transform": "user_comments", "collector:raw json": "", "processed json 2012": ""}	\N
CrashTime	{"data name": "CrashTime", "mdsw pipe dump": "", "database": "truncated to 10 characters, converted to integer; if missing, reverts to the value of 'timestamp'.  Converted to timestamp with time zone in the database\\n", "pj transform": "client_crash_date", "ted's mdsw json": "reports.client_crash_date", "1.X processed json": "truncated to 10 characters, converted to integer; if missing, reverts to the value of 'timestamp'.  Converted back to string in almost ISO 8601 for json.\\n", "processor transform": "client_crash_date", "collector:raw json": "", "processed json 2012": "UTZ applied by processor"}	\N
submitted_timestamp	{"data name": "submitted_timestamp", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "reports.date_processed", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Distributor	{"data name": "Distributor", "mdsw pipe dump": "", "database": "truncated to 20 characters; None if missing", "pj transform": "distributor", "ted's mdsw json": "reports.distributor (20)", "1.X processed json": "truncated to 20 characters; None if missing", "processor transform": "distributor", "collector:raw json": "", "processed json 2012": ""}	\N
Distributor_version	{"data name": "Distributor_version", "mdsw pipe dump": "", "database": "truncated to 20 characters; None if missing", "pj transform": "distributor_version", "ted's mdsw json": "reports.distributor_version (20)", "1.X processed json": "truncated to 20 characters; None if missing", "processor transform": "distributor_version", "collector:raw json": "", "processed json 2012": ""}	\N
Email	{"data name": "Email", "mdsw pipe dump": "", "database": "truncated to 100 characters; None if missing", "pj transform": "", "ted's mdsw json": "reports.email (100)", "1.X processed json": "truncated to 100 characters; None if missing", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
EMCheckCompatibility	{"data name": "EMCheckCompatibility", "mdsw pipe dump": "", "database": "converted to lower case, then to boolean True if 'true' and False for any other value", "pj transform": "addons_checked", "ted's mdsw json": "reports.addons_checked", "1.X processed json": "converted to lower case, then to boolean True if 'true' and False for any other value", "processor transform": "addons_checked", "collector:raw json": "", "processed json 2012": ""}	\N
FramePoisonBase	{"data name": "FramePoisonBase", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
FramePoisonSize	{"data name": "FramePoisonSize", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Hang	{"data name": "Hang", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "not currently enabled in breakpad"}	\N
HangID	{"data name": "HangID", "mdsw pipe dump": "", "database": "no conversion; None if missng", "pj transform": "hangid", "ted's mdsw json": "reports.hangid", "1.X processed json": "no conversion; None if missng", "processor transform": "hangid", "collector:raw json": "", "processed json 2012": ""}	\N
id	{"data name": "id", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "name collision: the raw json 'id'"}	\N
InstallTime	{"data name": "InstallTime", "mdsw pipe dump": "", "database": "converted to int; reverts to 'startuptime' if missing", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "converted to int; reverts to 'startuptime' if missing", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
JavaStackTrace	{"data name": "JavaStackTrace", "mdsw pipe dump": "", "database": "", "pj transform": "java_stack_trace", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
legacy_processing	{"data name": "legacy_processing", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "added by collector"}	\N
Min_ARM_Version	{"data name": "Min_ARM_Version", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Notes	{"data name": "Notes", "mdsw pipe dump": "", "database": "truncated to 1000; None if missing", "pj transform": "app_notes", "ted's mdsw json": "reports.app_notes (1000)", "1.X processed json": "truncated to 1000; None if missing", "processor transform": "app_notes", "collector:raw json": "", "processed json 2012": ""}	\N
PluginFilename	{"data name": "PluginFilename", "mdsw pipe dump": "", "database": "no conversion; empty string if missing", "pj transform": "pluginFilename", "ted's mdsw json": "plugins.filename", "1.X processed json": "only present if 'plugin' crash type", "processor transform": "pluginFilename", "collector:raw json": "", "processed json 2012": ""}	\N
PluginName	{"data name": "PluginName", "mdsw pipe dump": "", "database": "no conversion; empty string if missing", "pj transform": "pluginName", "ted's mdsw json": "plugins.name", "1.X processed json": "only present if 'plugin' crash type", "processor transform": "pluginName", "collector:raw json": "", "processed json 2012": ""}	\N
PluginVersion	{"data name": "PluginVersion", "mdsw pipe dump": "", "database": "no conversion; empty string if missing", "pj transform": "pluginVersion", "ted's mdsw json": "plugins_reports.pluginVersion", "1.X processed json": "only present if 'plugin' crash type", "processor transform": "pluginVersion", "collector:raw json": "", "processed json 2012": ""}	\N
ProcessType	{"data name": "ProcessType", "mdsw pipe dump": "", "database": "truncated to 10; None if missing", "pj transform": "process_type", "ted's mdsw json": "reports.process_type", "1.X processed json": "truncated to 10; None if missing", "processor transform": "process_type", "collector:raw json": "", "processed json 2012": ""}	\N
ProductName	{"data name": "ProductName", "mdsw pipe dump": "", "database": "", "pj transform": "product", "ted's mdsw json": "reports.product (30)", "1.X processed json": "", "processor transform": "product", "collector:raw json": "", "processed json 2012": ""}	\N
ReleaseChannel	{"data name": "ReleaseChannel", "mdsw pipe dump": "", "database": "", "pj transform": "release_channel", "ted's mdsw json": "reports.release_channel", "1.X processed json": "", "processor transform": "release_channel", "collector:raw json": "", "processed json 2012": ""}	\N
SecondsSinceLastCrash	{"data name": "SecondsSinceLastCrash", "mdsw pipe dump": "", "database": "converted to int", "pj transform": "last_crash", "ted's mdsw json": "reports.last_crash", "1.X processed json": "converted to int", "processor transform": "last_crash", "collector:raw json": "", "processed json 2012": ""}	\N
StartupTime	{"data name": "StartupTime", "mdsw pipe dump": "", "database": "converted to int; reverts to 'CrashTime' if missing", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "converted to int; reverts to 'CrashTime' if missing", "processor transform": "", "collector:raw json": "", "processed json 2012": "decimal unix timestamp of 10 or fewer digits"}	\N
SystemMemoryUsePercentage	{"data name": "SystemMemoryUsePercentage", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Theme	{"data name": "Theme", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Throttleable	{"data name": "Throttleable", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
timestamp	{"data name": "timestamp", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
TotalVirtualMemory	{"data name": "TotalVirtualMemory", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
URL	{"data name": "URL", "mdsw pipe dump": "", "database": "truncated to 255; None if missing", "pj transform": "", "ted's mdsw json": "reports.url (255)", "1.X processed json": "truncated to 255; None if missing", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
UserID	{"data name": "UserID", "mdsw pipe dump": "", "database": "forced to empty string", "pj transform": "", "ted's mdsw json": "reports.user_id", "1.X processed json": "forced to empty string", "processor transform": "", "collector:raw json": "", "processed json 2012": "processor always leaves this blank"}	\N
Vendor	{"data name": "Vendor", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""}	\N
Version	{"data name": "Version", "mdsw pipe dump": "", "database": "truncated to 16; 'esr' appended if ReleaseChannel is 'ESR'; None if missing", "pj transform": "version", "ted's mdsw json": "reports.version (16)", "1.X processed json": "truncated to 16; 'esr' appended if ReleaseChannel is 'ESR'; None if missing", "processor transform": "version", "collector:raw json": "", "processed json 2012": ""}	\N
version	{"data name": "version", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "inadvertent extra value from breakpad, not used"}	\N
Winsock_LSP	{"data name": "Winsock_LSP", "mdsw pipe dump": "", "database": "", "pj transform": "Winsock_LSP", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "Winsock_LSP", "collector:raw json": "", "processed json 2012": ""}	\N
\.


--
-- PostgreSQL database dump complete
--