· 4 years ago · Sep 10, 2021, 05:42 PM
1CREATE TABLE IF NOT EXISTS imerco_desktop_frontpage_20210910_1305 (
2 `captchaResult` VARCHAR(18) CHARACTER SET utf8,
3 `kind` VARCHAR(22) CHARACTER SET utf8,
4 `id` VARCHAR(22) CHARACTER SET utf8,
5 `loadingExperience_id` VARCHAR(22) CHARACTER SET utf8,
6 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_percentile` INT,
7 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_distributions_min` INT,
8 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_distributions_max` INT,
9 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_distributions_proportion` NUMERIC(19, 18),
10 `loadingExperience_metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_category` VARCHAR(4) CHARACTER SET utf8,
11 `loadingExperience_metrics_FIRST_CONTENTFUL_PAINT_MS_percentile` INT,
12 `metrics_FIRST_CONTENTFUL_PAINT_MS_distributions_min` INT,
13 `metrics_FIRST_CONTENTFUL_PAINT_MS_distributions_max` INT,
14 `metrics_FIRST_CONTENTFUL_PAINT_MS_distributions_proportion` NUMERIC(19, 18),
15 `loadingExperience_metrics_FIRST_CONTENTFUL_PAINT_MS_category` VARCHAR(4) CHARACTER SET utf8,
16 `loadingExperience_metrics_FIRST_INPUT_DELAY_MS_percentile` INT,
17 `loadingExperience_metrics_FIRST_INPUT_DELAY_MS_distributions_min` INT,
18 `loadingExperience_metrics_FIRST_INPUT_DELAY_MS_distributions_max` INT,
19 `metrics_FIRST_INPUT_DELAY_MS_distributions_proportion` NUMERIC(19, 18),
20 `loadingExperience_metrics_FIRST_INPUT_DELAY_MS_category` VARCHAR(4) CHARACTER SET utf8,
21 `loadingExperience_metrics_LARGEST_CONTENTFUL_PAINT_MS_percentile` INT,
22 `metrics_LARGEST_CONTENTFUL_PAINT_MS_distributions_min` INT,
23 `metrics_LARGEST_CONTENTFUL_PAINT_MS_distributions_max` INT,
24 `metrics_LARGEST_CONTENTFUL_PAINT_MS_distributions_proportion` NUMERIC(18, 17),
25 `loadingExperience_metrics_LARGEST_CONTENTFUL_PAINT_MS_category` VARCHAR(7) CHARACTER SET utf8,
26 `loadingExperience_overall_category` VARCHAR(7) CHARACTER SET utf8,
27 `loadingExperience_initial_url` VARCHAR(22) CHARACTER SET utf8,
28 `originLoadingExperience_id` VARCHAR(21) CHARACTER SET utf8,
29 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_percentile_1` INT,
30 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_distributions_min_1` INT,
31 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_distributions_max_1` INT,
32 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_distributions_proportion_1` NUMERIC(19, 18),
33 `metrics_CUMULATIVE_LAYOUT_SHIFT_SCORE_category` VARCHAR(4) CHARACTER SET utf8,
34 `metrics_FIRST_CONTENTFUL_PAINT_MS_percentile` INT,
35 `metrics_FIRST_CONTENTFUL_PAINT_MS_distributions_min_1` INT,
36 `metrics_FIRST_CONTENTFUL_PAINT_MS_distributions_max_1` INT,
37 `metrics_FIRST_CONTENTFUL_PAINT_MS_distributions_proportion_1` NUMERIC(19, 18),
38 `metrics_FIRST_CONTENTFUL_PAINT_MS_category` VARCHAR(4) CHARACTER SET utf8,
39 `originLoadingExperience_metrics_FIRST_INPUT_DELAY_MS_percentile` INT,
40 `metrics_FIRST_INPUT_DELAY_MS_distributions_min` INT,
41 `metrics_FIRST_INPUT_DELAY_MS_distributions_max` INT,
42 `metrics_FIRST_INPUT_DELAY_MS_distributions_proportion_1` NUMERIC(19, 18),
43 `originLoadingExperience_metrics_FIRST_INPUT_DELAY_MS_category` VARCHAR(4) CHARACTER SET utf8,
44 `metrics_LARGEST_CONTENTFUL_PAINT_MS_percentile` INT,
45 `metrics_LARGEST_CONTENTFUL_PAINT_MS_distributions_min_1` INT,
46 `metrics_LARGEST_CONTENTFUL_PAINT_MS_distributions_max_1` INT,
47 `metrics_LARGEST_CONTENTFUL_PAINT_MS_distributions_proportion_1` NUMERIC(19, 18),
48 `metrics_LARGEST_CONTENTFUL_PAINT_MS_category` VARCHAR(4) CHARACTER SET utf8,
49 `originLoadingExperience_overall_category` VARCHAR(4) CHARACTER SET utf8,
50 `originLoadingExperience_initial_url` VARCHAR(22) CHARACTER SET utf8,
51 `lighthouseResult_requestedUrl` VARCHAR(22) CHARACTER SET utf8,
52 `lighthouseResult_finalUrl` VARCHAR(22) CHARACTER SET utf8,
53 `lighthouseResult_lighthouseVersion` VARCHAR(5) CHARACTER SET utf8,
54 `lighthouseResult_userAgent` VARCHAR(112) CHARACTER SET utf8,
55 `lighthouseResult_fetchTime` VARCHAR(24) CHARACTER SET utf8,
56 `lighthouseResult_environment_networkUserAgent` VARCHAR(137) CHARACTER SET utf8,
57 `lighthouseResult_environment_hostUserAgent` VARCHAR(112) CHARACTER SET utf8,
58 `lighthouseResult_environment_benchmarkIndex` INT,
59 `lighthouseResult_configSettings_emulatedFormFactor` VARCHAR(7) CHARACTER SET utf8,
60 `lighthouseResult_configSettings_formFactor` VARCHAR(7) CHARACTER SET utf8,
61 `lighthouseResult_configSettings_locale` VARCHAR(5) CHARACTER SET utf8,
62 `lighthouseResult_configSettings_onlyCategories` VARCHAR(14) CHARACTER SET utf8,
63 `lighthouseResult_configSettings_channel` VARCHAR(2) CHARACTER SET utf8,
64 `lighthouseResult_audits_key` VARCHAR(34) CHARACTER SET utf8,
65 `lighthouseResult_audits_properties_id` VARCHAR(34) CHARACTER SET utf8,
66 `lighthouseResult_audits_properties_title` VARCHAR(121) CHARACTER SET utf8,
67 `lighthouseResult_audits_properties_description` VARCHAR(556) CHARACTER SET utf8,
68 `lighthouseResult_audits_properties_score` NUMERIC(3, 2),
69 `lighthouseResult_audits_properties_scoreDisplayMode` VARCHAR(13) CHARACTER SET utf8,
70 `lighthouseResult_audits_properties_details_items_node_lhId` VARCHAR(12) CHARACTER SET utf8,
71 `lighthouseResult_audits_properties_details_items_node_selector` VARCHAR(119) CHARACTER SET utf8,
72 `lighthouseResult_audits_properties_details_items_node_nodeLabel` VARCHAR(119) CHARACTER SET utf8,
73 `lighthouseResult_audits_properties_details_items_node_snippet` VARCHAR(197) CHARACTER SET utf8,
74 `audits_properties_details_items_node_boundingRect_top` INT,
75 `audits_properties_details_items_node_boundingRect_right` INT,
76 `audits_properties_details_items_node_boundingRect_left` INT,
77 `audits_properties_details_items_node_boundingRect_bottom` INT,
78 `audits_properties_details_items_node_boundingRect_height` INT,
79 `audits_properties_details_items_node_boundingRect_width` INT,
80 `lighthouseResult_audits_properties_details_items_node_type` VARCHAR(4) CHARACTER SET utf8,
81 `lighthouseResult_audits_properties_details_items_node_path` VARCHAR(184) CHARACTER SET utf8,
82 `lighthouseResult_audits_properties_details_type` VARCHAR(20) CHARACTER SET utf8,
83 `lighthouseResult_audits_properties_details_headings_itemType` VARCHAR(15) CHARACTER SET utf8,
84 `lighthouseResult_audits_properties_details_headings_key` VARCHAR(18) CHARACTER SET utf8,
85 `lighthouseResult_audits_properties_details_headings_text` VARCHAR(25) CHARACTER SET utf8,
86 `lighthouseResult_audits_properties_displayValue` VARCHAR(49) CHARACTER SET utf8,
87 `lighthouseResult_audits_properties_details_overallSavingsBytes` INT,
88 `lighthouseResult_audits_properties_details_overallSavingsMs` NUMERIC(6, 3),
89 `lighthouseResult_audits_properties_details_headings_label` VARCHAR(17) CHARACTER SET utf8,
90 `lighthouseResult_audits_properties_details_headings_valueType` VARCHAR(10) CHARACTER SET utf8,
91 `lighthouseResult_audits_properties_details_items_url` VARCHAR(226) CHARACTER SET utf8,
92 `lighthouseResult_audits_properties_details_items_totalBytes` INT,
93 `lighthouseResult_audits_properties_details_items_wastedBytes` NUMERIC(18, 13),
94 `lighthouseResult_audits_properties_numericValue` NUMERIC(26, 19),
95 `lighthouseResult_audits_properties_numericUnit` VARCHAR(11) CHARACTER SET utf8,
96 `lighthouseResult_audits_properties_details_nodes_name` VARCHAR(96) CHARACTER SET utf8,
97 `lighthouseResult_audits_properties_details_nodes_resourceBytes` INT,
98 `lighthouseResult_audits_properties_details_nodes_unusedBytes` INT,
99 `lighthouseResult_audits_properties_details_nodes_children_name` VARCHAR(17) CHARACTER SET utf8,
100 `audits_properties_details_nodes_children_unusedBytes` INT,
101 `audits_properties_details_nodes_children_resourceBytes` INT,
102 `audits_properties_details_nodes_children_children_resourceBytes` INT,
103 `audits_properties_details_nodes_children_children_name` VARCHAR(27) CHARACTER SET utf8,
104 `audits_properties_details_nodes_children_children_unusedBytes` INT,
105 `audits_properties_details_nodes_children_children_children_name` VARCHAR(44) CHARACTER SET utf8,
106 `properties_details_nodes_children_children_children_unusedBytes` INT,
107 `details_nodes_children_children_children_resourceBytes` INT,
108 `details_nodes_children_children_children_children_resourceBytes` INT,
109 `details_nodes_children_children_children_children_name` VARCHAR(41) CHARACTER SET utf8,
110 `details_nodes_children_children_children_children_unusedBytes` INT,
111 `lighthouseResult_audits_properties_details_summary_wastedBytes` NUMERIC(17, 11),
112 `audits_properties_details_items_cacheHitProbability` NUMERIC(19, 18),
113 `lighthouseResult_audits_properties_details_items_cacheLifetimeMs` INT,
114 `lighthouseResult_audits_properties_details_items_debugData_type` VARCHAR(9) CHARACTER SET utf8,
115 `audits_properties_details_items_debugData_max_age` INT,
116 `lighthouseResult_audits_properties_details_headings_displayUnit` VARCHAR(8) CHARACTER SET utf8,
117 `lighthouseResult_audits_properties_details_headings_granularity` NUMERIC(4, 3),
118 `audits_properties_details_items_node_explanation` VARCHAR(387) CHARACTER SET utf8,
119 `lighthouseResult_audits_properties_details_debugData_tags` VARCHAR(27) CHARACTER SET utf8,
120 `lighthouseResult_audits_properties_details_debugData_type` VARCHAR(9) CHARACTER SET utf8,
121 `lighthouseResult_audits_properties_details_debugData_impact` VARCHAR(8) CHARACTER SET utf8,
122 `lighthouseResult_audits_properties_details_items_subItems_type` VARCHAR(8) CHARACTER SET utf8,
123 `audits_properties_details_items_subItems_items_location_line` INT,
124 `audits_properties_details_items_subItems_items_location_type` VARCHAR(15) CHARACTER SET utf8,
125 `audits_properties_details_items_subItems_items_location_column` INT,
126 `properties_details_items_subItems_items_location_urlProvider` VARCHAR(7) CHARACTER SET utf8,
127 `audits_properties_details_items_subItems_items_location_url` VARCHAR(93) CHARACTER SET utf8,
128 `audits_properties_details_items_subItems_items_signal` VARCHAR(26) CHARACTER SET utf8,
129 `properties_details_items_subItems_items_location_original_file` VARCHAR(45) CHARACTER SET utf8,
130 `properties_details_items_subItems_items_location_original_column` INT,
131 `properties_details_items_subItems_items_location_original_line` INT,
132 `audits_properties_details_headings_subItemsHeading_valueType` VARCHAR(15) CHARACTER SET utf8,
133 `audits_properties_details_headings_subItemsHeading_key` VARCHAR(17) CHARACTER SET utf8,
134 `lighthouseResult_audits_properties_details_screenshot_data` MEDIUMTEXT CHARACTER SET utf8,
135 `lighthouseResult_audits_properties_details_screenshot_width` INT,
136 `lighthouseResult_audits_properties_details_screenshot_height` INT,
137 `lighthouseResult_audits_properties_details_nodes_key` VARCHAR(17) CHARACTER SET utf8,
138 `lighthouseResult_audits_properties_details_nodes_properties_left` INT,
139 `audits_properties_details_nodes_properties_bottom` INT,
140 `audits_properties_details_nodes_properties_height` INT,
141 `audits_properties_details_nodes_properties_right` INT,
142 `lighthouseResult_audits_properties_details_nodes_properties_top` INT,
143 `audits_properties_details_nodes_properties_width` INT,
144 `lighthouseResult_audits_properties_details_items_timing` INT,
145 `lighthouseResult_audits_properties_details_items_timestamp` BIGINT,
146 `lighthouseResult_audits_properties_details_items_data` VARCHAR(9523) CHARACTER SET utf8,
147 `lighthouseResult_audits_properties_details_scale` INT,
148 `lighthouseResult_audits_properties_details_items_wastedPercent` NUMERIC(17, 15),
149 `lighthouseResult_audits_properties_details_items_vulnCount` INT,
150 `lighthouseResult_audits_properties_details_items_detectedLib_url` VARCHAR(98) CHARACTER SET utf8,
151 `audits_properties_details_items_detectedLib_text` VARCHAR(16) CHARACTER SET utf8,
152 `audits_properties_details_items_detectedLib_type` VARCHAR(4) CHARACTER SET utf8,
153 `lighthouseResult_audits_properties_details_items_highestSeverity` VARCHAR(6) CHARACTER SET utf8,
154 `audits_properties_details_debugData_stacks_version` VARCHAR(18) CHARACTER SET utf8,
155 `lighthouseResult_audits_properties_details_debugData_stacks_id` VARCHAR(11) CHARACTER SET utf8,
156 `lighthouseResult_audits_properties_details_items_version` VARCHAR(18) CHARACTER SET utf8,
157 `lighthouseResult_audits_properties_details_items_npm` VARCHAR(10) CHARACTER SET utf8,
158 `lighthouseResult_audits_properties_details_items_name` VARCHAR(10) CHARACTER SET utf8,
159 `lighthouseResult_audits_properties_details_timestamp` BIGINT,
160 `lighthouseResult_audits_properties_details_timing` INT,
161 `lighthouseResult_audits_properties_details_data` MEDIUMTEXT CHARACTER SET utf8,
162 `audits_properties_details_items_maxServerLatency` INT,
163 `audits_properties_details_items_numTasksOver500ms` INT,
164 `lighthouseResult_audits_properties_details_items_totalTaskTime` NUMERIC(17, 13),
165 `lighthouseResult_audits_properties_details_items_maxRtt` NUMERIC(20, 19),
166 `lighthouseResult_audits_properties_details_items_numTasks` INT,
167 `lighthouseResult_audits_properties_details_items_totalByteWeight` INT,
168 `lighthouseResult_audits_properties_details_items_numScripts` INT,
169 `audits_properties_details_items_mainDocumentTransferSize` INT,
170 `lighthouseResult_audits_properties_details_items_rtt` NUMERIC(20, 19),
171 `lighthouseResult_audits_properties_details_items_numRequests` INT,
172 `audits_properties_details_items_numTasksOver10ms` INT,
173 `lighthouseResult_audits_properties_details_items_throughput` NUMERIC(16, 5),
174 `audits_properties_details_items_numTasksOver50ms` INT,
175 `audits_properties_details_items_numTasksOver25ms` INT,
176 `lighthouseResult_audits_properties_details_items_numFonts` INT,
177 `lighthouseResult_audits_properties_details_items_numStylesheets` INT,
178 `audits_properties_details_items_numTasksOver100ms` INT,
179 `audits_properties_details_items_totalCumulativeLayoutShift` NUMERIC(20, 19),
180 `audits_properties_details_items_cumulativeLayoutShiftMainFrame` NUMERIC(20, 19),
181 `lighthouseResult_audits_properties_details_summary_wastedMs` NUMERIC(16, 13),
182 `lighthouseResult_audits_properties_details_items_entity_type` VARCHAR(4) CHARACTER SET utf8,
183 `lighthouseResult_audits_properties_details_items_entity_text` VARCHAR(22) CHARACTER SET utf8,
184 `lighthouseResult_audits_properties_details_items_entity_url` VARCHAR(55) CHARACTER SET utf8,
185 `lighthouseResult_audits_properties_details_items_blockingTime` INT,
186 `lighthouseResult_audits_properties_details_items_mainThreadTime` NUMERIC(16, 14),
187 `audits_properties_details_items_subItems_items_url` VARCHAR(54) CHARACTER SET utf8,
188 `audits_properties_details_items_subItems_items_blockingTime` INT,
189 `audits_properties_details_items_subItems_items_mainThreadTime` NUMERIC(16, 14),
190 `audits_properties_details_items_subItems_items_transferSize` INT,
191 `lighthouseResult_audits_properties_details_items_transferSize` INT,
192 `audits_properties_details_headings_subItemsHeading_itemType` VARCHAR(4) CHARACTER SET utf8,
193 `lighthouseResult_audits_properties_details_items_requestCount` INT,
194 `lighthouseResult_audits_properties_details_items_label` VARCHAR(11) CHARACTER SET utf8,
195 `lighthouseResult_audits_properties_details_items_resourceType` VARCHAR(11) CHARACTER SET utf8,
196 `audits_properties_details_items_observedFirstContentfulPaintTs` BIGINT,
197 `lighthouseResult_audits_properties_details_items_observedLoadTs` BIGINT,
198 `details_items_observedLargestContentfulPaintAllFramesTs` BIGINT,
199 `audits_properties_details_items_observedLastVisualChangeTs` BIGINT,
200 `audits_properties_details_items_firstContentfulPaint` INT,
201 `audits_properties_details_items_observedNavigationStartTs` BIGINT,
202 `audits_properties_details_items_observedFirstVisualChangeTs` BIGINT,
203 `properties_details_items_observedTotalCumulativeLayoutShift` NUMERIC(20, 19),
204 `lighthouseResult_audits_properties_details_items_speedIndex` INT,
205 `audits_properties_details_items_observedTraceEndTs` BIGINT,
206 `audits_properties_details_items_observedTimeOrigin` INT,
207 `audits_properties_details_items_totalBlockingTime` INT,
208 `properties_details_items_observedLargestContentfulPaintAllFrames` INT,
209 `audits_properties_details_items_observedLargestContentfulPaintTs` BIGINT,
210 `audits_properties_details_items_observedFirstVisualChange` INT,
211 `audits_properties_details_items_largestContentfulPaint` INT,
212 `audits_properties_details_items_observedNavigationStart` INT,
213 `audits_properties_details_items_observedFirstMeaningfulPaint` INT,
214 `audits_properties_details_items_observedLargestContentfulPaint` INT,
215 `audits_properties_details_items_observedTraceEnd` INT,
216 `audits_properties_details_items_observedLastVisualChange` INT,
217 `audits_properties_details_items_observedFirstPaint` INT,
218 `audits_properties_details_items_observedFirstMeaningfulPaintTs` BIGINT,
219 `audits_properties_details_items_observedCumulativeLayoutShift` NUMERIC(20, 19),
220 `audits_properties_details_items_cumulativeLayoutShift` NUMERIC(20, 19),
221 `properties_details_items_observedFirstContentfulPaintAllFramesTs` BIGINT,
222 `audits_properties_details_items_observedDomContentLoaded` INT,
223 `audits_properties_details_items_observedSpeedIndexTs` BIGINT,
224 `audits_properties_details_items_observedTimeOriginTs` BIGINT,
225 `audits_properties_details_items_firstMeaningfulPaint` INT,
226 `lighthouseResult_audits_properties_details_items_interactive` INT,
227 `lighthouseResult_audits_properties_details_items_maxPotentialFID` INT,
228 `properties_details_items_observedFirstContentfulPaintAllFrames` INT,
229 `properties_details_items_observedCumulativeLayoutShiftMainFrame` NUMERIC(20, 19),
230 `audits_properties_details_items_observedSpeedIndex` INT,
231 `audits_properties_details_items_observedFirstPaintTs` BIGINT,
232 `audits_properties_details_items_observedFirstContentfulPaint` INT,
233 `audits_properties_details_items_observedDomContentLoadedTs` BIGINT,
234 `lighthouseResult_audits_properties_details_items_observedLoad` INT,
235 `lighthouseResult_audits_properties_details_items_lcpInvalidated` VARCHAR(5) CHARACTER SET utf8,
236 `lighthouseResult_audits_properties_details_items_total` NUMERIC(17, 14),
237 `audits_properties_details_items_scriptParseCompile` NUMERIC(18, 17),
238 `lighthouseResult_audits_properties_details_items_scripting` NUMERIC(18, 15),
239 `lighthouseResult_audits_properties_details_items_responseTime` NUMERIC(6, 3),
240 `lighthouseResult_audits_properties_details_items_startTime` NUMERIC(18, 14),
241 `lighthouseResult_audits_properties_details_items_resourceSize` INT,
242 `lighthouseResult_audits_properties_details_items_statusCode` INT,
243 `lighthouseResult_audits_properties_details_items_finished` VARCHAR(4) CHARACTER SET utf8,
244 `lighthouseResult_audits_properties_details_items_endTime` NUMERIC(18, 14),
245 `lighthouseResult_audits_properties_details_items_protocol` VARCHAR(8) CHARACTER SET utf8,
246 `lighthouseResult_audits_properties_details_items_mimeType` VARCHAR(22) CHARACTER SET utf8,
247 `lighthouseResult_audits_properties_details_items_source_line` INT,
248 `lighthouseResult_audits_properties_details_items_source_url` VARCHAR(96) CHARACTER SET utf8,
249 `lighthouseResult_audits_properties_details_items_source_type` VARCHAR(15) CHARACTER SET utf8,
250 `audits_properties_details_items_source_urlProvider` VARCHAR(7) CHARACTER SET utf8,
251 `lighthouseResult_audits_properties_details_items_source_column` INT,
252 `lighthouseResult_audits_properties_details_items_target` VARCHAR(6) CHARACTER SET utf8,
253 `lighthouseResult_audits_properties_details_items_outerHTML` VARCHAR(111) CHARACTER SET utf8,
254 `lighthouseResult_audits_properties_details_items_href` VARCHAR(99) CHARACTER SET utf8,
255 `lighthouseResult_audits_properties_details_items_duration` NUMERIC(17, 14),
256 `lighthouseResult_audits_properties_details_items_wastedMs` INT,
257 `lighthouseResult_audits_properties_details_items_score` NUMERIC(21, 20),
258 `audits_properties_details_items_subItems_items_failureReason` VARCHAR(42) CHARACTER SET utf8,
259 `audits_properties_details_items_subItems_items_animation` VARCHAR(16) CHARACTER SET utf8,
260 `lighthouseResult_audits_properties_details_items_severity` VARCHAR(4) CHARACTER SET utf8,
261 `lighthouseResult_audits_properties_details_items_description` VARCHAR(32) CHARACTER SET utf8,
262 `audits_properties_details_items_subItems_items_sourceWastedBytes` INT,
263 `audits_properties_details_items_subItems_items_sourceBytes` INT,
264 `audits_properties_details_items_subItems_items_source` VARCHAR(59) CHARACTER SET utf8,
265 `audits_properties_details_longestChain_transferSize` INT,
266 `lighthouseResult_audits_properties_details_longestChain_duration` NUMERIC(16, 13),
267 `lighthouseResult_audits_properties_details_longestChain_length` INT,
268 `audits_properties_details_items_subItems_items_error` VARCHAR(47) CHARACTER SET utf8,
269 `lighthouseResult_audits_properties_details_items_scriptUrl` VARCHAR(96) CHARACTER SET utf8,
270 `lighthouseResult_audits_properties_details_items_sourceMapUrl` VARCHAR(100) CHARACTER SET utf8,
271 `lighthouseResult_audits_properties_details_items_value` INT,
272 `lighthouseResult_audits_properties_details_items_statistic` VARCHAR(22) CHARACTER SET utf8,
273 `lighthouseResult_audits_properties_details_items_groupLabel` VARCHAR(28) CHARACTER SET utf8,
274 `lighthouseResult_audits_properties_details_items_group` VARCHAR(20) CHARACTER SET utf8,
275 `lighthouseResult_categories_performance_id` VARCHAR(11) CHARACTER SET utf8,
276 `lighthouseResult_categories_performance_title` VARCHAR(11) CHARACTER SET utf8,
277 `lighthouseResult_categories_performance_score` NUMERIC(3, 2),
278 `lighthouseResult_categories_performance_auditRefs_id` VARCHAR(32) CHARACTER SET utf8,
279 `lighthouseResult_categories_performance_auditRefs_weight` INT,
280 `lighthouseResult_categories_performance_auditRefs_group` VARCHAR(18) CHARACTER SET utf8,
281 `lighthouseResult_categories_performance_auditRefs_acronym` VARCHAR(3) CHARACTER SET utf8,
282 `lighthouseResult_categories_performance_auditRefs_relevantAudits` VARCHAR(32) CHARACTER SET utf8,
283 `lighthouseResult_categories_accessibility_id` VARCHAR(13) CHARACTER SET utf8,
284 `lighthouseResult_categories_accessibility_title` VARCHAR(13) CHARACTER SET utf8,
285 `lighthouseResult_categories_accessibility_description` VARCHAR(252) CHARACTER SET utf8,
286 `lighthouseResult_categories_accessibility_score` NUMERIC(3, 2),
287 `lighthouseResult_categories_accessibility_manualDescription` VARCHAR(212) CHARACTER SET utf8,
288 `lighthouseResult_categories_accessibility_auditRefs_id` VARCHAR(30) CHARACTER SET utf8,
289 `lighthouseResult_categories_accessibility_auditRefs_weight` INT,
290 `lighthouseResult_categories_accessibility_auditRefs_group` VARCHAR(19) CHARACTER SET utf8,
291 `lighthouseResult_categories_best_practices_id` VARCHAR(14) CHARACTER SET utf8,
292 `lighthouseResult_categories_best_practices_title` VARCHAR(14) CHARACTER SET utf8,
293 `lighthouseResult_categories_best_practices_score` NUMERIC(3, 2),
294 `lighthouseResult_categories_best_practices_auditRefs_id` VARCHAR(34) CHARACTER SET utf8,
295 `lighthouseResult_categories_best_practices_auditRefs_weight` INT,
296 `lighthouseResult_categories_best_practices_auditRefs_group` VARCHAR(29) CHARACTER SET utf8,
297 `lighthouseResult_categories_seo_id` VARCHAR(3) CHARACTER SET utf8,
298 `lighthouseResult_categories_seo_title` VARCHAR(3) CHARACTER SET utf8,
299 `lighthouseResult_categories_seo_description` VARCHAR(335) CHARACTER SET utf8,
300 `lighthouseResult_categories_seo_score` NUMERIC(3, 2),
301 `lighthouseResult_categories_seo_manualDescription` VARCHAR(84) CHARACTER SET utf8,
302 `lighthouseResult_categories_seo_auditRefs_id` VARCHAR(17) CHARACTER SET utf8,
303 `lighthouseResult_categories_seo_auditRefs_weight` INT,
304 `lighthouseResult_categories_seo_auditRefs_group` VARCHAR(11) CHARACTER SET utf8,
305 `lighthouseResult_categoryGroups_load_opportunities_title` VARCHAR(13) CHARACTER SET utf8,
306 `lighthouseResult_categoryGroups_load_opportunities_description` VARCHAR(139) CHARACTER SET utf8,
307 `lighthouseResult_categoryGroups_diagnostics_title` VARCHAR(11) CHARACTER SET utf8,
308 `lighthouseResult_categoryGroups_diagnostics_description` VARCHAR(158) CHARACTER SET utf8,
309 `lighthouseResult_categoryGroups_budgets_title` VARCHAR(7) CHARACTER SET utf8,
310 `lighthouseResult_categoryGroups_budgets_description` VARCHAR(67) CHARACTER SET utf8,
311 `lighthouseResult_categoryGroups_metrics_title` VARCHAR(7) CHARACTER SET utf8,
312 `lighthouseResult_categoryGroups_a11y_tables_lists_title` VARCHAR(16) CHARACTER SET utf8,
313 `lighthouseResult_categoryGroups_a11y_tables_lists_description` VARCHAR(131) CHARACTER SET utf8,
314 `lighthouseResult_categoryGroups_a11y_aria_title` VARCHAR(4) CHARACTER SET utf8,
315 `lighthouseResult_categoryGroups_a11y_aria_description` VARCHAR(162) CHARACTER SET utf8,
316 `lighthouseResult_categoryGroups_a11y_best_practices_title` VARCHAR(14) CHARACTER SET utf8,
317 `lighthouseResult_categoryGroups_a11y_best_practices_description` VARCHAR(58) CHARACTER SET utf8,
318 `lighthouseResult_categoryGroups_seo_content_title` VARCHAR(22) CHARACTER SET utf8,
319 `lighthouseResult_categoryGroups_seo_content_description` VARCHAR(88) CHARACTER SET utf8,
320 `lighthouseResult_categoryGroups_seo_crawl_title` VARCHAR(21) CHARACTER SET utf8,
321 `lighthouseResult_categoryGroups_seo_crawl_description` VARCHAR(62) CHARACTER SET utf8,
322 `lighthouseResult_categoryGroups_a11y_color_contrast_title` VARCHAR(8) CHARACTER SET utf8,
323 `lighthouseResult_categoryGroups_a11y_color_contrast_description` VARCHAR(66) CHARACTER SET utf8,
324 `lighthouseResult_categoryGroups_a11y_names_labels_title` VARCHAR(16) CHARACTER SET utf8,
325 `lighthouseResult_categoryGroups_a11y_names_labels_description` VARCHAR(174) CHARACTER SET utf8,
326 `lighthouseResult_categoryGroups_best_practices_general_title` VARCHAR(7) CHARACTER SET utf8,
327 `lighthouseResult_categoryGroups_best_practices_ux_title` VARCHAR(15) CHARACTER SET utf8,
328 `categoryGroups_best_practices_trust_safety_title` VARCHAR(16) CHARACTER SET utf8,
329 `lighthouseResult_categoryGroups_pwa_installable_title` VARCHAR(11) CHARACTER SET utf8,
330 `lighthouseResult_categoryGroups_a11y_audio_video_title` VARCHAR(15) CHARACTER SET utf8,
331 `lighthouseResult_categoryGroups_a11y_audio_video_description` VARCHAR(153) CHARACTER SET utf8,
332 `lighthouseResult_categoryGroups_a11y_language_title` VARCHAR(37) CHARACTER SET utf8,
333 `lighthouseResult_categoryGroups_a11y_language_description` VARCHAR(100) CHARACTER SET utf8,
334 `categoryGroups_best_practices_browser_compat_title` VARCHAR(21) CHARACTER SET utf8,
335 `lighthouseResult_categoryGroups_pwa_optimized_title` VARCHAR(13) CHARACTER SET utf8,
336 `lighthouseResult_categoryGroups_a11y_navigation_title` VARCHAR(10) CHARACTER SET utf8,
337 `lighthouseResult_categoryGroups_a11y_navigation_description` VARCHAR(75) CHARACTER SET utf8,
338 `lighthouseResult_categoryGroups_seo_mobile_title` VARCHAR(15) CHARACTER SET utf8,
339 `lighthouseResult_categoryGroups_seo_mobile_description` VARCHAR(179) CHARACTER SET utf8,
340 `lighthouseResult_timing_total` NUMERIC(7, 2),
341 `i18n_rendererFormattedStrings_varianceDisclaimer` VARCHAR(139) CHARACTER SET utf8,
342 `i18n_rendererFormattedStrings_opportunityResourceColumnLabel` VARCHAR(11) CHARACTER SET utf8,
343 `i18n_rendererFormattedStrings_opportunitySavingsColumnLabel` VARCHAR(17) CHARACTER SET utf8,
344 `i18n_rendererFormattedStrings_errorMissingAuditInfo` VARCHAR(34) CHARACTER SET utf8,
345 `lighthouseResult_i18n_rendererFormattedStrings_errorLabel` VARCHAR(6) CHARACTER SET utf8,
346 `lighthouseResult_i18n_rendererFormattedStrings_warningHeader` VARCHAR(10) CHARACTER SET utf8,
347 `i18n_rendererFormattedStrings_passedAuditsGroupTitle` VARCHAR(13) CHARACTER SET utf8,
348 `i18n_rendererFormattedStrings_notApplicableAuditsGroupTitle` VARCHAR(14) CHARACTER SET utf8,
349 `i18n_rendererFormattedStrings_manualAuditsGroupTitle` VARCHAR(34) CHARACTER SET utf8,
350 `i18n_rendererFormattedStrings_toplevelWarningsMessage` VARCHAR(51) CHARACTER SET utf8,
351 `i18n_rendererFormattedStrings_crcLongestDurationLabel` VARCHAR(30) CHARACTER SET utf8,
352 `i18n_rendererFormattedStrings_crcInitialNavigation` VARCHAR(18) CHARACTER SET utf8,
353 `i18n_rendererFormattedStrings_lsPerformanceCategoryDescription` VARCHAR(160) CHARACTER SET utf8,
354 `lighthouseResult_i18n_rendererFormattedStrings_labDataTitle` VARCHAR(8) CHARACTER SET utf8,
355 `i18n_rendererFormattedStrings_warningAuditsGroupTitle` VARCHAR(31) CHARACTER SET utf8,
356 `i18n_rendererFormattedStrings_snippetExpandButtonLabel` VARCHAR(14) CHARACTER SET utf8,
357 `i18n_rendererFormattedStrings_snippetCollapseButtonLabel` VARCHAR(16) CHARACTER SET utf8,
358 `i18n_rendererFormattedStrings_thirdPartyResourcesLabel` VARCHAR(24) CHARACTER SET utf8,
359 `i18n_rendererFormattedStrings_runtimeDesktopEmulation` VARCHAR(16) CHARACTER SET utf8,
360 `i18n_rendererFormattedStrings_runtimeMobileEmulation` VARCHAR(16) CHARACTER SET utf8,
361 `i18n_rendererFormattedStrings_runtimeNoEmulation` VARCHAR(12) CHARACTER SET utf8,
362 `i18n_rendererFormattedStrings_runtimeSettingsBenchmark` VARCHAR(16) CHARACTER SET utf8,
363 `i18n_rendererFormattedStrings_runtimeSettingsCPUThrottling` VARCHAR(14) CHARACTER SET utf8,
364 `i18n_rendererFormattedStrings_runtimeSettingsDevice` VARCHAR(6) CHARACTER SET utf8,
365 `i18n_rendererFormattedStrings_runtimeSettingsFetchTime` VARCHAR(10) CHARACTER SET utf8,
366 `i18n_rendererFormattedStrings_runtimeSettingsNetworkThrottling` VARCHAR(18) CHARACTER SET utf8,
367 `i18n_rendererFormattedStrings_runtimeSettingsTitle` VARCHAR(16) CHARACTER SET utf8,
368 `lighthouseResult_i18n_rendererFormattedStrings_runtimeSettingsUA` VARCHAR(17) CHARACTER SET utf8,
369 `i18n_rendererFormattedStrings_runtimeSettingsUANetwork` VARCHAR(20) CHARACTER SET utf8,
370 `i18n_rendererFormattedStrings_runtimeSettingsUrl` VARCHAR(3) CHARACTER SET utf8,
371 `lighthouseResult_i18n_rendererFormattedStrings_runtimeUnknown` VARCHAR(7) CHARACTER SET utf8,
372 `lighthouseResult_i18n_rendererFormattedStrings_dropdownCopyJSON` VARCHAR(9) CHARACTER SET utf8,
373 `lighthouseResult_i18n_rendererFormattedStrings_dropdownDarkTheme` VARCHAR(17) CHARACTER SET utf8,
374 `i18n_rendererFormattedStrings_dropdownPrintExpanded` VARCHAR(14) CHARACTER SET utf8,
375 `i18n_rendererFormattedStrings_dropdownPrintSummary` VARCHAR(13) CHARACTER SET utf8,
376 `lighthouseResult_i18n_rendererFormattedStrings_dropdownSaveGist` VARCHAR(12) CHARACTER SET utf8,
377 `lighthouseResult_i18n_rendererFormattedStrings_dropdownSaveHTML` VARCHAR(12) CHARACTER SET utf8,
378 `lighthouseResult_i18n_rendererFormattedStrings_dropdownSaveJSON` VARCHAR(12) CHARACTER SET utf8,
379 `lighthouseResult_i18n_rendererFormattedStrings_dropdownViewer` VARCHAR(14) CHARACTER SET utf8,
380 `lighthouseResult_i18n_rendererFormattedStrings_footerIssue` VARCHAR(13) CHARACTER SET utf8,
381 `i18n_rendererFormattedStrings_throttlingProvided` VARCHAR(23) CHARACTER SET utf8,
382 `i18n_rendererFormattedStrings_runtimeSettingsChannel` VARCHAR(7) CHARACTER SET utf8,
383 `lighthouseResult_i18n_rendererFormattedStrings_calculatorLink` VARCHAR(15) CHARACTER SET utf8,
384 `i18n_rendererFormattedStrings_runtimeSettingsAxeVersion` VARCHAR(11) CHARACTER SET utf8,
385 `lighthouseResult_i18n_rendererFormattedStrings_viewTreemapLabel` VARCHAR(12) CHARACTER SET utf8,
386 `i18n_rendererFormattedStrings_showRelevantAudits` VARCHAR(24) CHARACTER SET utf8,
387 `analysisUTCTimestamp` VARCHAR(24) CHARACTER SET utf8