-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathemployee.sql
More file actions
50 lines (50 loc) · 12.8 KB
/
employee.sql
File metadata and controls
50 lines (50 loc) · 12.8 KB
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
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (1, 28, 33, 8, 10, 'Costa Rica', 'Denmark', 'F', '1998-07-05', 'Single Parent', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (2, 22, 25, 10, 20, 'China', 'Costa Rica', 'M', '1979-05-01', 'Married', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (3, 46, 3, 2, 40, 'Portugal', 'Lithuania', 'F', '1983-12-05', 'single', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (4, 20, 16, 10, 2, 'Mexico', 'Portugal', 'F', '1979-10-18', 'Divorced', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (5, 11, 41, 10, 15, 'China', 'Peru', 'M', '1976-01-17', 'Married', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (6, 14, 2, 3, 43, 'Poland', 'Indonesia', 'F', '1977-09-11', 'Single Parent', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (7, 3, 19, 2, 30, 'Japan', 'France', 'F', '1980-10-26', 'Married', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (8, 49, 32, 6, 23, 'China', 'South Korea', 'M', '1984-05-05', 'single', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (9, 37, 33, 9, 7, 'China', 'Finland', 'M', '1997-03-24', 'Single Parent', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (10, 33, 47, 6, 10, 'Colombia', 'Ukraine', 'F', '1988-10-15', 'single', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (11, 25, 4, 3, 11, 'Indonesia', 'Indonesia', 'M', '1973-01-10', 'Divorced', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (12, 32, 47, 6, 31, 'Indonesia', 'Russia', 'M', '1980-02-04', 'Single Parent', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (13, 15, 29, 7, 30, 'China', 'Russia', 'M', '1988-04-22', 'Divorced', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (14, 48, 2, 4, 3, 'China', 'France', 'F', '1976-07-14', 'Divorced', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (15, 32, 13, 9, 27, 'Argentina', 'China', 'F', '1977-02-10', 'Single Parent', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (16, 34, 31, 3, 48, 'China', 'Argentina', 'M', '1990-10-28', 'Married', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (17, 33, 34, 3, 16, 'China', 'China', 'F', '1968-12-29', 'single', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (18, 42, 34, 6, 46, 'Haiti', 'Malta', 'F', '1976-08-17', 'single', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (19, 7, 12, 3, 19, 'Russia', 'Thailand', 'F', '1988-06-05', 'Divorced', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (20, 49, 13, 8, 43, 'Indonesia', 'Peru', 'M', '1978-03-23', 'Married', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (21, 49, 15, 8, 15, 'Micronesia', 'Ethiopia', 'M', '1999-04-03', 'Divorced', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (22, 4, 15, 3, 9, 'Serbia', 'China', 'F', '1994-08-31', 'Divorced', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (23, 27, 8, 3, 47, 'Georgia', 'Philippines', 'M', '1971-05-05', 'Single Parent', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (24, 13, 24, 8, 8, 'Yemen', 'French Guiana', 'F', '1987-10-02', 'Single Parent', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (25, 20, 15, 3, 19, 'China', 'Indonesia', 'F', '1998-12-03', 'Married', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (26, 48, 46, 10, 31, 'Indonesia', 'China', 'M', '1995-10-22', 'single', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (27, 26, 12, 4, 42, 'Indonesia', 'China', 'M', '1995-03-01', 'Divorced', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (28, 49, 43, 10, 7, 'Kazakhstan', 'Indonesia', 'F', '1973-07-31', 'Single Parent', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (29, 4, 30, 5, 49, 'Indonesia', 'Yemen', 'M', '1987-08-30', 'single', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (30, 40, 25, 8, 12, 'China', 'China', 'F', '1996-07-23', 'Married', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (31, 49, 40, 10, 48, 'Poland', 'Bolivia', 'M', '1989-06-07', 'Single Parent', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (32, 19, 40, 8, 43, 'Serbia', 'Mexico', 'M', '1973-01-26', 'Single Parent', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (33, 42, 16, 7, 2, 'Indonesia', 'Indonesia', 'F', '1986-07-05', 'Single Parent', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (34, 42, 31, 5, 37, 'Philippines', 'Portugal', 'M', '1979-12-24', 'Divorced', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (35, 47, 37, 6, 11, 'China', 'Guatemala', 'M', '1996-09-29', 'Divorced', 'White/American');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (36, 8, 14, 7, 22, 'China', 'China', 'M', '1967-11-17', 'Divorced', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (37, 14, 36, 7, 22, 'Syria', 'Iran', 'M', '1968-06-21', 'single', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (38, 40, 42, 3, 49, 'Indonesia', 'United States', 'M', '1977-07-22', 'Married', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (39, 39, 22, 8, 39, 'Canada', 'Argentina', 'F', '1973-01-02', 'Married', 'Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (40, 38, 9, 4, 34, 'Czech Republic', 'China', 'F', '1993-05-14', 'Divorced', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (41, 28, 45, 9, 10, 'Indonesia', 'Uruguay', 'F', '1999-10-03', 'Married', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (42, 16, 31, 3, 40, 'China', 'Russia', 'F', '1988-01-11', 'Married', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (43, 33, 5, 2, 39, 'Indonesia', 'Colombia', 'F', '1994-01-30', 'Divorced', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (44, 19, 9, 10, 48, 'Poland', 'Indonesia', 'M', '1984-06-12', 'single', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (45, 10, 23, 6, 12, 'China', 'Greece', 'M', '1967-09-06', 'Single Parent', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (46, 37, 41, 10, 14, 'Germany', 'Indonesia', 'F', '1998-04-12', 'single', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (47, 32, 50, 5, 49, 'China', 'South Africa', 'F', '1986-03-29', 'Divorced', 'Muslim');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (48, 19, 41, 4, 8, 'Czech Republic', 'China', 'F', '1981-06-19', 'Single Parent', 'Hispanic');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (49, 29, 18, 8, 38, 'Argentina', 'Armenia', 'F', '1990-08-22', 'single', 'South-Asian');
insert into employee (employee_id, employee_role_id, employee_type_id, organization_id, person_id, home_country, work_country, gender, DOB, martial_status, ethnicity) values (50, 20, 20, 4, 49, 'China', 'Poland', 'M', '1999-02-04', 'single', 'Muslim');