-
Notifications
You must be signed in to change notification settings - Fork 0
/
DataGeneration_erp.sql
651 lines (633 loc) · 40.8 KB
/
DataGeneration_erp.sql
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
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
--
-- Script was generated by Devart dbForge Data Generator for MySQL, Version 2.2.33.0
-- Product Home Page: http://www.devart.com/dbforge/mysql/data-generator
-- Script date 12/29/2019 9:37:06 PM
-- Target server version: 5.5.5-10.1.37-MariaDB
-- Target connection string: User Id=root;Host=localhost;Database=erp;Character Set=utf8
--
SET NAMES 'utf8';
USE erp;
--
-- Delete data from the table 'pay_grade_leave'
--
TRUNCATE TABLE pay_grade_leave;
--
-- Delete data from the table 'leave'
--
TRUNCATE TABLE `leave`;
--
-- Delete data from the table 'employee_email'
--
TRUNCATE TABLE employee_email;
--
-- Delete data from the table 'employee_custom_attributes'
--
TRUNCATE TABLE employee_custom_attributes;
--
-- Delete data from the table 'employee_contact_no'
--
TRUNCATE TABLE employee_contact_no;
--
-- Delete data from the table 'emergency_contact'
--
TRUNCATE TABLE emergency_contact;
--
-- Delete data from the table 'dependent'
--
TRUNCATE TABLE dependent;
--
-- Delete data from the table 'employee'
--
DELETE FROM employee;
--
-- Delete data from the table 'pay_grade'
--
DELETE FROM pay_grade;
--
-- Delete data from the table 'organization_info'
--
TRUNCATE TABLE organization_info;
--
-- Delete data from the table 'leave_type'
--
DELETE FROM leave_type;
--
-- Delete data from the table 'job_title'
--
DELETE FROM job_title;
--
-- Delete data from the table 'employment_status'
--
DELETE FROM employment_status;
--
-- Delete data from the table 'department'
--
DELETE FROM department;
--
-- Delete data from the table 'custom_attribute'
--
DELETE FROM custom_attribute;
--
-- Inserting data into table custom_attribute
--
BEGIN;
INSERT INTO custom_attribute(attribute) VALUES
('Google Adds'),
('Internet'),
('Direct'),
('Email'),
('Referral'),
('Newspaper'),
('Word of mouth'),
('Add.Words'),
('TV Adds'),
('Bing Adds');
--
-- Inserting data into table department
--
INSERT INTO department(dept_name) VALUES
('Executive'),
('Research and Development'),
('Facilities'),
('Manufacturing'),
('Customer Support'),
('Information Technology'),
('Marketing'),
('Sales'),
('Operations'),
('Consulting'),
('Finance'),
('Human Resources');
--
-- Inserting data into table employment_status
--
INSERT INTO employment_status(employment_status) VALUES
('Freelance'),
('Trainee'),
('Permanent-FullTime'),
('Permanent-PartTime'),
('Contract-PartTime'),
('Contract-FullTime');
--
-- Inserting data into table job_title
--
INSERT INTO job_title(job_title, access_level) VALUES
('Director of Manufacturing', 'L2'),
('Technical Specialist', 'L2'),
('Lead Engineer', 'L1'),
('Director of Customer Support', 'L2'),
('Communication Engineer', 'L2'),
('Director of Information Technology', 'L1'),
('Product Manager', 'L1'),
('Developer/Programmer', 'L2'),
('Development Manager', 'L2'),
('Technical Manager', 'L2'),
('Communication Analyst', 'L1'),
('Secretary', 'L2'),
('Vice President', 'L2'),
('Business Analyst', 'L2'),
('Technician', 'L1'),
('Specialist', 'L1'),
('Chief Technology Officer', 'L1'),
('Business Coordinator', 'L2'),
('Training Manager', 'L1'),
('Application Engineer', 'L1'),
('Technical Manager', 'L1'),
('Marketing Manager', 'L1'),
('Support Engineer', 'L1'),
('Assistant Vice President', 'L2'),
('Branch Manager', 'L2'),
('QA Engineer', 'L1'),
('Chief Financial Officer', 'L1'),
('Service Engineer', 'L1'),
('Senior Specialist', 'L1'),
('Purchasing Agent', 'L1'),
('Finance Controller', 'L1'),
('Senior Designer', 'L2'),
('Project Leader', 'L1'),
('Controller', 'L1'),
('Assistant', 'L2'),
('Chief Information Officer', 'L2'),
('Senior Accountant', 'L2'),
('Senior Consultant', 'L2'),
('Director of Consulting', 'L1'),
('Revenue Manager', 'L2'),
('Board Member', 'L1'),
('Communication Manager', 'L1'),
('Technical Director', 'L2'),
('Regional Manager', 'L1'),
('Support Manager', 'L1'),
('Contract Manager', 'L2'),
('Network Administrator', 'L2'),
('Development Engineer', 'L1'),
('Communication Consultant', 'L2'),
('Logistics Manager', 'L2');
--
-- Inserting data into table leave_type
--
INSERT INTO leave_type(leave_type) VALUES
('No-Pay'),
('Annual'),
('Casual'),
('Sick');
--
-- Inserting data into table organization_info
--
INSERT INTO organization_info(`key`, value) VALUES
('Nyx', 'Hvt'),
('Ojie', 'Add'),
('Wboeip', 'Kl'),
('Wy', 'Cic'),
('Zpj', 'Tomngm'),
('Knvfggg', 'Sfmjaba'),
('Gy', 'Mj'),
('Xppuuceufgsxq', 'Lc'),
('Yk', 'Hb'),
('Yhqoq', 'Cdsgaac'),
('Lbcf', 'Xx'),
('Lg', 'Hkcrvvj'),
('Dsnjeer', 'Gdy'),
('Rgub', 'Mlbwnpo'),
('Xmocdbap', 'Efgaiw'),
('Dlxetrdc', 'Kqy'),
('Diqwq', 'Aazpo'),
('Ghhvr', 'Qv'),
('Dno', 'Kffcdasuuatbprjhgz'),
('Gwjyu', 'Lq'),
('Cdokgw', 'Mbwj'),
('Ij', 'Ralryry'),
('Onay', 'Bxbs'),
('Ydw', 'Smxwoashotiyspa'),
('Lm', 'Uxt'),
('Anu', 'Vyr'),
('Svfs', 'Kql'),
('Ctlnmrjj', 'Igqabrool'),
('Xf', 'Vldct'),
('Jmk', 'Sa'),
('Okvdivm', 'Ue'),
('Uyrea', 'Sa'),
('Pjljtsppdvq', 'Bf'),
('Fju', 'Tw'),
('Gn', 'Hrs'),
('Zxztvilu', 'Zbvfzjqlswces'),
('Jxbt', 'Zg'),
('Wdmcfhql', 'Uuaakwh'),
('Wzv', 'Pi'),
('Bqlo', 'Rt'),
('Mcfh', 'Bx'),
('Zmtbi', 'Kwr'),
('Gyo', 'Corkto'),
('Rs', 'Vazvgqozte'),
('Osmlx', 'Zrgh'),
('Yynf', 'Zsqq'),
('Qi', 'Qdyu'),
('Gfq', 'Ssbm'),
('Vxthns', 'Xye'),
('Orklc', 'Zoez');
--
-- Inserting data into table pay_grade
--
INSERT INTO pay_grade(pay_grade) VALUES
('Grade-1'),
('Grade-2'),
('Grade-4'),
('Grade-3');
--
-- Inserting data into table employee
--
INSERT INTO employee(employee_id, first_name, last_name, nic, addr_house_no, addr_line_1, addr_line_2, addr_city, dob, marital_status, employment_status, active_status, job_title, dept_name, pay_grade, supervisor_id) VALUES
('84641IS2VLEKG3D2', 'Trent', 'Hanes', '192123281252', '382', '7th FL', 'Flats 3-8', 'Eleva', '1981-02-20', 'Married', 'Permanent-FullTime', 1, 'Technical Manager', 'Research and Development', 'Grade-1', '4N96X1273H396KO'),
('W5ME5222K4542M1S', 'Camila', 'Evers', '202797495372', '300', '60th FL', 'Railway Arch 5', 'Lonoke', '1969-03-23', 'Married', 'Freelance', 1, 'Technical Manager', 'Executive', 'Grade-3', 'J736P11745XC4L2'),
('4N96X1273H396KO7', 'Ada', 'Haney', '196961726735', '150', '70th Floor', 'Suite 4', 'Zuni', '2000-01-30', 'Single', 'Permanent-FullTime', 1, 'Communication Analyst', 'Human Resources', 'Grade-1', '62B395L514SV47T'),
('1T7E55W3J182SKW7', 'Kim', 'Herbert', '205425127232', '81', '54th FL', 'Unit 2-7, First Floo', 'Porterville', '1979-09-28', 'Single', 'Permanent-FullTime', 1, 'Development Engineer', 'Facilities', 'Grade-2', 'Z6B527Y4PPRXLR8'),
('4KC15W1UYB1BY214', 'Jonas', 'Ewing', '204381543285', '503', '57th FL', 'Flat 4', 'Houma', '1986-04-20', 'Married', 'Trainee', 1, 'Assistant', 'Executive', 'Grade-3', '3Y5N8BZSOVN6762'),
('4QQ7G1A6OSKTED6P', 'Jazmin', 'Shelley', '202532233395', '5', '56th Floor', 'Railway Arch 3', 'Block Island', '1979-04-12', 'Married', 'Freelance', 1, 'Assistant', 'Human Resources', 'Grade-2', 'NDJM378I15P3DO3'),
('LO5LBEA657JU5N53', 'Christen', 'Vallejo', '203766256424', '575', '5th Floor', 'Suite 56', 'Lonsdale', '1974-03-28', 'Married', 'Trainee', 0, 'Product Manager', 'Human Resources', 'Grade-4', 'NDJM378I15P3DO3'),
('GPEQJ44M3AUG2JEB', 'Maragaret', 'Shelton', '204748847159', '4', '91th FL', 'Railway Arch 8', 'Hackettstown', '1969-01-04', 'Single', 'Freelance', 0, 'Communication Engineer', 'Consulting', 'Grade-1', '78MXZEV1V21T3TJ'),
('22K546KA3941FL24', 'Norbert', 'Clements', '199335411242', '3', '5th FL', 'Railway Arch 8', 'Coloma', '1995-02-18', 'Married', 'Trainee', 1, 'Senior Specialist', 'Human Resources', 'Grade-1', 'NDJM378I15P3DO3'),
('3C1QR8BVP2759SM9', 'Abbie', 'Hankins', '205347262458', '533', '8th Floor', 'Railway Arch 80', 'Elfers', '1969-01-01', 'Single', 'Freelance', 1, 'Business Analyst', 'Manufacturing', 'Grade-4', 'Z12P9717PZ582XB'),
('9T989FXQWAC4HF86', 'Melvin', 'Larson', '205826477547', '658', '80th Floor', 'Railway Arch 20', 'Haddam', '1998-10-21', 'Married', 'Freelance', 0, 'Finance Controller', 'Consulting', 'Grade-4', 'I71OBPCY22W6UXA'),
('68886RHCW4CAW548', 'Sebastian', 'Blackwood', '198953513973', '042', '77th FL', 'Arch 7', 'Blomkest', '1969-01-06', 'Married', 'Contract-PartTime', 1, 'Chief Information Officer', 'Research and Development', 'Grade-1', 'L6TJZD8NV3M7L66'),
('J736P11745XC4L26', 'Graig', 'Heredia', '204897177253', '1', '65th FL', 'Flats 4-6', 'Elgin', '1985-01-01', 'Married', 'Permanent-PartTime', 1, 'Vice President', 'Consulting', 'Grade-4', '68886RHCW4CAW54'),
('E3N43B9724H3QN82', 'Korey', 'Ezell', '203468945243', '8', '8th FL', 'Unit 4-9', 'Colome', '1990-06-14', 'Single', 'Permanent-FullTime', 1, 'Technical Manager', 'Finance', 'Grade-3', 'NDJM378I15P3DO3'),
('IF9L1MOLI6P6KW3L', 'Zackary', 'Clemmons', '191886894677', '40', '8th Floor', 'Railway Arch 23C', 'Haddon Heights', '1975-11-08', 'Single', 'Trainee', 1, 'Technical Manager', 'Facilities', 'Grade-3', 'L6TJZD8NV3M7L66'),
('HPW5T88SD9466BLC', 'Adah', 'Blaine', '205418678498', '8', '65th FL', 'Suite 19', 'Newburg', '1969-01-04', 'Married', 'Freelance', 1, 'Director of Manufacturing', 'Customer Support', 'Grade-1', 'LO5LBEA657JU5N5'),
('8E9OC1RHN32B66D2', 'Scott', 'Clemons', '208774972359', '615', '57th Floor', 'Railway Arch 45C', 'Porthill', '1998-09-10', 'Single', 'Contract-PartTime', 1, 'Finance Controller', 'Operations', 'Grade-1', '1KX15NHS858JB6A'),
('Z11Y39Q4NZ352XV9', 'Millie', 'Blair', '202474851873', '2', '94th Floor', 'Railway Arch 97', 'Elida', '1969-02-04', 'Married', 'Permanent-PartTime', 1, 'Senior Designer', 'Human Resources', 'Grade-2', '1T7E55W3J182SKW'),
('936JXYL4DZ8361ZF', 'Spencer', 'Valles', '209115347523', '80', 'First Security Build', 'Flats 3-6', 'Williams', '1984-05-23', 'Married', 'Contract-PartTime', 0, 'Application Engineer', 'Information Technology', 'Grade-4', '1KX15NHS858JB6A'),
('L6TJZD8NV3M7L663', 'Allen', 'Shepard', '206873648565', '900', '6th FL', 'Railway Arch 77', 'Housatonic', '1997-04-10', 'Married', 'Permanent-FullTime', 1, 'Communication Manager', 'Information Technology', 'Grade-1', 'W5ME5222K4542M1'),
('Z12P9717PZ582XBA', 'Adalberto', 'Larue', '195726889741', '435', '69th FL', 'Railway Arch 71', 'Loogootee', '1969-02-07', 'Married', 'Freelance', 1, 'Business Coordinator', 'Consulting', 'Grade-3', 'NDJM378I15P3DO3'),
('JZ71BQ9BQ6DSITLI', 'Erwin', 'Mcclure', '207575434684', '513', '88th Floor', 'Arch 23', 'Bloomdale', '1990-10-02', 'Single', 'Freelance', 1, 'Director of Manufacturing', 'Finance', 'Grade-4', '7LE8G725L9LQP73'),
('1KX15NHS858JB6AI', 'Cleveland', 'Hanks', '205961353665', '494', '6th Floor', 'Flat 5', 'Suttons Bay', '1988-12-08', 'Single', 'Permanent-PartTime', 1, 'Development Engineer', 'Executive', 'Grade-3', '9665C2IB4K732V6'),
('O4IOQ99O98112QSY', 'Myrtis', 'Cleveland', '203515876835', '21', 'Bartlett Bldg', 'Railway Arch 99', 'Haddonfield', '1980-04-12', 'Single', 'Permanent-FullTime', 1, 'Regional Manager', 'Executive', 'Grade-3', 'LO5LBEA657JU5N5'),
('61H9S7T58G51773M', 'Ambrose', 'Herman', '192832299871', '463', '67th Floor', 'Railway Arch 7', 'House Springs', '1981-08-27', 'Married', 'Freelance', 1, 'Senior Accountant', 'Sales', 'Grade-2', 'NDJM378I15P3DO3'),
('3TD5KS12246CQ46H', 'Consuelo', 'Faber', '205988222615', '660', '9th Floor', 'Flats 1-7', 'Williams Bay', '1969-01-10', 'Single', 'Permanent-PartTime', 1, 'Director of Customer Support', 'Consulting', 'Grade-4', 'GG7IQ4WH8692H4M'),
('B52R9SHW9F8X9XZR', 'Mitchell', 'Lash', '204145437349', '561', '8th Floor', 'Railway Arch 96C', 'Colon', '1989-10-09', 'Married', 'Permanent-FullTime', 1, 'Controller', 'Information Technology', 'Grade-4', '4B58H48K9XPQFC6'),
('NDJM378I15P3DO32', 'Myron', 'Van', '191493657139', '754', '53th FL', 'Railway Arch 86B', 'Newburgh', '1969-02-21', 'Divorced', 'Contract-PartTime', 1, 'QA Engineer', 'Manufacturing', 'Grade-1', 'NDJM378I15P3DO3'),
('424S67R67E27T674', 'Miki', 'Hermann', '209256418853', '408', '7th FL', 'Railway Arch 32B', 'Lookeba', '1971-08-08', 'Divorced', 'Trainee', 1, 'Director of Consulting', 'Consulting', 'Grade-1', '1G11JXS77ZUD362'),
('4B58H48K9XPQFC6M', 'Alina', 'Pannell', '207612324475', '431', '70th FL', 'Railway Arch 50B', 'Bloomer', '1978-11-21', 'Single', 'Permanent-FullTime', 1, 'Senior Accountant', 'Executive', 'Grade-2', '4B58H48K9XPQFC6'),
('I7PV45RF6262MWV5', 'Celina', 'Hanley', '209167842975', '5', '71th FL', 'Arch 1', 'Houston', '1974-09-11', 'Single', 'Contract-FullTime', 1, 'Application Engineer', 'Manufacturing', 'Grade-2', 'NDJM378I15P3DO3'),
('9665C2IB4K732V69', 'Claude', 'Blais', '209134724378', '36', '72th FL', 'Railway Arch 4', 'Eliot', '1972-10-29', 'Single', 'Contract-PartTime', 1, 'Director of Manufacturing', 'Finance', 'Grade-4', '4KC15W1UYB1BY21'),
('62B395L514SV47T9', 'Aiko', 'Lassiter', '193185847734', '573', 'Apartment 570', 'Railway Arch 2', 'Portland', '1990-04-26', 'Single', 'Contract-FullTime', 0, 'Director of Manufacturing', 'Human Resources', 'Grade-1', 'LH369XG252S83B9'),
('G27568IB58M3G4C3', 'Allan', 'Fagan', '203835638145', '9', 'STE 214', 'Railway Arch 9', 'Colonia', '1969-01-03', 'Single', 'Contract-PartTime', 1, 'Controller', 'Information Technology', 'Grade-4', 'Z11Y39Q4NZ352XV'),
('15R65GD75R3N5CTE', 'Alvin', 'Hernandez', '197453642452', '619', '9th FL', 'Railway Arch 4', 'Bloomfield', '1996-01-17', 'Married', 'Permanent-FullTime', 1, 'Product Manager', 'Consulting', 'Grade-3', '8E9OC1RHN32B66D'),
('LH369XG252S83B9Z', 'Tilda', 'Hanlon', '192771695882', '727', '6th FL', 'Railway Arch 90', 'Colonial Beach', '1998-03-09', 'Married', 'Permanent-PartTime', 1, 'Product Manager', 'Consulting', 'Grade-4', '22K546KA3941FL2'),
('I71OBPCY22W6UXAN', 'Ada', 'Clevenger', '194942786568', '751', '52th FL', 'Railway Arch 5', 'Bloomfield Hills', '1970-11-15', 'Single', 'Permanent-PartTime', 1, 'Contract Manager', 'Operations', 'Grade-1', '3TD5KS12246CQ46'),
('3Y5N8BZSOVN6762V', 'Jerold', 'Fahey', '206189692283', '627', '84th Floor', 'Unit 31-47', 'Newbury', '1988-08-09', 'Married', 'Contract-PartTime', 1, 'Business Coordinator', 'Consulting', 'Grade-2', '4KC15W1UYB1BY21'),
('Z6B527Y4PPRXLR89', 'Donnie', 'Hanna', '208969167197', '435', '81th FL', 'Flats 1-7', 'Portola', '1997-10-26', 'Divorced', 'Permanent-PartTime', 0, 'Development Manager', 'Information Technology', 'Grade-3', 'I7PV45RF6262MWV'),
('1G11JXS77ZUD362Z', 'Delmer', 'Blake', '202172666764', '3', '8th FL', 'Railway Arch 43', 'Colonial Heights', '2000-10-30', 'Married', 'Permanent-FullTime', 1, 'Technician', 'Information Technology', 'Grade-2', 'OOPH853V758R6X3'),
('6ZP9897561152PQI', 'Jacqulyn', 'Shephard', '197723161792', '2', '83th Floor', 'Railway Arch 9', 'Suwanee', '1969-01-06', 'Single', 'Trainee', 1, 'Training Manager', 'Consulting', 'Grade-4', 'IF9L1MOLI6P6KW3'),
('T43P3YU3Y1RW6E7V', 'Suzi', 'Fain', '204819782392', '31', '7th Floor', 'Unit 32-36, Ground F', 'Newbury Park', '1970-10-06', 'Single', 'Permanent-PartTime', 1, 'Technical Manager', 'Consulting', 'Grade-1', 'L6TJZD8NV3M7L66'),
('GG7IQ4WH8692H4M7', 'Jamaal', 'Mccollum', '201126623886', '53', '7th FL', 'Arch 90', 'Portola Valley', '1970-05-11', 'Single', 'Permanent-FullTime', 1, 'Lead Engineer', 'Manufacturing', 'Grade-2', 'RQMJ9ZMYM8M4LM7'),
('7F9H619F7X7F4PIR', 'Zetta', 'Hannah', '202551488647', '359', '45th FL', 'Suite 2', 'Newburyport', '1969-01-14', 'Married', 'Contract-FullTime', 1, 'Chief Information Officer', 'Customer Support', 'Grade-3', '3TD5KS12246CQ46'),
('OOPH853V758R6X34', 'Adolph', 'Vanburen', '206269722761', '5', '62th FL', 'Unit 23-39, Level 2', 'Lookout', '1981-07-08', 'Married', 'Trainee', 1, 'Finance Controller', 'Customer Support', 'Grade-2', 'FV537R9Z18HG8R2'),
('78MXZEV1V21T3TJ3', 'Deandre', 'Fairbanks', '198499736168', '302', '46th FL', 'Unit 2-9', 'Houtzdale', '1980-06-08', 'Married', 'Contract-FullTime', 1, 'Marketing Manager', 'Human Resources', 'Grade-3', 'W5ME5222K4542M1'),
('86B6895497GRDG89', 'Holli', 'Click', '191517132139', '01', '68th Floor', 'Railway Arch 3', 'Hadley', '1980-09-06', 'Married', 'Permanent-PartTime', 1, 'Finance Controller', 'Operations', 'Grade-1', 'G27568IB58M3G4C'),
('7LE8G725L9LQP734', 'Santo', 'Blakely', '206349399439', '6', '6th Floor', 'Railway Arch 95A', 'Elizabeth', '1992-10-03', 'Single', 'Contract-PartTime', 1, 'Regional Manager', 'Information Technology', 'Grade-1', 'G27568IB58M3G4C'),
('RQMJ9ZMYM8M4LM76', 'Omega', 'Shepherd', '201669197998', '728', '9th Floor', 'Railway Arch 7', 'Lookout Mountain', '1983-04-07', 'Married', 'Contract-PartTime', 1, 'Communication Engineer', 'Research and Development', 'Grade-3', 'OOPH853V758R6X3'),
('FV537R9Z18HG8R2Q', 'Adolfo', 'Vance', '198312154521', '3', '4th Floor', 'Unit 41-46, First Fl', 'Hagerman', '1976-07-29', 'Married', 'Contract-FullTime', 1, 'Director of Manufacturing', 'Facilities', 'Grade-3', 'T43P3YU3Y1RW6E7');
--
-- Inserting data into table dependent
--
INSERT INTO dependent(nic, employee_id, first_name, last_name, relationship, addr_house_no, addr_line_1, addr_line_2, addr_city, contact_no, email) VALUES
('196662242286', '86B6895497GRDG89', 'Catherina', 'Franklin', 'Son', '621', '9th FL', 'Railway Arch 8', 'Evarts', '116-5494', 'Jerold_Overstreet872@example.com'),
('207366627371', '22K546KA3941FL24', 'Emilio', 'Houser', 'Father', '975', '77th Floor', 'Railway Arch 1', 'Zuni', '248-0473', 'ArndtY74@nowhere.com'),
('206961199742', 'Z11Y39Q4NZ352XV9', 'Kenneth', 'Mccracken', 'Mother', '112', '3rd Floor', 'Suite 1', 'Hayes', '903-6769', 'Abney3@nowhere.com'),
('205729965118', '1T7E55W3J182SKW7', 'Carmelina', 'Swenson', 'Mother', '247', '4th FL', 'Railway Arch 24', 'Le Mars', '729-4206', 'CharissaJSchmid55@example.com'),
('198737755476', 'NDJM378I15P3DO32', 'Pamila', 'Parish', 'Daughter', '050', '257 Towers Building', 'Railway Arch 7', 'Rio Hondo', '225-0832', 'zhmjzjpe.wssz@nowhere.com'),
('194326991971', 'FV537R9Z18HG8R2Q', 'Allen', 'Yarbrough', 'Father', '21', '51th FL', 'Railway Arch 68B', 'Wildomar', '631-5532', 'Velasquez2@nowhere.com'),
('208983428542', 'OOPH853V758R6X34', 'Tobias', 'Littlejohn', 'Mother', '4', '72th Floor', 'Railway Arch 97A', 'Surrey', '921-2095', 'Cushman@nowhere.com'),
('192598782869', '7LE8G725L9LQP734', 'Adriana', 'Houston', 'Daughter', '8', '8th FL', 'Railway Arch 99', 'Eveleth', '081-1355', 'Schneider@example.com'),
('192746264161', '78MXZEV1V21T3TJ3', 'Rachell', 'Chong', 'Father', '46', 'Plaza Building', 'Arch 5', 'Olive Hill', '122-6182', 'cqkx89@nowhere.com'),
('203297538742', '1KX15NHS858JB6AI', 'Lorrine', 'Littleton', 'Son', '5', '75th Floor', 'Railway Arch 7', 'Berkeley Springs', '800-1451', 'King@example.com'),
('205263916126', 'J736P11745XC4L26', 'Abel', 'Howard', 'Mother', '04', '7th FL', 'Railway Arch 3', 'Wildrose', '569-5773', 'AmosTijerina48@example.com'),
('197961778136', '936JXYL4DZ8361ZF', 'Adam', 'Lively', 'Other', '514', '8th Floor', 'Railway Arch 7', 'Hayes Center', '036-3069', 'Martino@example.com'),
('194599313355', 'T43P3YU3Y1RW6E7V', 'Weston', 'Howe', 'Other', '038', '6th Floor', 'Railway Arch 7B', 'Clarksdale', '014-6668', 'Abbott@example.com'),
('197848137744', 'E3N43B9724H3QN82', 'Freddie', 'Best', 'Father', '4', '69th FL', 'Railway Arch 6', 'Rio Linda', '663-9257', 'BradleyX.Short89@example.com'),
('199922934155', 'L6TJZD8NV3M7L663', 'Harry', 'Mccrary', 'Father', '858', '62th FL', 'Railway Arch 6C', 'Oliver Springs', '576-3465', 'ksvr43@example.com'),
('205241616552', 'RQMJ9ZMYM8M4LM76', 'Jackson', 'Chow', 'Daughter', '823', '6th Floor', 'Railway Arch 4', 'Berkley', '554-7660', 'rsvme0@example.com'),
('198916211789', 'IF9L1MOLI6P6KW3L', 'Kareem', 'Swift', 'Daughter', '725', '4th Floor', 'Railway Arch 3', 'Rio Oso', '213-2789', 'RaisaBooker@example.com'),
('192527249312', 'I71OBPCY22W6UXAN', 'Kimiko', 'Culpepper', 'Father', '84', '4th Floor', 'Flat 12', 'Moose Lake', '082-1926', 'ShakitaBlackmon@example.com'),
('205113353114', 'GG7IQ4WH8692H4M7', 'Charlene', 'Franks', 'Father', '7', '5th FL', 'Railway Arch 69', 'Le Roy', '276-1734', 'Guzman698@example.com'),
('199489685186', 'Z12P9717PZ582XBA', 'Vania', 'Culver', 'Other', '963', '3rd FL', 'Unit 34-39, Ground F', 'Olivet', '078-3755', 'CyrilCrawford372@example.com'),
('204951813594', '424S67R67E27T674', 'Isaac', 'Yates', 'Mother', '389', '8th FL', 'Flats A-E', 'Surry', '836-1449', 'obzfhvfe.dkgluf@example.com'),
('192145323949', '3Y5N8BZSOVN6762V', 'Bev', 'Livingston', 'Daughter', '4', '5th FL', 'Flats 3-7', 'Clarkson', '464-7096', 'JacquelyneCheek789@example.com'),
('205348426636', '3C1QR8BVP2759SM9', 'Etha', 'Swisher', 'Mother', '2', '42th FL', 'Railway Arch 5', 'Evensville', '692-8391', 'Abbott@example.com'),
('195892237487', 'HPW5T88SD9466BLC', 'Allen', 'Betancourt', 'Mother', '985', '7th Floor', 'Railway Arch 83C', 'Mooseheart', '739-6193', 'MargaritoUAugust@nowhere.com'),
('207215859577', '4KC15W1UYB1BY214', 'Randal', 'Christensen', 'Daughter', '8', 'APT 993', 'Flat 1', 'Berkshire', '750-1955', 'Chaya_O.Abel751@nowhere.com'),
('206516619476', '9T989FXQWAC4HF86', 'Thresa', 'Bethea', 'Mother', '29', '7th FL', 'Suite 63', 'Hayesville', '405-4949', 'Nanette_Marble@example.com'),
('192189822715', 'O4IOQ99O98112QSY', 'Eric', 'Howell', 'Son', '9', '5th Floor', 'Arch 1', 'Wildwood', '649-1062', 'ValarieRuby@nowhere.com'),
('206612285745', '4B58H48K9XPQFC6M', 'Sandy', 'Yazzie', 'Daughter', '1', '7th Floor', 'Flats 4-6', 'Rio Rancho', '944-8255', 'Leigh_Saucedo429@example.com'),
('201887467276', '61H9S7T58G51773M', 'Bradly', 'Christenson', 'Other', '634', '97th FL', 'Flat 66', 'Clarkston', '232-8150', 'Henry18@example.com'),
('204179572156', 'JZ71BQ9BQ6DSITLI', 'Abigail', 'Bethel', 'Other', '99', '8th Floor', 'Railway Arch 2C', 'Everest', '170-1826', 'ChantelleAcevedo82@example.com'),
('202768376649', '7F9H619F7X7F4PIR', 'Reggie', 'Frantz', 'Father', '9', '4th Floor', 'Railway Arch 1', 'Susanville', '151-4100', 'AdrianYanez291@example.com'),
('199117853488', '4QQ7G1A6OSKTED6P', 'Tommy', 'Lloyd', 'Father', '03', '6th FL', 'Suite 76', 'Olivia', '200-1822', 'Christinia.Pritchard9@nowhere.com'),
('208515832816', 'I7PV45RF6262MWV5', 'Nicolle', 'Switzer', 'Father', '35', '61th FL', 'Suite 29', 'Wilkes Barre', '057-3911', 'Marvel.Knott3@nowhere.com'),
('194672471939', 'Z6B527Y4PPRXLR89', 'Laurence', 'Christian', 'Father', '629', '48th Floor', 'Suite 2', 'Le Sueur', '523-0369', 'Fitzgerald@example.com'),
('201833559863', '3TD5KS12246CQ46H', 'Keely', 'Cummings', 'Son', '053', '6th FL', 'Railway Arch 81B', 'Susquehanna', '227-1563', 'NathanaelAntoine@example.com'),
('195129793355', '9665C2IB4K732V69', 'Kenton', 'Betts', 'Other', '561', '6th FL', 'Unit A3A, Ground Flo', 'Rio Rico', '918-9394', 'KristopherAbel@example.com'),
('192249863943', '8E9OC1RHN32B66D2', 'Jessie', 'Park', 'Mother', '946', '9th FL', 'Flats 3-6', 'Olmsted Falls', '126-4481', 'ymtk6233@example.com'),
('207136258486', '68886RHCW4CAW548', 'Ulrike', 'Mccray', 'Mother', '853', '4th FL', 'Flat 3', 'Moosic', '889-1664', 'Herrmann@example.com'),
('208852733124', '84641IS2VLEKG3D2', 'Delbert', 'Howerton', 'Son', '5', '9th FL', 'Railway Arch 2A', 'Lead', '256-7107', 'CarrollWhelan@example.com'),
('195948228829', 'G27568IB58M3G4C3', 'Adela', 'Parker', 'Mother', '866', '91th Floor', 'Railway Arch 5', 'Hayfield', '888-2526', 'Vanesa_Chism314@nowhere.com'),
('208183938446', '1G11JXS77ZUD362Z', 'Christian', 'Ybarra', 'Mother', '0', '80th Floor', 'Railway Arch 9', 'Moosup', '614-6215', 'Tobin55@nowhere.com'),
('206683355573', 'B52R9SHW9F8X9XZR', 'Cheryle', 'Christiansen', 'Son', '104', '95th FL', 'Railway Arch 4', 'Wilkesboro', '800-4565', 'PenaO93@example.com'),
('204879467166', '62B395L514SV47T9', 'Wayne', 'Betz', 'Father', '625', '6th Floor', 'Railway Arch 4', 'Lead Hill', '167-3904', 'Abbott392@example.com'),
('199375675724', 'LO5LBEA657JU5N53', 'Scottie', 'Sykes', 'Daughter', '8', '45th FL', 'Flat 24', 'Rio Verde', '513-7373', 'Gifford7@example.com'),
('206628722992', '15R65GD75R3N5CTE', 'Mariann', 'Locke', 'Daughter', '832', '5th FL', 'Railway Arch 5', 'Olney', '797-6877', 'Christian8@example.com'),
('205168267484', '6ZP9897561152PQI', 'Victoria', 'Mccreary', 'Father', '047', '5th FL', 'Railway Arch 60A', 'Berlin', '424-6951', 'IlanaAdkins@example.com'),
('206345214711', 'LH369XG252S83B9Z', 'Adalberto', 'Christianson', 'Daughter', '2', '6th Floor', 'Suite 7', 'Rio Vista', '940-7230', 'Burchett439@example.com'),
('202712831379', 'W5ME5222K4542M1S', 'Harry', 'Howland', 'Other', '2', '6th FL', 'Arch 8', 'Everett', '614-7692', 'LaticiaEStarkey@nowhere.com'),
('204383728694', 'GPEQJ44M3AUG2JEB', 'Penney', 'Parkinson', 'Daughter', '327', '90th Floor', 'Railway Arch 8', 'Mora', '040-1058', 'Chung_B_Milner@example.com'),
('198622636251', '4N96X1273H396KO7', 'Arthur', 'Beverly', 'Mother', '884', '2nd FL', 'Railway Arch 86', 'Clarksville', '133-3110', 'Tracey_Bunch429@example.com');
--
-- Inserting data into table emergency_contact
--
INSERT INTO emergency_contact(nic, employee_id, name, contact_no) VALUES
('209748696764', '86B6895497GRDG89', 'Hademar Brandt', '968-7333'),
('191289661664', '22K546KA3941FL24', 'Erkhild Abich', '131-5771'),
('194419678878', 'Z11Y39Q4NZ352XV9', 'Gunde Bering', '458-1159'),
('195826976557', '1T7E55W3J182SKW7', 'Christl abst', '381-1336'),
('193942234411', 'NDJM378I15P3DO32', 'Tamija Lerch', '518-5038'),
('201299716688', 'FV537R9Z18HG8R2Q', 'Merwin Stuchenberg', '589-8954'),
('202498213979', 'OOPH853V758R6X34', 'Hadewin Kesselhut', '094-6232'),
('208866987372', '7LE8G725L9LQP734', 'Herward Manstein', '497-7307'),
('206229967435', '78MXZEV1V21T3TJ3', 'Plektrudis Heidemann', '279-5487'),
('208951326589', '1KX15NHS858JB6AI', 'Brisko Kleinermann', '087-0968'),
('195566222537', 'J736P11745XC4L26', 'Thankmar otmann', '521-9449'),
('206938489846', '936JXYL4DZ8361ZF', 'Erwald Felder', '564-8202'),
('195695765454', 'T43P3YU3Y1RW6E7V', 'Vishna Albrecht', '853-9496'),
('199622343669', 'E3N43B9724H3QN82', 'Burkhart Köstlin', '732-7156'),
('198257984179', 'L6TJZD8NV3M7L663', 'Thaddäus Kittel', '792-0479'),
('197771648368', 'RQMJ9ZMYM8M4LM76', 'Otger Bruner', '649-6981'),
('193353286414', 'IF9L1MOLI6P6KW3L', 'Phöbe Kauer', '091-4076'),
('199388287818', 'I71OBPCY22W6UXAN', 'Annalisa Engelke', '157-9998'),
('198632358633', 'GG7IQ4WH8692H4M7', 'Freimuth Heckler', '262-3212'),
('207292319986', 'Z12P9717PZ582XBA', 'Christl Kantor', '893-9379'),
('195385226978', '424S67R67E27T674', 'Purple orgen', '903-9625'),
('193998351846', '3Y5N8BZSOVN6762V', 'Elimar Blumentahl', '062-7348'),
('208828977191', '3C1QR8BVP2759SM9', 'Briska Lichtenstein', '851-9906'),
('208657643415', 'HPW5T88SD9466BLC', 'Winfried John', '968-9310'),
('195698468889', '4KC15W1UYB1BY214', 'Mareke Metzger', '762-4406'),
('209832484559', '9T989FXQWAC4HF86', 'Berenike Eichenwald', '860-6999'),
('203573829237', 'O4IOQ99O98112QSY', 'Rolanda Horkheimer', '350-8177'),
('191266954499', '4B58H48K9XPQFC6M', 'Askanja ockenhaupt', '281-3572'),
('203449753388', '61H9S7T58G51773M', 'Felipa Heitsch', '070-6579'),
('191797481425', 'JZ71BQ9BQ6DSITLI', 'Berngar Glasenap', '801-4021'),
('204675713415', '7F9H619F7X7F4PIR', 'Merisa Zenner', '976-1526'),
('209826691242', '4QQ7G1A6OSKTED6P', 'Neidhart Felder', '852-6050'),
('196782819765', 'I7PV45RF6262MWV5', 'Heico Lamprecht', '026-8104'),
('208813515624', 'Z6B527Y4PPRXLR89', 'Baldur Simmel', '933-9293'),
('202518642454', '3TD5KS12246CQ46H', 'Alejna Stackelberg', '611-8590'),
('196627719517', '9665C2IB4K732V69', 'Marlena Hirschmann', '121-1496'),
('198583924191', '8E9OC1RHN32B66D2', 'Priska Wolf', '279-7946'),
('196466483762', '68886RHCW4CAW548', 'Wilfried Bülow', '433-0574'),
('209179526659', '84641IS2VLEKG3D2', 'Kensie ack', '971-3624'),
('203886219586', 'G27568IB58M3G4C3', 'Seraja Siegel', '405-1899'),
('193593452272', '1G11JXS77ZUD362Z', 'Peider icolai', '067-6637'),
('201879365381', 'B52R9SHW9F8X9XZR', 'Annalise Abich', '526-8014'),
('207438797667', '62B395L514SV47T9', 'Freda Dörner', '144-3838'),
('207728445494', 'LO5LBEA657JU5N53', 'Wigand Abert', '047-1993'),
('204748824777', '15R65GD75R3N5CTE', 'Dörk Drechsler', '782-5588'),
('191339553227', '6ZP9897561152PQI', 'Balian einhold', '178-1141'),
('195584334233', 'LH369XG252S83B9Z', 'Adolina Ulbricht', '826-9243'),
('202625256152', 'W5ME5222K4542M1S', 'Abbeygail chlechter', '288-2903'),
('206385743236', 'GPEQJ44M3AUG2JEB', 'Walther Feldkamp', '731-4399'),
('209561339368', '4N96X1273H396KO7', 'Felipa Dahrendorf', '144-6968');
--
-- Inserting data into table employee_contact_no
--
INSERT INTO employee_contact_no(employee_id, contact_no) VALUES
('86B6895497GRDG89', '370-0353'),
('22K546KA3941FL24', '114-3354'),
('Z11Y39Q4NZ352XV9', '998-2002'),
('1T7E55W3J182SKW7', '454-9619'),
('NDJM378I15P3DO32', '359-6149'),
('FV537R9Z18HG8R2Q', '957-5240'),
('OOPH853V758R6X34', '403-3974'),
('7LE8G725L9LQP734', '669-7824'),
('78MXZEV1V21T3TJ3', '227-8522'),
('1KX15NHS858JB6AI', '553-7687'),
('J736P11745XC4L26', '216-3541'),
('936JXYL4DZ8361ZF', '465-8552'),
('T43P3YU3Y1RW6E7V', '012-0217'),
('E3N43B9724H3QN82', '891-7658'),
('L6TJZD8NV3M7L663', '118-0398'),
('RQMJ9ZMYM8M4LM76', '805-3747'),
('IF9L1MOLI6P6KW3L', '886-9435'),
('I71OBPCY22W6UXAN', '074-1873'),
('GG7IQ4WH8692H4M7', '113-9638'),
('Z12P9717PZ582XBA', '483-5632'),
('424S67R67E27T674', '214-4430'),
('3Y5N8BZSOVN6762V', '234-6593'),
('3C1QR8BVP2759SM9', '325-5419'),
('HPW5T88SD9466BLC', '035-4145'),
('4KC15W1UYB1BY214', '115-6697'),
('9T989FXQWAC4HF86', '536-5066'),
('O4IOQ99O98112QSY', '290-2811'),
('4B58H48K9XPQFC6M', '167-9233'),
('61H9S7T58G51773M', '092-4894'),
('JZ71BQ9BQ6DSITLI', '850-7746'),
('7F9H619F7X7F4PIR', '558-1507'),
('4QQ7G1A6OSKTED6P', '403-1635'),
('I7PV45RF6262MWV5', '499-2172'),
('Z6B527Y4PPRXLR89', '468-1747'),
('3TD5KS12246CQ46H', '507-2550'),
('9665C2IB4K732V69', '296-5606'),
('8E9OC1RHN32B66D2', '049-6701'),
('68886RHCW4CAW548', '499-0083'),
('84641IS2VLEKG3D2', '279-3549'),
('G27568IB58M3G4C3', '896-9475'),
('1G11JXS77ZUD362Z', '465-4132'),
('B52R9SHW9F8X9XZR', '385-9877'),
('62B395L514SV47T9', '217-0859'),
('LO5LBEA657JU5N53', '693-4038'),
('15R65GD75R3N5CTE', '801-8939'),
('6ZP9897561152PQI', '277-1782'),
('LH369XG252S83B9Z', '788-8668'),
('W5ME5222K4542M1S', '721-5108'),
('GPEQJ44M3AUG2JEB', '410-3386'),
('4N96X1273H396KO7', '865-0016');
--
-- Inserting data into table employee_custom_attributes
--
INSERT INTO employee_custom_attributes(employee_id, attribute, value) VALUES
('9T989FXQWAC4HF86', 'Word of mouth', 'Itaque.'),
('22K546KA3941FL24', 'TV Adds', 'Libero.'),
('22K546KA3941FL24', 'Add.Words', 'Soluta eum.'),
('1T7E55W3J182SKW7', 'Email', 'Omnis libero.'),
('3C1QR8BVP2759SM9', 'Add.Words', 'Recusandae.'),
('E3N43B9724H3QN82', 'Bing Adds', 'Et est.'),
('22K546KA3941FL24', 'Referral', 'Nihil aliquam.'),
('68886RHCW4CAW548', 'Add.Words', 'A et.'),
('3C1QR8BVP2759SM9', 'Newspaper', 'Eum.'),
('4KC15W1UYB1BY214', 'Direct', 'Sit.'),
('1T7E55W3J182SKW7', 'Direct', 'Labore.'),
('3C1QR8BVP2759SM9', 'TV Adds', 'Ipsam amet.'),
('4QQ7G1A6OSKTED6P', 'Internet', 'Error aperiam.'),
('4KC15W1UYB1BY214', 'Email', 'Veritatis nisi.'),
('9T989FXQWAC4HF86', 'Bing Adds', 'Voluptate est.'),
('J736P11745XC4L26', 'TV Adds', 'Sit.'),
('4QQ7G1A6OSKTED6P', 'Referral', 'Rerum qui.'),
('3C1QR8BVP2759SM9', 'Word of mouth', 'Perferendis unde.'),
('LO5LBEA657JU5N53', 'Direct', 'Ut animi.'),
('4N96X1273H396KO7', 'Google Adds', 'Qui.'),
('9T989FXQWAC4HF86', 'TV Adds', 'Rerum saepe.'),
('9T989FXQWAC4HF86', 'Add.Words', 'Minima et...'),
('3C1QR8BVP2759SM9', 'Bing Adds', 'Et.'),
('LO5LBEA657JU5N53', 'Newspaper', 'Ut.'),
('4KC15W1UYB1BY214', 'Referral', 'Quo.'),
('W5ME5222K4542M1S', 'Google Adds', 'Ut.'),
('4QQ7G1A6OSKTED6P', 'Email', 'Omnis nobis.'),
('68886RHCW4CAW548', 'Bing Adds', 'Repudiandae esse.'),
('LO5LBEA657JU5N53', 'Referral', 'Et iste.'),
('1T7E55W3J182SKW7', 'Internet', 'Sint.'),
('GPEQJ44M3AUG2JEB', 'Email', 'Sed dignissimos.'),
('4QQ7G1A6OSKTED6P', 'Newspaper', 'Iure ut.'),
('1T7E55W3J182SKW7', 'Google Adds', 'Eligendi expedita.'),
('68886RHCW4CAW548', 'TV Adds', 'Voluptatem.'),
('GPEQJ44M3AUG2JEB', 'Newspaper', 'Laboriosam veniam...'),
('4KC15W1UYB1BY214', 'Internet', 'Quia omnis...'),
('GPEQJ44M3AUG2JEB', 'Word of mouth', 'Sint...'),
('4N96X1273H396KO7', 'Internet', 'Mollitia assumenda.'),
('84641IS2VLEKG3D2', 'Google Adds', 'Beatae est.'),
('LO5LBEA657JU5N53', 'Email', 'Voluptatibus.'),
('J736P11745XC4L26', 'Bing Adds', 'Aspernatur sed...'),
('22K546KA3941FL24', 'Word of mouth', 'Sit fugit.'),
('4QQ7G1A6OSKTED6P', 'Direct', 'Est...'),
('LO5LBEA657JU5N53', 'Word of mouth', 'Nisi cum.'),
('GPEQJ44M3AUG2JEB', 'Referral', 'Voluptatem minima.'),
('4KC15W1UYB1BY214', 'Google Adds', 'Nostrum eum.'),
('22K546KA3941FL24', 'Newspaper', 'Magnam.'),
('W5ME5222K4542M1S', 'Internet', 'Velit...'),
('GPEQJ44M3AUG2JEB', 'Add.Words', 'Veniam veritatis.'),
('4N96X1273H396KO7', 'Direct', 'Natus cupiditate.');
--
-- Inserting data into table employee_email
--
INSERT INTO employee_email(employee_id, email) VALUES
('86B6895497GRDG89', 'Stidham@example.com'),
('22K546KA3941FL24', 'MatthewWeaver@nowhere.com'),
('Z11Y39Q4NZ352XV9', 'Alexander.Handley82@example.com'),
('1T7E55W3J182SKW7', 'MildaMclain423@example.com'),
('NDJM378I15P3DO32', 'Kim49@nowhere.com'),
('FV537R9Z18HG8R2Q', 'Christenson@nowhere.com'),
('OOPH853V758R6X34', 'Byrne@example.com'),
('7LE8G725L9LQP734', 'Abel69@example.com'),
('78MXZEV1V21T3TJ3', 'Afton.Rice421@example.com'),
('1KX15NHS858JB6AI', 'Conrad_Tomlin@example.com'),
('J736P11745XC4L26', 'RefugioDAbel@nowhere.com'),
('936JXYL4DZ8361ZF', 'Ailene_Place215@nowhere.com'),
('T43P3YU3Y1RW6E7V', 'Zarate@example.com'),
('E3N43B9724H3QN82', 'Reuben_Palumbo@example.com'),
('L6TJZD8NV3M7L663', 'Margy.Weddle77@nowhere.com'),
('RQMJ9ZMYM8M4LM76', 'AlexisSoria@example.com'),
('IF9L1MOLI6P6KW3L', 'FranklynMMcgrath@example.com'),
('I71OBPCY22W6UXAN', 'Liane.Burger@nowhere.com'),
('GG7IQ4WH8692H4M7', 'cglk1351@example.com'),
('Z12P9717PZ582XBA', 'BillyAbney@example.com'),
('424S67R67E27T674', 'Meade764@example.com'),
('3Y5N8BZSOVN6762V', 'IsmaelAbel@example.com'),
('3C1QR8BVP2759SM9', 'Luis_Whitfield@example.com'),
('HPW5T88SD9466BLC', 'mzffnfrp_oercays@nowhere.com'),
('4KC15W1UYB1BY214', 'BradSilvia@example.com'),
('9T989FXQWAC4HF86', 'Valentine.Higdon3@nowhere.com'),
('O4IOQ99O98112QSY', 'GavinKHanlon@example.com'),
('4B58H48K9XPQFC6M', 'norxuneu_vgshuq@nowhere.com'),
('61H9S7T58G51773M', 'Simpson@nowhere.com'),
('JZ71BQ9BQ6DSITLI', 'Ridgeway771@example.com'),
('7F9H619F7X7F4PIR', 'RayAmaya@example.com'),
('4QQ7G1A6OSKTED6P', 'BeverlyN16@example.com'),
('I7PV45RF6262MWV5', 'Franks@example.com'),
('Z6B527Y4PPRXLR89', 'xnwikrm7@example.com'),
('3TD5KS12246CQ46H', 'ycdxhpaj_ivto@example.com'),
('9665C2IB4K732V69', 'qjebpn60@nowhere.com'),
('8E9OC1RHN32B66D2', 'KittyCoats92@nowhere.com'),
('68886RHCW4CAW548', 'Shandra.Harder4@nowhere.com'),
('84641IS2VLEKG3D2', 'CarlenaHorner324@example.com'),
('G27568IB58M3G4C3', 'Desirae_Schuster@example.com'),
('1G11JXS77ZUD362Z', 'Levy@example.com'),
('B52R9SHW9F8X9XZR', 'Acker@example.com'),
('62B395L514SV47T9', 'llevh822@example.com'),
('LO5LBEA657JU5N53', 'Windham@example.com'),
('15R65GD75R3N5CTE', 'RosarioCanady462@nowhere.com'),
('6ZP9897561152PQI', 'ArchieFeliciano@example.com'),
('LH369XG252S83B9Z', 'OmerWeber@example.com'),
('W5ME5222K4542M1S', 'Erwin@example.com'),
('GPEQJ44M3AUG2JEB', 'York@example.com'),
('4N96X1273H396KO7', 'xrlh3903@nowhere.com');
--
-- Inserting data into table `leave`
--
INSERT INTO `leave`(employee_id, date, leave_type, reason, state) VALUES
('E3N43B9724H3QN82', '2018-10-07', 'Casual', 'Necessitatibus illo libero dolorem consequatur quam provident.', 'Approved'),
('4N96X1273H396KO7', '2019-11-06', 'No-Pay', 'Sint modi quasi incidunt; voluptatem sit magni. Aspernatur ullam ipsam.', 'Approved'),
('4QQ7G1A6OSKTED6P', '2019-04-30', 'Annual', 'Expedita corporis obcaecati sit sequi illo. Aliquid tenetur voluptatem.', 'Pending'),
('1T7E55W3J182SKW7', '2020-02-05', 'Sick', 'Doloremque unde exercitationem cum quaerat alias; excepturi est aut.', 'Pending'),
('3C1QR8BVP2759SM9', '2020-02-05', 'Sick', 'Accusantium dolores ut quas eos iure quia officiis. Minus quo.', 'Approved'),
('E3N43B9724H3QN82', '2019-04-30', 'Annual', 'Ipsa minus eaque. Magnam autem veritatis aut aliquam repellat aperiam.', 'Approved'),
('68886RHCW4CAW548', '2019-11-06', 'No-Pay', 'In et illum aut rerum veritatis.', 'Pending'),
('IF9L1MOLI6P6KW3L', '2020-02-05', 'Sick', 'Unde enim eligendi. Perspiciatis possimus itaque architecto quos iste!', 'Pending'),
('J736P11745XC4L26', '2019-04-30', 'Annual', 'Ipsum qui vitae velit molestiae sint.', 'Pending'),
('GPEQJ44M3AUG2JEB', '2018-10-07', 'Casual', 'Sit qui quibusdam hic nulla ut odio sit nam;', 'Approved'),
('1T7E55W3J182SKW7', '2019-11-06', 'No-Pay', 'Expedita labore non nulla quae sit officiis qui.', 'Approved'),
('LO5LBEA657JU5N53', '2018-10-07', 'Casual', 'Voluptatem id voluptatem architecto et aut natus. Et unde ullam.', 'Rejected'),
('68886RHCW4CAW548', '2019-04-30', 'Annual', 'Veniam ipsa in quia temporibus molestiae saepe ut numquam.', 'Pending'),
('4KC15W1UYB1BY214', '2019-04-30', 'Annual', 'Ipsa quasi quia saepe in a maxime eos ipsum...', 'Approved'),
('GPEQJ44M3AUG2JEB', '2020-02-05', 'Sick', 'Rerum quia facilis autem ut vitae molestiae officiis veritatis.', 'Approved'),
('J736P11745XC4L26', '2019-11-06', 'No-Pay', 'Quo aut officiis voluptatum quo. Qui impedit eligendi rem.', 'Pending'),
('4QQ7G1A6OSKTED6P', '2018-10-07', 'Casual', 'Autem soluta eos. In aut voluptate voluptatibus id nulla modi sed!', 'Pending'),
('3C1QR8BVP2759SM9', '2019-11-06', 'No-Pay', 'Iste assumenda eos qui sed aut a.', 'Approved'),
('J736P11745XC4L26', '2018-10-07', 'Casual', 'Sapiente animi ducimus culpa unde.', 'Pending'),
('4QQ7G1A6OSKTED6P', '2019-11-06', 'No-Pay', 'Minima earum veritatis quis vel quos qui sed omnis suscipit...', 'Rejected'),
('GPEQJ44M3AUG2JEB', '2019-11-06', 'No-Pay', 'Odio et impedit qui alias ut maxime. At quis at.', 'Approved'),
('9T989FXQWAC4HF86', '2019-04-30', 'Annual', 'Hic sit nulla expedita quo unde autem, odit alias voluptatem. Id quia.', 'Rejected'),
('1T7E55W3J182SKW7', '2019-04-30', 'Annual', 'Ad aspernatur est cupiditate similique totam qui. Autem facilis.', 'Rejected'),
('LO5LBEA657JU5N53', '2020-02-05', 'Sick', 'Corporis rerum dolorem consequuntur accusantium asperiores rerum.', 'Approved'),
('W5ME5222K4542M1S', '2019-11-06', 'No-Pay', 'Voluptate ea magnam minima ut. Neque quia suscipit amet quos.', 'Rejected'),
('4KC15W1UYB1BY214', '2018-10-07', 'Casual', 'Ut odit est reiciendis qui est vitae repudiandae. Corporis aliquam rem.', 'Pending'),
('22K546KA3941FL24', '2020-02-05', 'Sick', 'Nihil sit animi excepturi quibusdam inventore omnis. Fuga facere;', 'Rejected'),
('22K546KA3941FL24', '2019-04-30', 'Annual', 'Libero eum consequatur quidem. Voluptatem est sint est amet natus!', 'Pending'),
('LO5LBEA657JU5N53', '2019-11-06', 'No-Pay', 'Delectus maiores rerum et labore aperiam molestias minus temporibus.', 'Pending'),
('LO5LBEA657JU5N53', '2019-04-30', 'Annual', 'Quae voluptas obcaecati enim cupiditate corporis eum facilis et.', 'Pending'),
('E3N43B9724H3QN82', '2020-02-05', 'Sick', 'Veritatis excepturi perferendis. Voluptates facilis omnis praesentium.', 'Pending'),
('4N96X1273H396KO7', '2019-04-30', 'Annual', 'Blanditiis molestiae aut itaque eaque.', 'Pending'),
('3C1QR8BVP2759SM9', '2018-10-07', 'Casual', 'Nesciunt ut eligendi illo.', 'Approved'),
('68886RHCW4CAW548', '2018-10-07', 'Casual', 'Aliquam perferendis ad ipsam illo consectetur repellendus aut eos;', 'Approved'),
('GPEQJ44M3AUG2JEB', '2019-04-30', 'Annual', 'Quae nam nesciunt quae suscipit ratione consectetur error omnis.', 'Rejected'),
('9T989FXQWAC4HF86', '2020-02-05', 'Sick', 'Maiores exercitationem error. Fuga a illo deleniti. Voluptas ab iste!', 'Rejected'),
('4KC15W1UYB1BY214', '2019-11-06', 'No-Pay', 'Consequatur animi et facere et animi. Ut sit rerum doloremque ipsa sit.', 'Rejected'),
('4QQ7G1A6OSKTED6P', '2020-02-05', 'Sick', 'Officiis dolores sint officiis culpa sunt sed voluptate repellendus;', 'Rejected'),
('84641IS2VLEKG3D2', '2019-11-06', 'No-Pay', 'Et non omnis ipsa qui sapiente iste error. Sed velit incidunt. Sint.', 'Approved'),
('3C1QR8BVP2759SM9', '2019-04-30', 'Annual', 'Molestias et ratione.', 'Approved'),
('J736P11745XC4L26', '2020-02-05', 'Sick', 'Qui voluptas quis a repellat quam cum quos. Illum perferendis est.', 'Rejected'),
('22K546KA3941FL24', '2018-10-07', 'Casual', 'Unde ut sit vero molestias. Voluptas doloremque cumque? Adipisci quia.', 'Rejected'),
('22K546KA3941FL24', '2019-11-06', 'No-Pay', 'Aliquid rem omnis ullam rerum ipsam; amet ex fugit...', 'Pending'),
('1T7E55W3J182SKW7', '2018-10-07', 'Casual', 'Aperiam tempore qui sequi.', 'Approved'),
('9T989FXQWAC4HF86', '2018-10-07', 'Casual', 'Unde sint autem numquam necessitatibus nihil et. Omnis fugit voluptas...', 'Approved'),
('9T989FXQWAC4HF86', '2019-11-06', 'No-Pay', 'Mollitia autem quia. Voluptas beatae neque error? Fugit excepturi.', 'Approved'),
('68886RHCW4CAW548', '2020-02-05', 'Sick', 'Dignissimos id distinctio consequuntur praesentium iusto; unde;', 'Pending'),
('W5ME5222K4542M1S', '2019-04-30', 'Annual', 'Qui ut iusto minima similique rerum est. Reprehenderit et cum.', 'Approved'),
('4KC15W1UYB1BY214', '2020-02-05', 'Sick', 'Qui ipsum laboriosam in harum repellendus perspiciatis, aut asperiores...', 'Rejected'),
('4N96X1273H396KO7', '2018-10-07', 'Casual', 'Eius et neque sit nisi vitae corrupti dolorem nulla.', 'Rejected');
--
-- Inserting data into table pay_grade_leave
--
INSERT INTO pay_grade_leave(pay_grade, leave_type, `limit`) VALUES
('Grade-4', 'Sick', 40),
('Grade-3', 'Casual', 47),
('Grade-3', 'Annual', 21),
('Grade-4', 'Annual', 6),
('Grade-1', 'Sick', 16),
('Grade-4', 'Casual', 23),
('Grade-4', 'No-Pay', 54),
('Grade-2', 'No-Pay', 45),
('Grade-2', 'Sick', 0),
('Grade-1', 'No-Pay', 28),
('Grade-3', 'No-Pay', 27),
('Grade-3', 'Sick', 7),
('Grade-2', 'Annual', 7),
('Grade-1', 'Annual', 50),
('Grade-2', 'Casual', 4),
('Grade-1', 'Casual', 56);
COMMIT;