Last active
April 16, 2018 03:47
-
-
Save civera2/4e98735c42c8c7981d5fa1944106f880 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group:Recursos Humanos | |
| regions = { | |
| region_id:number, region_name:string | |
| 1 , 'Europe' | |
| 2 , 'Americas' | |
| 3 , 'Asia' | |
| 4 , 'Middle East and Africa' | |
| } | |
| countries = { | |
| country_id:string, country_name:string , region_id:number | |
| 'IT' , 'Italy' , 1 | |
| 'JP' , 'Japan' , 3 | |
| 'US' , 'United States of America', 2 | |
| 'CA' , 'Canada' , 2 | |
| 'CN' , 'China' , 3 | |
| 'IN' , 'India' , 3 | |
| 'AU' , 'Australia' , 3 | |
| 'ZW' , 'Zimbabwe' , 4 | |
| 'SG' , 'Singapore' , 3 | |
| 'UK' , 'United Kingdom' , 1 | |
| 'FR' , 'France' , 1 | |
| 'DE' , 'Germany' , 1 | |
| 'ZM' , 'Zambia' , 4 | |
| 'EG' , 'Egypt' , 4 | |
| 'BR' , 'Brazil' , 2 | |
| 'CH' , 'Switzerland' , 1 | |
| 'NL' , 'Netherlands' , 1 | |
| 'MX' , 'Mexico' , 2 | |
| 'KW' , 'Kuwait' , 4 | |
| 'IL' , 'Israel' , 4 | |
| 'DK' , 'Denmark' , 1 | |
| 'HK' , 'HongKong' , 3 | |
| 'NG' , 'Nigeria' , 4 | |
| 'AR' , 'Argentina' , 2 | |
| 'BE' , 'Belgium' , 1 | |
| } | |
| locations = { | |
| location_id:number, street_address:string , postal_code:string, city:string , state_province:string, country_id:string | |
| 1000 , '1297 Via Cola di Rie' , '00989' , 'Roma' , null , 'IT' | |
| 1100 , '93091 Calle della Testa' , '10934' , 'Venice' , null , 'IT' | |
| 1200 , '2017 Shinjuku-ku' , '1689' , 'Tokyo' , 'Tokyo Prefecture' , 'JP' | |
| 1300 , '9450 Kamiya-cho' , '6823' , 'Hiroshima' , null , 'JP' | |
| 1400 , '2014 Jabberwocky Rd' , '26192' , 'Southlake' , 'Texas' , 'US' | |
| 1500 , '2011 Interiors Blvd' , '99236' , 'South San Francisco', 'California' , 'US' | |
| 1600 , '2007 Zagora St' , '50090' , 'South Brunswick' , 'New Jersey' , 'US' | |
| 1700 , '2004 Charade Rd' , '98199' , 'Seattle' , 'Washington' , 'US' | |
| 1800 , '147 Spadina Ave' , 'M5V 2L7' , 'Toronto' , 'Ontario' , 'CA' | |
| 1900 , '6092 Boxwood St' , 'YSW 9T2' , 'Whitehorse' , 'Yukon' , 'CA' | |
| 2000 , '40-5-12 Laogianggen' , '190518' , 'Beijing' , null , 'CN' | |
| 2100 , '1298 Vileparle (E)' , '490231' , 'Bombay' , 'Maharashtra' , 'IN' | |
| 2200 , '12-98 Victoria Street' , '2901' , 'Sydney' , 'New South Wales' , 'AU' | |
| 2300 , '198 Clementi North' , '540198' , 'Singapore' , null , 'SG' | |
| 2400 , '8204 Arthur St' , null , 'London' , null , 'UK' | |
| 2500 , 'Magdalen Centre, The Oxford Science Park', 'OX9 9ZB' , 'Oxford' , 'Oxford' , 'UK' | |
| 2600 , '9702 Chester Road' , '09629850293' , 'Stretford' , 'Manchester' , 'UK' | |
| 2700 , 'Schwanthalerstr. 7031' , '80925' , 'Munich' , 'Bavaria' , 'DE' | |
| 2800 , 'Rua Frei Caneca 1360 ' , '01307-002' , 'Sao Paulo' , 'Sao Paulo' , 'BR' | |
| 2900 , '20 Rue des Corps-Saints' , '1730' , 'Geneva' , 'Geneve' , 'CH' | |
| 3000 , 'Murtenstrasse 921' , '3095' , 'Bern' , 'BE' , 'CH' | |
| 3100 , 'Pieter Breughelstraat 837' , '3029SK' , 'Utrecht' , 'Utrecht' , 'NL' | |
| 3200 , 'Mariano Escobedo 9991' , '11932' , 'Mexico City' , 'Distrito Federal,' , 'MX' | |
| } | |
| departments = { | |
| department_id:number, department_name:string, manager_id:number, location_id:number | |
| 10 , 'Administration' , 200 , 1700 | |
| 20 , 'Marketing' , 201 , 1800 | |
| 30 , 'Purchasing' , 114 , 1700 | |
| 40 , 'Human Resources' , 203 , 2400 | |
| 50 , 'Shipping' , 121 , 1500 | |
| 60 , 'IT' , 103 , 1400 | |
| 70 , 'Public Relations' , 204 , 2700 | |
| 80 , 'Sales' , 145 , 2500 | |
| 90 , 'Executive' , 100 , 1700 | |
| 100 , 'Finance' , 108 , 1700 | |
| 110 , 'Accounting' , 205 , 1700 | |
| 120 , 'Treasury' , null , 1700 | |
| 130 , 'Corporate Tax' , null , 1700 | |
| 140 , 'Control And Credit' , null , 1700 | |
| 150 , 'Shareholder Services', null , 1700 | |
| 160 , 'Benefits' , null , 1700 | |
| 170 , 'Manufacturing' , null , 1700 | |
| 180 , 'Construction' , null , 1700 | |
| 190 , 'Contracting' , null , 1700 | |
| 200 , 'Operations' , null , 1700 | |
| 210 , 'IT Support' , null , 1700 | |
| 220 , 'NOC' , null , 1700 | |
| 230 , 'IT Helpdesk' , null , 1700 | |
| 240 , 'Government Sales' , null , 1700 | |
| 250 , 'Retail Sales' , null , 1700 | |
| 260 , 'Recruiting' , null , 1700 | |
| 270 , 'Payroll' , null , 1700 | |
| } | |
| jobs = { | |
| job_id:string, job_title:string , min_salary:number, max_salary:number | |
| 'AD_PRES' , 'President' , 20000 , 40000 | |
| 'AD_VP' , 'Administration Vice President' , 15000 , 30000 | |
| 'AD_ASST' , 'Administration Assistant' , 3000 , 6000 | |
| 'FI_MGR' , 'Finance Manager' , 8200 , 16000 | |
| 'FI_ACCOUNT' , 'Accountant' , 4200 , 9000 | |
| 'AC_MGR' , 'Accounting Manager' , 8200 , 16000 | |
| 'AC_ACCOUNT' , 'Public Accountant' , 4200 , 9000 | |
| 'SA_MAN' , 'Sales Manager' , 10000 , 20000 | |
| 'SA_REP' , 'Sales Representative' , 6000 , 12000 | |
| 'PU_MAN' , 'Purchasing Manager' , 8000 , 15000 | |
| 'PU_CLERK' , 'Purchasing Clerk' , 2500 , 5500 | |
| 'ST_MAN' , 'Stock Manager' , 5500 , 8500 | |
| 'ST_CLERK' , 'Stock Clerk' , 2000 , 5000 | |
| 'SH_CLERK' , 'Shipping Clerk' , 2500 , 5500 | |
| 'IT_PROG' , 'Programmer' , 4000 , 10000 | |
| 'MK_MAN' , 'Marketing Manager' , 9000 , 15000 | |
| 'MK_REP' , 'Marketing Representative' , 4000 , 9000 | |
| 'HR_REP' , 'Human Resources Representative' , 4000 , 9000 | |
| 'PR_REP' , 'Public Relations Representative', 4500 , 10500 | |
| } | |
| employees = { | |
| employee_id:number, first_name:string, last_name:string, email:string, phone_number:string , hire_date:date, job_id:string, salary:number, commission_pct:number, manager_id:number, department_id:number | |
| 100 , 'Steven' , 'King' , 'SKING' , '515.123.4567' , 1987-06-17 , 'AD_PRES' , 24000 , null , null , 90 | |
| 101 , 'Neena' , 'Kochhar' , 'NKOCHHAR' , '515.123.4568' , 1989-09-21 , 'AD_VP' , 17000 , null , 100 , 90 | |
| 102 , 'Lex' , 'De Haan' , 'LDEHAAN' , '515.123.4569' , 1993-01-13 , 'AD_VP' , 17000 , null , 100 , 90 | |
| 103 , 'Alexander' , 'Hunold' , 'AHUNOLD' , '590.423.4567' , 1990-01-03 , 'IT_PROG' , 9000 , null , 102 , 60 | |
| 104 , 'Bruce' , 'Ernst' , 'BERNST' , '590.423.4568' , 1991-05-21 , 'IT_PROG' , 6000 , null , 103 , 60 | |
| 105 , 'David' , 'Austin' , 'DAUSTIN' , '590.423.4569' , 1997-06-25 , 'IT_PROG' , 4800 , null , 103 , 60 | |
| 106 , 'Valli' , 'Pataballa' , 'VPATABAL' , '590.423.4560' , 1998-02-05 , 'IT_PROG' , 4800 , null , 103 , 60 | |
| 107 , 'Diana' , 'Lorentz' , 'DLORENTZ' , '590.423.5567' , 1999-02-07 , 'IT_PROG' , 4200 , null , 103 , 60 | |
| 108 , 'Nancy' , 'Greenberg' , 'NGREENBE' , '515.124.4569' , 1994-08-17 , 'FI_MGR' , 12000 , null , 101 , 100 | |
| 109 , 'Daniel' , 'Faviet' , 'DFAVIET' , '515.124.4169' , 1994-09-16 , 'FI_ACCOUNT' , 9000 , null , 108 , 100 | |
| 110 , 'John' , 'Chen' , 'JCHEN' , '515.124.4269' , 1997-09-28 , 'FI_ACCOUNT' , 8200 , null , 108 , 100 | |
| 111 , 'Ismael' , 'Sciarra' , 'ISCIARRA' , '515.124.4369' , 1997-09-30 , 'FI_ACCOUNT' , 7700 , null , 108 , 100 | |
| 112 , 'Jose Manuel' , 'Urman' , 'JMURMAN' , '515.124.4469' , 1998-03-07 , 'FI_ACCOUNT' , 7800 , null , 108 , 100 | |
| 113 , 'Luis' , 'Popp' , 'LPOPP' , '515.124.4567' , 1999-12-07 , 'FI_ACCOUNT' , 6900 , null , 108 , 100 | |
| 114 , 'Den' , 'Raphaely' , 'DRAPHEAL' , '515.127.4561' , 1994-12-07 , 'PU_MAN' , 11000 , null , 100 , 30 | |
| 115 , 'Alexander' , 'Khoo' , 'AKHOO' , '515.127.4562' , 1995-05-18 , 'PU_CLERK' , 3100 , null , 114 , 30 | |
| 116 , 'Shelli' , 'Baida' , 'SBAIDA' , '515.127.4563' , 1997-12-24 , 'PU_CLERK' , 2900 , null , 114 , 30 | |
| 117 , 'Sigal' , 'Tobias' , 'STOBIAS' , '515.127.4564' , 1997-07-24 , 'PU_CLERK' , 2800 , null , 114 , 30 | |
| 118 , 'Guy' , 'Himuro' , 'GHIMURO' , '515.127.4565' , 1998-11-15 , 'PU_CLERK' , 2600 , null , 114 , 30 | |
| 119 , 'Karen' , 'Colmenares' , 'KCOLMENA' , '515.127.4566' , 1999-08-10 , 'PU_CLERK' , 2500 , null , 114 , 30 | |
| 120 , 'Matthew' , 'Weiss' , 'MWEISS' , '650.123.1234' , 1996-07-18 , 'ST_MAN' , 8000 , null , 100 , 50 | |
| 121 , 'Adam' , 'Fripp' , 'AFRIPP' , '650.123.2234' , 1997-04-10 , 'ST_MAN' , 8200 , null , 100 , 50 | |
| 122 , 'Payam' , 'Kaufling' , 'PKAUFLIN' , '650.123.3234' , 1995-05-01 , 'ST_MAN' , 7900 , null , 100 , 50 | |
| 123 , 'Shanta' , 'Vollman' , 'SVOLLMAN' , '650.123.4234' , 1997-10-10 , 'ST_MAN' , 6500 , null , 100 , 50 | |
| 124 , 'Kevin' , 'Mourgos' , 'KMOURGOS' , '650.123.5234' , 1999-11-16 , 'ST_MAN' , 5800 , null , 100 , 50 | |
| 125 , 'Julia' , 'Nayer' , 'JNAYER' , '650.124.1214' , 1997-07-16 , 'ST_CLERK' , 3200 , null , 120 , 50 | |
| 126 , 'Irene' , 'Mikkilineni' , 'IMIKKILI' , '650.124.1224' , 1998-09-28 , 'ST_CLERK' , 2700 , null , 120 , 50 | |
| 127 , 'James' , 'Landry' , 'JLANDRY' , '650.124.1334' , 1999-01-14 , 'ST_CLERK' , 2400 , null , 120 , 50 | |
| 128 , 'Steven' , 'Markle' , 'SMARKLE' , '650.124.1434' , 2000-03-08 , 'ST_CLERK' , 2200 , null , 120 , 50 | |
| 129 , 'Laura' , 'Bissot' , 'LBISSOT' , '650.124.5234' , 1997-08-08 , 'ST_CLERK' , 3300 , null , 121 , 50 | |
| 130 , 'Mozhe' , 'Atkinson' , 'MATKINSO' , '650.124.6234' , 1997-10-30 , 'ST_CLERK' , 2800 , null , 121 , 50 | |
| 131 , 'James' , 'Marlow' , 'JAMRLOW' , '650.124.7234' , 1997-02-16 , 'ST_CLERK' , 2500 , null , 121 , 50 | |
| 132 , 'TJ' , 'Olson' , 'TJOLSON' , '650.124.8234' , 1999-04-10 , 'ST_CLERK' , 2100 , null , 121 , 50 | |
| 133 , 'Jason' , 'Mallin' , 'JMALLIN' , '650.127.1934' , 1996-06-14 , 'ST_CLERK' , 3300 , null , 122 , 50 | |
| 134 , 'Michael' , 'Rogers' , 'MROGERS' , '650.127.1834' , 1998-08-26 , 'ST_CLERK' , 2900 , null , 122 , 50 | |
| 135 , 'Ki' , 'Gee' , 'KGEE' , '650.127.1734' , 1999-12-12 , 'ST_CLERK' , 2400 , null , 122 , 50 | |
| 136 , 'Hazel' , 'Philtanker' , 'HPHILTAN' , '650.127.1634' , 2000-02-06 , 'ST_CLERK' , 2200 , null , 122 , 50 | |
| 137 , 'Renske' , 'Ladwig' , 'RLADWIG' , '650.121.1234' , 1995-07-14 , 'ST_CLERK' , 3600 , null , 123 , 50 | |
| 138 , 'Stephen' , 'Stiles' , 'SSTILES' , '650.121.2034' , 1997-10-26 , 'ST_CLERK' , 3200 , null , 123 , 50 | |
| 139 , 'John' , 'Seo' , 'JSEO' , '650.121.2019' , 1998-02-12 , 'ST_CLERK' , 2700 , null , 123 , 50 | |
| 140 , 'Joshua' , 'Patel' , 'JPATEL' , '650.121.1834' , 1998-04-06 , 'ST_CLERK' , 2500 , null , 123 , 50 | |
| 141 , 'Trenna' , 'Rajs' , 'TRAJS' , '650.121.8009' , 1995-10-17 , 'ST_CLERK' , 3500 , null , 124 , 50 | |
| 142 , 'Curtis' , 'Davies' , 'CDAVIES' , '650.121.2994' , 1997-01-29 , 'ST_CLERK' , 3100 , null , 124 , 50 | |
| 143 , 'Randall' , 'Matos' , 'RMATOS' , '650.121.2874' , 1998-03-15 , 'ST_CLERK' , 2600 , null , 124 , 50 | |
| 144 , 'Peter' , 'Vargas' , 'PVARGAS' , '650.121.2004' , 1998-07-09 , 'ST_CLERK' , 2500 , null , 124 , 50 | |
| 145 , 'John' , 'Russell' , 'JRUSSEL' , '011.44.1344.429268', 1996-10-01 , 'SA_MAN' , 14000 , 0.4 , 100 , 80 | |
| 146 , 'Karen' , 'Partners' , 'KPARTNER' , '011.44.1344.467268', 1997-01-05 , 'SA_MAN' , 13500 , 0.3 , 100 , 80 | |
| 147 , 'Alberto' , 'Errazuriz' , 'AERRAZUR' , '011.44.1344.429278', 1997-03-10 , 'SA_MAN' , 12000 , 0.3 , 100 , 80 | |
| 148 , 'Gerald' , 'Cambrault' , 'GCAMBRAU' , '011.44.1344.619268', 1999-10-15 , 'SA_MAN' , 11000 , 0.3 , 100 , 80 | |
| 149 , 'Eleni' , 'Zlotkey' , 'EZLOTKEY' , '011.44.1344.429018', 2000-01-29 , 'SA_MAN' , 10500 , 0.2 , 100 , 80 | |
| 150 , 'Peter' , 'Tucker' , 'PTUCKER' , '011.44.1344.129268', 1997-01-30 , 'SA_REP' , 10000 , 0.3 , 145 , 80 | |
| 151 , 'David' , 'Bernstein' , 'DBERNSTE' , '011.44.1344.345268', 1997-03-24 , 'SA_REP' , 9500 , 0.25 , 145 , 80 | |
| 152 , 'Peter' , 'Hall' , 'PHALL' , '011.44.1344.478968', 1997-08-20 , 'SA_REP' , 9000 , 0.25 , 145 , 80 | |
| 153 , 'Christopher' , 'Olsen' , 'COLSEN' , '011.44.1344.498718', 1998-03-30 , 'SA_REP' , 8000 , 0.2 , 145 , 80 | |
| 154 , 'Nanette' , 'Cambrault' , 'NCAMBRAU' , '011.44.1344.987668', 1998-12-09 , 'SA_REP' , 7500 , 0.2 , 145 , 80 | |
| 155 , 'Oliver' , 'Tuvault' , 'OTUVAULT' , '011.44.1344.486508', 1999-11-23 , 'SA_REP' , 7000 , 0.15 , 145 , 80 | |
| 156 , 'Janette' , 'King' , 'JKING' , '011.44.1345.429268', 1996-01-30 , 'SA_REP' , 10000 , 0.35 , 146 , 80 | |
| 157 , 'Patrick' , 'Sully' , 'PSULLY' , '011.44.1345.929268', 1996-03-04 , 'SA_REP' , 9500 , 0.35 , 146 , 80 | |
| 158 , 'Allan' , 'McEwen' , 'AMCEWEN' , '011.44.1345.829268', 1996-08-01 , 'SA_REP' , 9000 , 0.35 , 146 , 80 | |
| 159 , 'Lindsey' , 'Smith' , 'LSMITH' , '011.44.1345.729268', 1997-03-10 , 'SA_REP' , 8000 , 0.3 , 146 , 80 | |
| 160 , 'Louise' , 'Doran' , 'LDORAN' , '011.44.1345.629268', 1997-12-15 , 'SA_REP' , 7500 , 0.3 , 146 , 80 | |
| 161 , 'Sarath' , 'Sewall' , 'SSEWALL' , '011.44.1345.529268', 1998-11-03 , 'SA_REP' , 7000 , 0.25 , 146 , 80 | |
| 162 , 'Clara' , 'Vishney' , 'CVISHNEY' , '011.44.1346.129268', 1997-11-11 , 'SA_REP' , 10500 , 0.25 , 147 , 80 | |
| 163 , 'Danielle' , 'Greene' , 'DGREENE' , '011.44.1346.229268', 1999-03-19 , 'SA_REP' , 9500 , 0.15 , 147 , 80 | |
| 164 , 'Mattea' , 'Marvins' , 'MMARVINS' , '011.44.1346.329268', 2000-01-24 , 'SA_REP' , 7200 , 0.1 , 147 , 80 | |
| 165 , 'David' , 'Lee' , 'DLEE' , '011.44.1346.529268', 2000-02-23 , 'SA_REP' , 6800 , 0.1 , 147 , 80 | |
| 166 , 'Sundar' , 'Ande' , 'SANDE' , '011.44.1346.629268', 2000-03-24 , 'SA_REP' , 6400 , 0.1 , 147 , 80 | |
| 167 , 'Amit' , 'Banda' , 'ABANDA' , '011.44.1346.729268', 2000-04-21 , 'SA_REP' , 6200 , 0.1 , 147 , 80 | |
| 168 , 'Lisa' , 'Ozer' , 'LOZER' , '011.44.1343.929268', 1997-03-11 , 'SA_REP' , 11500 , 0.25 , 148 , 80 | |
| 169 , 'Harrison' , 'Bloom' , 'HBLOOM' , '011.44.1343.829268', 1998-03-23 , 'SA_REP' , 10000 , 0.2 , 148 , 80 | |
| 170 , 'Tayler' , 'Fox' , 'TFOX' , '011.44.1343.729268', 1998-01-24 , 'SA_REP' , 9600 , 0.2 , 148 , 80 | |
| 171 , 'William' , 'Smith' , 'WSMITH' , '011.44.1343.629268', 1999-02-23 , 'SA_REP' , 7400 , 0.15 , 148 , 80 | |
| 172 , 'Elizabeth' , 'Bates' , 'EBATES' , '011.44.1343.529268', 1999-03-24 , 'SA_REP' , 7300 , 0.15 , 148 , 80 | |
| 173 , 'Sundita' , 'Kumar' , 'SKUMAR' , '011.44.1343.329268', 2000-04-21 , 'SA_REP' , 6100 , 0.1 , 148 , 80 | |
| 174 , 'Ellen' , 'Abel' , 'EABEL' , '011.44.1644.429267', 1996-05-11 , 'SA_REP' , 11000 , 0.3 , 149 , 80 | |
| 175 , 'Alyssa' , 'Hutton' , 'AHUTTON' , '011.44.1644.429266', 1997-03-19 , 'SA_REP' , 8800 , 0.25 , 149 , 80 | |
| 176 , 'Jonathon' , 'Taylor' , 'JTAYLOR' , '011.44.1644.429265', 1998-03-24 , 'SA_REP' , 8600 , 0.2 , 149 , 80 | |
| 177 , 'Jack' , 'Livingston' , 'JLIVINGS' , '011.44.1644.429264', 1998-04-23 , 'SA_REP' , 8400 , 0.2 , 149 , 80 | |
| 178 , 'Kimberely' , 'Grant' , 'KGRANT' , '011.44.1644.429263', 1999-05-24 , 'SA_REP' , 7000 , 0.15 , 149 , null | |
| 179 , 'Charles' , 'Johnson' , 'CJOHNSON' , '011.44.1644.429262', 2000-01-04 , 'SA_REP' , 6200 , 0.1 , 149 , 80 | |
| 180 , 'Winston' , 'Taylor' , 'WTAYLOR' , '650.507.9876' , 1998-01-24 , 'SH_CLERK' , 3200 , null , 120 , 50 | |
| 181 , 'Jean' , 'Fleaur' , 'JFLEAUR' , '650.507.9877' , 1998-02-23 , 'SH_CLERK' , 3100 , null , 120 , 50 | |
| 182 , 'Martha' , 'Sullivan' , 'MSULLIVA' , '650.507.9878' , 1999-01-28 , 'SH_CLERK' , 2500 , null , 120 , 50 | |
| 183 , 'Girard' , 'Geoni' , 'GGEONI' , '650.507.9879' , 2000-02-03 , 'SH_CLERK' , 2800 , null , 120 , 50 | |
| 184 , 'Nandita' , 'Sarchand' , 'NSARCHAN' , '650.509.1876' , 1996-01-27 , 'SH_CLERK' , 4200 , null , 121 , 50 | |
| 185 , 'Alexis' , 'Bull' , 'ABULL' , '650.509.2876' , 1997-02-20 , 'SH_CLERK' , 4100 , null , 121 , 50 | |
| 186 , 'Julia' , 'Dellinger' , 'JDELLING' , '650.509.3876' , 1998-06-24 , 'SH_CLERK' , 3400 , null , 121 , 50 | |
| 187 , 'Anthony' , 'Cabrio' , 'ACABRIO' , '650.509.4876' , 1999-02-07 , 'SH_CLERK' , 3000 , null , 121 , 50 | |
| 188 , 'Kelly' , 'Chung' , 'KCHUNG' , '650.505.1876' , 1997-06-14 , 'SH_CLERK' , 3800 , null , 122 , 50 | |
| 189 , 'Jennifer' , 'Dilly' , 'JDILLY' , '650.505.2876' , 1997-08-13 , 'SH_CLERK' , 3600 , null , 122 , 50 | |
| 190 , 'Timothy' , 'Gates' , 'TGATES' , '650.505.3876' , 1998-07-11 , 'SH_CLERK' , 2900 , null , 122 , 50 | |
| 191 , 'Randall' , 'Perkins' , 'RPERKINS' , '650.505.4876' , 1999-12-19 , 'SH_CLERK' , 2500 , null , 122 , 50 | |
| 192 , 'Sarah' , 'Bell' , 'SBELL' , '650.501.1876' , 1996-02-04 , 'SH_CLERK' , 4000 , null , 123 , 50 | |
| 193 , 'Britney' , 'Everett' , 'BEVERETT' , '650.501.2876' , 1997-03-03 , 'SH_CLERK' , 3900 , null , 123 , 50 | |
| 194 , 'Samuel' , 'McCain' , 'SMCCAIN' , '650.501.3876' , 1998-07-01 , 'SH_CLERK' , 3200 , null , 123 , 50 | |
| 195 , 'Vance' , 'Jones' , 'VJONES' , '650.501.4876' , 1999-03-17 , 'SH_CLERK' , 2800 , null , 123 , 50 | |
| 196 , 'Alana' , 'Walsh' , 'AWALSH' , '650.507.9811' , 1998-04-24 , 'SH_CLERK' , 3100 , null , 124 , 50 | |
| 197 , 'Kevin' , 'Feeney' , 'KFEENEY' , '650.507.9822' , 1998-05-23 , 'SH_CLERK' , 3000 , null , 124 , 50 | |
| 198 , 'Donald' , 'OConnell' , 'DOCONNEL' , '650.507.9833' , 1999-06-21 , 'SH_CLERK' , 2600 , null , 124 , 50 | |
| 199 , 'Douglas' , 'Grant' , 'DGRANT' , '650.507.9844' , 2000-01-13 , 'SH_CLERK' , 2600 , null , 124 , 50 | |
| 200 , 'Jennifer' , 'Whalen' , 'JWHALEN' , '515.123.4444' , 1987-09-17 , 'AD_ASST' , 4400 , null , 101 , 10 | |
| 201 , 'Michael' , 'Hartstein' , 'MHARTSTE' , '515.123.5555' , 1996-02-17 , 'MK_MAN' , 13000 , null , 100 , 20 | |
| 202 , 'Pat' , 'Fay' , 'PFAY' , '603.123.6666' , 1997-08-17 , 'MK_REP' , 6000 , null , 201 , 20 | |
| 203 , 'Susan' , 'Mavris' , 'SMAVRIS' , '515.123.7777' , 1994-06-07 , 'HR_REP' , 6500 , null , 101 , 40 | |
| 204 , 'Hermann' , 'Baer' , 'HBAER' , '515.123.8888' , 1994-06-07 , 'PR_REP' , 10000 , null , 101 , 70 | |
| 205 , 'Shelley' , 'Higgins' , 'SHIGGINS' , '515.123.8080' , 1994-06-07 , 'AC_MGR' , 12000 , null , 101 , 110 | |
| 206 , 'William' , 'Gietz' , 'WGIETZ' , '51hr5.123.8181' , 1994-06-07 , 'AC_ACCOUNT' , 8300 , null , 205 , 110 | |
| } | |
| job_history = { | |
| employee_id:number, start_date:date, end_date:date, job_id:string, department_id:number | |
| 102, 2001-01-13, 2006-07-24, 'IT_PROG', 60 | |
| 101, 1997-09-21, 2001-10-27, 'AC_ACCOUNT', 110 | |
| 101, 2001-10-28, 2005-03-15, 'AC_MGR', 110 | |
| 201, 2004-02-17, 2007-12-19, 'MK_REP', 20 | |
| 114, 2006-03-24, 2007-12-31, 'ST_CLERK', 50 | |
| 122, 2007-01-01, 2007-12-31, 'ST_CLERK' , 50 | |
| 200, 1995-09-17, 2001-06-17, 'AD_ASST' , 90 | |
| 176, 2006-03-24, 2006-12-31, 'SA_REP' , 80 | |
| 176, 2007-01-01, 2007,-12-31,'SA_MAN' , 80 | |
| 200, 2002-07-01, 2006-12-31, 'AC_ACCOUNT' , 90 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment