· 4 years ago · Jul 02, 2021, 02:16 PM
1CREATE TABLE IF NOT EXISTS "person_job_map" (
2 "person_id" TEXT,
3 "job_id" TEXT
4)
5
6INSERT INTO "person_job_map" VALUES
7 ('person-1','job-70'),
8 ('person-2','job-50'),
9 ('person-3','job-95'),
10 ('person-4','job-22'),
11 ('person-5','job-64'),
12 ('person-6','job-74'),
13 ('person-7','job-45'),
14 ('person-8','job-1'),
15 ('person-9','job-23'),
16 ('person-10','job-45'),
17 ('person-11','job-72'),
18 ('person-12','job-97'),
19 ('person-13','job-54'),
20 ('person-14','job-66'),
21 ('person-15','job-95'),
22 ('person-16','job-45'),
23 ('person-17','job-46'),
24 ('person-18','job-44'),
25 ('person-19','job-16'),
26 ('person-20','job-73'),
27 ('person-21','job-7'),
28 ('person-22','job-10'),
29 ('person-23','job-1'),
30 ('person-24','job-33'),
31 ('person-25','job-69'),
32 ('person-26','job-84'),
33 ('person-27','job-7'),
34 ('person-28','job-79'),
35 ('person-29','job-88'),
36 ('person-30','job-46'),
37 ('person-31','job-2'),
38 ('person-32','job-61'),
39 ('person-33','job-99'),
40 ('person-34','job-57'),
41 ('person-35','job-52'),
42 ('person-36','job-59'),
43 ('person-37','job-80'),
44 ('person-38','job-89'),
45 ('person-39','job-1'),
46 ('person-40','job-5'),
47 ('person-41','job-20'),
48 ('person-42','job-79'),
49 ('person-43','job-1'),
50 ('person-44','job-87'),
51 ('person-45','job-2'),
52 ('person-46','job-66'),
53 ('person-47','job-7'),
54 ('person-48','job-10'),
55 ('person-49','job-4'),
56 ('person-50','job-82'),
57 ('person-51','job-60'),
58 ('person-52','job-73'),
59 ('person-53','job-9'),
60 ('person-54','job-61'),
61 ('person-55','job-89'),
62 ('person-56','job-13'),
63 ('person-57','job-26'),
64 ('person-58','job-1'),
65 ('person-59','job-81'),
66 ('person-60','job-95'),
67 ('person-61','job-9'),
68 ('person-62','job-74'),
69 ('person-63','job-86'),
70 ('person-64','job-2'),
71 ('person-65','job-58'),
72 ('person-66','job-80'),
73 ('person-67','job-58'),
74 ('person-68','job-1'),
75 ('person-69','job-63'),
76 ('person-70','job-27'),
77 ('person-71','job-5'),
78 ('person-72','job-42'),
79 ('person-73','job-1'),
80 ('person-74','job-38'),
81 ('person-75','job-78'),
82 ('person-76','job-63'),
83 ('person-77','job-9'),
84 ('person-78','job-37'),
85 ('person-79','job-67'),
86 ('person-80','job-84'),
87 ('person-81','job-42'),
88 ('person-82','job-17'),
89 ('person-83','job-77'),
90 ('person-84','job-38'),
91 ('person-85','job-9'),
92 ('person-86','job-1'),
93 ('person-87','job-23'),
94 ('person-88','job-86'),
95 ('person-89','job-39'),
96 ('person-90','job-1'),
97 ('person-91','job-93'),
98 ('person-92','job-68'),
99 ('person-93','job-75'),
100 ('person-94','job-26'),
101 ('person-95','job-30'),
102 ('person-96','job-44'),
103 ('person-97','job-90'),
104 ('person-98','job-37'),
105 ('person-99','job-56'),
106 ('person-100','job-17'),
107 ('person-101','job-42'),
108 ('person-102','job-23'),
109 ('person-103','job-42'),
110 ('person-104','job-9'),
111 ('person-105','job-1'),
112 ('person-106','job-94'),
113 ('person-107','job-5'),
114 ('person-108','job-1'),
115 ('person-109','job-100'),
116 ('person-110','job-49'),
117 ('person-111','job-59'),
118 ('person-112','job-15'),
119 ('person-113','job-99'),
120 ('person-114','job-80'),
121 ('person-115','job-68'),
122 ('person-116','job-23'),
123 ('person-117','job-1'),
124 ('person-118','job-100'),
125 ('person-119','job-23'),
126 ('person-120','job-60'),
127 ('person-121','job-48'),
128 ('person-122','job-12'),
129 ('person-123','job-57'),
130 ('person-124','job-37'),
131 ('person-125','job-87'),
132 ('person-126','job-5'),
133 ('person-127','job-32'),
134 ('person-128','job-78'),
135 ('person-129','job-21'),
136 ('person-130','job-15'),
137 ('person-131','job-75'),
138 ('person-132','job-79'),
139 ('person-133','job-3'),
140 ('person-134','job-48'),
141 ('person-135','job-46'),
142 ('person-136','job-17'),
143 ('person-137','job-92'),
144 ('person-138','job-2'),
145 ('person-139','job-1'),
146 ('person-140','job-1'),
147 ('person-141','job-1'),
148 ('person-142','job-23'),
149 ('person-143','job-62'),
150 ('person-144','job-85'),
151 ('person-145','job-39'),
152 ('person-146','job-61'),
153 ('person-147','job-23'),
154 ('person-148','job-14'),
155 ('person-149','job-88'),
156 ('person-150','job-31'),
157 ('person-151','job-31'),
158 ('person-152','job-4'),
159 ('person-153','job-17'),
160 ('person-154','job-82'),
161 ('person-155','job-23'),
162 ('person-156','job-74'),
163 ('person-157','job-85'),
164 ('person-158','job-16'),
165 ('person-159','job-95'),
166 ('person-160','job-3'),
167 ('person-161','job-53'),
168 ('person-162','job-34'),
169 ('person-163','job-1'),
170 ('person-164','job-35'),
171 ('person-165','job-95'),
172 ('person-166','job-47'),
173 ('person-167','job-18'),
174 ('person-168','job-20'),
175 ('person-169','job-97'),
176 ('person-170','job-10'),
177 ('person-171','job-16'),
178 ('person-172','job-90'),
179 ('person-173','job-67'),
180 ('person-174','job-2'),
181 ('person-175','job-1'),
182 ('person-176','job-27'),
183 ('person-177','job-47'),
184 ('person-178','job-91'),
185 ('person-179','job-54'),
186 ('person-180','job-82'),
187 ('person-181','job-83'),
188 ('person-182','job-42'),
189 ('person-183','job-22'),
190 ('person-184','job-24'),
191 ('person-185','job-42'),
192 ('person-186','job-1'),
193 ('person-187','job-55'),
194 ('person-188','job-42'),
195 ('person-189','job-1'),
196 ('person-190','job-1'),
197 ('person-191','job-82'),
198 ('person-192','job-47'),
199 ('person-193','job-86'),
200 ('person-194','job-37'),
201 ('person-195','job-24'),
202 ('person-196','job-31'),
203 ('person-197','job-47'),
204 ('person-198','job-83'),
205 ('person-199','job-1'),
206 ('person-200','job-7'),
207 ('person-201','job-88'),
208 ('person-202','job-40'),
209 ('person-203','job-52'),
210 ('person-204','job-86'),
211 ('person-205','job-47'),
212 ('person-206','job-93'),
213 ('person-207','job-48'),
214 ('person-208','job-83'),
215 ('person-209','job-14'),
216 ('person-210','job-13'),
217 ('person-211','job-8'),
218 ('person-212','job-1'),
219 ('person-213','job-25'),
220 ('person-214','job-1'),
221 ('person-215','job-34'),
222 ('person-216','job-26'),
223 ('person-217','job-92'),
224 ('person-218','job-52'),
225 ('person-219','job-10'),
226 ('person-220','job-86'),
227 ('person-221','job-61'),
228 ('person-222','job-72'),
229 ('person-223','job-100'),
230 ('person-224','job-38'),
231 ('person-225','job-56'),
232 ('person-226','job-70'),
233 ('person-227','job-37'),
234 ('person-228','job-1'),
235 ('person-229','job-78'),
236 ('person-230','job-7'),
237 ('person-231','job-2'),
238 ('person-232','job-67'),
239 ('person-233','job-73'),
240 ('person-234','job-73'),
241 ('person-235','job-46'),
242 ('person-236','job-54'),
243 ('person-237','job-7'),
244 ('person-238','job-3'),
245 ('person-239','job-55'),
246 ('person-240','job-2'),
247 ('person-241','job-76'),
248 ('person-242','job-11'),
249 ('person-243','job-74'),
250 ('person-244','job-7'),
251 ('person-245','job-4'),
252 ('person-246','job-36'),
253 ('person-247','job-64'),
254 ('person-248','job-5'),
255 ('person-249','job-3'),
256 ('person-250','job-7')
257
258
259CREATE TABLE IF NOT EXISTS "job" (
260 "id" TEXT,
261 "description" TEXT
262)
263
264INSERT INTO "job" VALUES
265 ('job-1','Paediatric nurse'),
266 ('job-2','Broadcast engineer'),
267 ('job-3','Set designer'),
268 ('job-4','Scientist, marine'),
269 ('job-5','Research officer, trade union'),
270 ('job-6','Broadcast engineer'),
271 ('job-7','Community development worker'),
272 ('job-8','Restaurant manager, fast food'),
273 ('job-9','Physicist, medical'),
274 ('job-10','Secretary/administrator'),
275 ('job-11','Designer, exhibition/display'),
276 ('job-12','Trading standards officer'),
277 ('job-13','Broadcast presenter'),
278 ('job-14','Designer, textile'),
279 ('job-15','Geochemist'),
280 ('job-16','Scientist, research (medical)'),
281 ('job-17','Ceramics designer'),
282 ('job-18','Psychiatrist'),
283 ('job-19','Private music teacher'),
284 ('job-20','Counsellor'),
285 ('job-21','IT trainer'),
286 ('job-22','Automotive engineer'),
287 ('job-23','Operational researcher'),
288 ('job-24','Personal assistant'),
289 ('job-25','Claims inspector/assessor'),
290 ('job-26','Field trials officer'),
291 ('job-27','Primary school teacher'),
292 ('job-28','Trading standards officer'),
293 ('job-29','Communications engineer'),
294 ('job-30','Surveyor, building control'),
295 ('job-31','Oceanographer'),
296 ('job-32','Health service manager'),
297 ('job-33','Engineer, maintenance'),
298 ('job-34','Teacher, music'),
299 ('job-35','Politician''s assistant'),
300 ('job-36','Geneticist, molecular'),
301 ('job-37','Newspaper journalist'),
302 ('job-38','Civil engineer, consulting'),
303 ('job-39','Geneticist, molecular'),
304 ('job-40','Meteorologist'),
305 ('job-41','Local government officer'),
306 ('job-42','Oceanographer'),
307 ('job-43','Emergency planning/management officer'),
308 ('job-44','Chiropodist'),
309 ('job-45','Immunologist'),
310 ('job-46','Newspaper journalist'),
311 ('job-47','Technical brewer'),
312 ('job-48','Web designer'),
313 ('job-49','Radiographer, diagnostic'),
314 ('job-50','Purchasing manager'),
315 ('job-51','Equality and diversity officer'),
316 ('job-52','Public house manager'),
317 ('job-53','Quantity surveyor'),
318 ('job-54','Applications developer'),
319 ('job-55','Radio broadcast assistant'),
320 ('job-56','Multimedia specialist'),
321 ('job-57','Physiological scientist'),
322 ('job-58','Clinical molecular geneticist'),
323 ('job-59','Passenger transport manager'),
324 ('job-60','Designer, graphic'),
325 ('job-61','Museum education officer'),
326 ('job-62','Television camera operator'),
327 ('job-63','Cytogeneticist'),
328 ('job-64','Engineer, maintenance (IT)'),
329 ('job-65','Licensed conveyancer'),
330 ('job-66','Arboriculturist'),
331 ('job-67','Medical sales representative'),
332 ('job-68','Dealer'),
333 ('job-69','Air traffic controller'),
334 ('job-70','Presenter, broadcasting'),
335 ('job-71','Financial adviser'),
336 ('job-72','Lexicographer'),
337 ('job-73','Risk analyst'),
338 ('job-74','Risk analyst'),
339 ('job-75','Engineer, drilling'),
340 ('job-76','Pharmacist, hospital'),
341 ('job-77','Data processing manager'),
342 ('job-78','Hydrologist'),
343 ('job-79','Site engineer'),
344 ('job-80','Programmer, applications'),
345 ('job-81','Neurosurgeon'),
346 ('job-82','Haematologist'),
347 ('job-83','Production designer, theatre/television/film'),
348 ('job-84','Broadcast presenter'),
349 ('job-85','Adult guidance worker'),
350 ('job-86','Programmer, applications'),
351 ('job-87','Advice worker'),
352 ('job-88','Landscape architect'),
353 ('job-89','Dispensing optician'),
354 ('job-90','Designer, exhibition/display'),
355 ('job-91','Historic buildings inspector/conservation officer'),
356 ('job-92','Risk analyst'),
357 ('job-93','Designer, furniture'),
358 ('job-94','Music therapist'),
359 ('job-95','Engineer, chemical'),
360 ('job-96','Merchandiser, retail'),
361 ('job-97','Sports administrator'),
362 ('job-98','Immunologist'),
363 ('job-99','Newspaper journalist'),
364 ('job-100','Broadcast journalist')