1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629--
-- PostgreSQL database dump
--
-- Dumped from database version 15.2 (Debian 15.2-1.pgdg110+1)
-- Dumped by pg_dump version 15.2 (Homebrew)
-- Started on 2023-03-23 19:25:36 EDT
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
--
-- TOC entry 6 (class 2615 OID 39606)
-- Name: meta; Type: SCHEMA; Schema: -; Owner: a11ydata
--
CREATE SCHEMA meta;
ALTER SCHEMA meta OWNER TO a11ydata;
--
-- TOC entry 7 (class 2615 OID 39607)
-- Name: results; Type: SCHEMA; Schema: -; Owner: a11ydata
--
CREATE SCHEMA results;
ALTER SCHEMA results OWNER TO a11ydata;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- TOC entry 224 (class 1259 OID 39659)
-- Name: domains; Type: TABLE; Schema: meta; Owner: a11ydata
--
CREATE TABLE meta.domains (
id character varying NOT NULL,
domain character varying NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
org_id integer
);
ALTER TABLE meta.domains OWNER TO a11ydata;
--
-- TOC entry 226 (class 1259 OID 39676)
-- Name: org_types; Type: TABLE; Schema: meta; Owner: a11ydata
--
CREATE TABLE meta.org_types (
id integer NOT NULL,
name character varying NOT NULL,
description character varying,
examples character varying,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE meta.org_types OWNER TO a11ydata;
--
-- TOC entry 225 (class 1259 OID 39675)
-- Name: org_types_id_seq; Type: SEQUENCE; Schema: meta; Owner: a11ydata
--
CREATE SEQUENCE meta.org_types_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE meta.org_types_id_seq OWNER TO a11ydata;
--
-- TOC entry 3397 (class 0 OID 0)
-- Dependencies: 225
-- Name: org_types_id_seq; Type: SEQUENCE OWNED BY; Schema: meta; Owner: a11ydata
--
ALTER SEQUENCE meta.org_types_id_seq OWNED BY meta.org_types.id;
--
-- TOC entry 223 (class 1259 OID 39646)
-- Name: orgs; Type: TABLE; Schema: meta; Owner: a11ydata
--
CREATE TABLE meta.orgs (
id integer NOT NULL,
name character varying NOT NULL,
abbr character varying,
parent_org_id integer,
description character varying,
type_id integer,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE meta.orgs OWNER TO a11ydata;
--
-- TOC entry 222 (class 1259 OID 39645)
-- Name: orgs_id_seq; Type: SEQUENCE; Schema: meta; Owner: a11ydata
--
CREATE SEQUENCE meta.orgs_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE meta.orgs_id_seq OWNER TO a11ydata;
--
-- TOC entry 3398 (class 0 OID 0)
-- Dependencies: 222
-- Name: orgs_id_seq; Type: SEQUENCE OWNED BY; Schema: meta; Owner: a11ydata
--
ALTER SEQUENCE meta.orgs_id_seq OWNED BY meta.orgs.id;
--
-- TOC entry 219 (class 1259 OID 39618)
-- Name: items; Type: TABLE; Schema: results; Owner: a11ydata
--
CREATE TABLE results.items (
id integer NOT NULL,
scan_id integer NOT NULL,
type character varying,
description character varying,
help character varying,
help_url character varying,
area character varying NOT NULL,
impact character varying,
tags text[]
);
ALTER TABLE results.items OWNER TO a11ydata;
--
-- TOC entry 3399 (class 0 OID 0)
-- Dependencies: 219
-- Name: COLUMN items.area; Type: COMMENT; Schema: results; Owner: a11ydata
--
COMMENT ON COLUMN results.items.area IS 'Known as id from Axe';
--
-- TOC entry 3400 (class 0 OID 0)
-- Dependencies: 219
-- Name: COLUMN items.impact; Type: COMMENT; Schema: results; Owner: a11ydata
--
COMMENT ON COLUMN results.items.impact IS 'Engine defined impact';
--
-- TOC entry 218 (class 1259 OID 39617)
-- Name: items_id_seq; Type: SEQUENCE; Schema: results; Owner: a11ydata
--
CREATE SEQUENCE results.items_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE results.items_id_seq OWNER TO a11ydata;
--
-- TOC entry 3401 (class 0 OID 0)
-- Dependencies: 218
-- Name: items_id_seq; Type: SEQUENCE OWNED BY; Schema: results; Owner: a11ydata
--
ALTER SEQUENCE results.items_id_seq OWNED BY results.items.id;
--
-- TOC entry 221 (class 1259 OID 39632)
-- Name: nodes; Type: TABLE; Schema: results; Owner: a11ydata
--
CREATE TABLE results.nodes (
id integer NOT NULL,
item_id integer NOT NULL,
html character varying,
impact character varying,
target text[],
"any" text[],
"all" text[],
"none" text[]
);
ALTER TABLE results.nodes OWNER TO a11ydata;
--
-- TOC entry 3402 (class 0 OID 0)
-- Dependencies: 221
-- Name: COLUMN nodes.impact; Type: COMMENT; Schema: results; Owner: a11ydata
--
COMMENT ON COLUMN results.nodes.impact IS 'Engine defined impact';
--
-- TOC entry 220 (class 1259 OID 39631)
-- Name: nodes_id_seq; Type: SEQUENCE; Schema: results; Owner: a11ydata
--
CREATE SEQUENCE results.nodes_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE results.nodes_id_seq OWNER TO a11ydata;
--
-- TOC entry 3403 (class 0 OID 0)
-- Dependencies: 220
-- Name: nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: results; Owner: a11ydata
--
ALTER SEQUENCE results.nodes_id_seq OWNED BY results.nodes.id;
--
-- TOC entry 217 (class 1259 OID 39609)
-- Name: scans; Type: TABLE; Schema: results; Owner: a11ydata
--
CREATE TABLE results.scans (
id integer NOT NULL,
created_at timestamp with time zone NOT NULL,
engine_name character varying NOT NULL,
engine_version character varying NOT NULL,
env_orientation_angle integer,
env_orientation_type character varying,
env_user_agent character varying,
env_window_height integer,
env_window_width integer,
reporter character varying,
runner_name character varying,
scanned_at timestamp with time zone,
url character varying,
domain character varying
);
ALTER TABLE results.scans OWNER TO a11ydata;
--
-- TOC entry 216 (class 1259 OID 39608)
-- Name: scans_id_seq; Type: SEQUENCE; Schema: results; Owner: a11ydata
--
CREATE SEQUENCE results.scans_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE results.scans_id_seq OWNER TO a11ydata;
--
-- TOC entry 3404 (class 0 OID 0)
-- Dependencies: 216
-- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: results; Owner: a11ydata
--
ALTER SEQUENCE results.scans_id_seq OWNED BY results.scans.id;
--
-- TOC entry 3211 (class 2604 OID 39679)
-- Name: org_types id; Type: DEFAULT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.org_types ALTER COLUMN id SET DEFAULT nextval('meta.org_types_id_seq'::regclass);
--
-- TOC entry 3206 (class 2604 OID 39649)
-- Name: orgs id; Type: DEFAULT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.orgs ALTER COLUMN id SET DEFAULT nextval('meta.orgs_id_seq'::regclass);
--
-- TOC entry 3204 (class 2604 OID 39621)
-- Name: items id; Type: DEFAULT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.items ALTER COLUMN id SET DEFAULT nextval('results.items_id_seq'::regclass);
--
-- TOC entry 3205 (class 2604 OID 39635)
-- Name: nodes id; Type: DEFAULT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.nodes ALTER COLUMN id SET DEFAULT nextval('results.nodes_id_seq'::regclass);
--
-- TOC entry 3203 (class 2604 OID 39612)
-- Name: scans id; Type: DEFAULT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.scans ALTER COLUMN id SET DEFAULT nextval('results.scans_id_seq'::regclass);
--
-- TOC entry 3389 (class 0 OID 39659)
-- Dependencies: 224
-- Data for Name: domains; Type: TABLE DATA; Schema: meta; Owner: a11ydata
--
COPY meta.domains (id, domain, created_at, updated_at, org_id) FROM stdin;
--
-- TOC entry 3391 (class 0 OID 39676)
-- Dependencies: 226
-- Data for Name: org_types; Type: TABLE DATA; Schema: meta; Owner: a11ydata
--
COPY meta.org_types (id, name, description, examples, created_at, updated_at) FROM stdin;
34 Federal Organizations that operate within the national government of a country Federal Bureau of Investigation (FBI), United States Department of Agriculture (USDA) 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
35 State Organizations that operate within a state government California Department of Education, Texas Department of Transportation 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
36 Local Organizations that operate within a local government, such as a city or county City of Los Angeles Department of Water and Power, King County Metro Transit 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
37 Tribal Organizations that operate within a tribal government, representing indigenous populations Navajo Nation, Cherokee Nation 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
38 International Organizations that operate across national borders and have global reach United Nations (UN), World Health Organization (WHO) 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
39 Regional Organizations that operate within a specific geographic region African Union in Africa, Regional Environmental Center in Europe, Council of Arab Economic Unity in the Middle East 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
40 NGO Non-governmental organizations that are usually non-profit and operate independently of governments Greenpeace, Amnesty International 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
41 Commercial Organizations that engage in commercial activities to make a profit Apple Inc., ExxonMobil 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
42 Nonprofit Organizations that do not operate for the purpose of making a profit and are often focused on social or environmental causes The Red Cross, Goodwill Industries 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
43 Political Organizations that are focused on political activities and may engage in lobbying or advocacy Republican National Committee, Democratic National Committee 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
44 Educational Organizations that are focused on education and research Harvard University, National Science Foundation 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
45 Religious Organizations that are focused on religious activities and beliefs The Roman Catholic Church, Islamic Relief 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
46 Healthcare Organizations that are focused on healthcare and medical services Mayo Clinic, Doctors Without Borders 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
47 Social Organizations that are focused on social issues and advocacy American Civil Liberties Union, National Association for the Advancement of Colored People 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
48 Environmental Organizations that are focused on environmental issues and advocacy Sierra Club, The Nature Conservancy 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
49 Cultural Organizations that are focused on cultural activities and heritage National Museum of African American History and Culture, The Metropolitan Museum of Art 2023-03-23 14:53:14.163003-07 2023-03-23 14:53:14.163003-07
;
--
-- TOC entry 3388 (class 0 OID 39646)
-- Dependencies: 223
-- Data for Name: orgs; Type: TABLE DATA; Schema: meta; Owner: a11ydata
--
COPY meta.orgs (id, name, abbr, parent_org_id, description, type_id, created_at, updated_at) FROM stdin;
--
-- TOC entry 3384 (class 0 OID 39618)
-- Dependencies: 219
-- Data for Name: items; Type: TABLE DATA; Schema: results; Owner: a11ydata
--
COPY results.items (id, scan_id, type, description, help, help_url, area, impact, tags) FROM stdin;
--
-- TOC entry 3386 (class 0 OID 39632)
-- Dependencies: 221
-- Data for Name: nodes; Type: TABLE DATA; Schema: results; Owner: a11ydata
--
COPY results.nodes (id, item_id, html, impact, target, "any", "all", "none") FROM stdin;
--
-- TOC entry 3382 (class 0 OID 39609)
-- Dependencies: 217
-- Data for Name: scans; Type: TABLE DATA; Schema: results; Owner: a11ydata
--
COPY results.scans (id, created_at, engine_name, engine_version, env_orientation_angle, env_orientation_type, env_user_agent, env_window_height, env_window_width, reporter, runner_name, scanned_at, url, domain) FROM stdin;
--
-- TOC entry 3405 (class 0 OID 0)
-- Dependencies: 225
-- Name: org_types_id_seq; Type: SEQUENCE SET; Schema: meta; Owner: a11ydata
--
SELECT pg_catalog.setval('meta.org_types_id_seq', 49, true);
--
-- TOC entry 3406 (class 0 OID 0)
-- Dependencies: 222
-- Name: orgs_id_seq; Type: SEQUENCE SET; Schema: meta; Owner: a11ydata
--
SELECT pg_catalog.setval('meta.orgs_id_seq', 1, false);
--
-- TOC entry 3407 (class 0 OID 0)
-- Dependencies: 218
-- Name: items_id_seq; Type: SEQUENCE SET; Schema: results; Owner: a11ydata
--
SELECT pg_catalog.setval('results.items_id_seq', 1, false);
--
-- TOC entry 3408 (class 0 OID 0)
-- Dependencies: 220
-- Name: nodes_id_seq; Type: SEQUENCE SET; Schema: results; Owner: a11ydata
--
SELECT pg_catalog.setval('results.nodes_id_seq', 1, false);
--
-- TOC entry 3409 (class 0 OID 0)
-- Dependencies: 216
-- Name: scans_id_seq; Type: SEQUENCE SET; Schema: results; Owner: a11ydata
--
SELECT pg_catalog.setval('results.scans_id_seq', 1, false);
--
-- TOC entry 3223 (class 2606 OID 39667)
-- Name: domains domains_pk; Type: CONSTRAINT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.domains
ADD CONSTRAINT domains_pk PRIMARY KEY (id);
--
-- TOC entry 3225 (class 2606 OID 39669)
-- Name: domains domains_un; Type: CONSTRAINT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.domains
ADD CONSTRAINT domains_un UNIQUE (domain);
--
-- TOC entry 3227 (class 2606 OID 39685)
-- Name: org_types org_types_name_key; Type: CONSTRAINT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.org_types
ADD CONSTRAINT org_types_name_key UNIQUE (name);
--
-- TOC entry 3229 (class 2606 OID 39683)
-- Name: org_types org_types_pkey; Type: CONSTRAINT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.org_types
ADD CONSTRAINT org_types_pkey PRIMARY KEY (id);
--
-- TOC entry 3221 (class 2606 OID 39653)
-- Name: orgs orgs_pk; Type: CONSTRAINT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.orgs
ADD CONSTRAINT orgs_pk PRIMARY KEY (id);
--
-- TOC entry 3217 (class 2606 OID 39625)
-- Name: items items_pk; Type: CONSTRAINT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.items
ADD CONSTRAINT items_pk PRIMARY KEY (id);
--
-- TOC entry 3219 (class 2606 OID 39639)
-- Name: nodes nodes_pk; Type: CONSTRAINT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.nodes
ADD CONSTRAINT nodes_pk PRIMARY KEY (id);
--
-- TOC entry 3215 (class 2606 OID 39616)
-- Name: scans scans_pk; Type: CONSTRAINT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.scans
ADD CONSTRAINT scans_pk PRIMARY KEY (id);
--
-- TOC entry 3237 (class 2620 OID 39695)
-- Name: domains update_created_at; Type: TRIGGER; Schema: meta; Owner: a11ydata
--
CREATE TRIGGER update_created_at BEFORE UPDATE ON meta.domains FOR EACH ROW EXECUTE FUNCTION public.update_created_at_column();
--
-- TOC entry 3238 (class 2620 OID 39694)
-- Name: org_types update_created_at; Type: TRIGGER; Schema: meta; Owner: a11ydata
--
CREATE TRIGGER update_created_at BEFORE UPDATE ON meta.org_types FOR EACH ROW EXECUTE FUNCTION public.update_created_at_column();
--
-- TOC entry 3236 (class 2620 OID 39698)
-- Name: orgs update_created_at; Type: TRIGGER; Schema: meta; Owner: a11ydata
--
CREATE TRIGGER update_created_at BEFORE UPDATE ON meta.orgs FOR EACH ROW EXECUTE FUNCTION public.update_created_at_column();
--
-- TOC entry 3235 (class 2606 OID 39670)
-- Name: domains domains_fk; Type: FK CONSTRAINT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.domains
ADD CONSTRAINT domains_fk FOREIGN KEY (org_id) REFERENCES meta.orgs(id);
--
-- TOC entry 3233 (class 2606 OID 39654)
-- Name: orgs orgs_parent_org_id_fkey; Type: FK CONSTRAINT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.orgs
ADD CONSTRAINT orgs_parent_org_id_fkey FOREIGN KEY (parent_org_id) REFERENCES meta.orgs(id);
--
-- TOC entry 3234 (class 2606 OID 39686)
-- Name: orgs orgs_type_id_fkey; Type: FK CONSTRAINT; Schema: meta; Owner: a11ydata
--
ALTER TABLE ONLY meta.orgs
ADD CONSTRAINT orgs_type_id_fkey FOREIGN KEY (type_id) REFERENCES meta.org_types(id);
--
-- TOC entry 3231 (class 2606 OID 39704)
-- Name: items items_fk; Type: FK CONSTRAINT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.items
ADD CONSTRAINT items_fk FOREIGN KEY (scan_id) REFERENCES results.scans(id);
--
-- TOC entry 3232 (class 2606 OID 39640)
-- Name: nodes nodes_fk; Type: FK CONSTRAINT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.nodes
ADD CONSTRAINT nodes_fk FOREIGN KEY (item_id) REFERENCES results.items(id);
--
-- TOC entry 3230 (class 2606 OID 39699)
-- Name: scans scans_fk; Type: FK CONSTRAINT; Schema: results; Owner: a11ydata
--
ALTER TABLE ONLY results.scans
ADD CONSTRAINT scans_fk FOREIGN KEY (domain) REFERENCES meta.domains(domain);
-- Completed on 2023-03-23 19:25:41 EDT
--
-- PostgreSQL database dump complete
--