--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;


-- Name: countries; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE countries (
    country_id character(2) NOT NULL,
    country_name character varying(40),
    region_id bigint
);



--
-- Name: TABLE countries; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE countries IS 'country table. Contains 25 rows. References with locations table.';


--
-- Name: COLUMN countries.country_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN countries.country_id IS 'Primary key of countries table.';


--
-- Name: COLUMN countries.country_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN countries.country_name IS 'Country name';


--
-- Name: COLUMN countries.region_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN countries.region_id IS 'Region ID for the country. Foreign key to region_id column in the departments table.';


--
-- Name: departments; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE departments (
    department_id smallint NOT NULL,
    department_name character varying(30) NOT NULL,
    manager_id integer,
    location_id smallint
);



--
-- Name: TABLE departments; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE departments IS 'Departments table that shows details of departments where employees
work. Contains 27 rows; references with locations, employees, and job_history tables.';


--
-- Name: COLUMN departments.department_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN departments.department_id IS 'Primary key column of departments table.';


--
-- Name: COLUMN departments.department_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN departments.department_name IS 'A not null column that shows name of a department. Administration,
Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public
Relations, Sales, Finance, and Accounting. ';


--
-- Name: COLUMN departments.manager_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN departments.manager_id IS 'Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column.';


--
-- Name: COLUMN departments.location_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN departments.location_id IS 'Location id where a department is located. Foreign key to location_id column of locations table.';


--
-- Name: employees; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE employees (
    employee_id integer NOT NULL,
    first_name character varying(20),
    last_name character varying(25) NOT NULL,
    email character varying(25) NOT NULL,
    phone_number character varying(20),
    hire_date timestamp without time zone NOT NULL,
    job_id character varying(10) NOT NULL,
    salary double precision,
    commission_pct real,
    manager_id integer,
    department_id smallint,
    CONSTRAINT emp_salary_min CHECK ((salary > (0)::double precision))
);



--
-- Name: TABLE employees; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE employees IS 'employees table. Contains 107 rows. References with departments,
jobs, job_history tables. Contains a self reference.';


--
-- Name: COLUMN employees.employee_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.employee_id IS 'Primary key of employees table.';


--
-- Name: COLUMN employees.first_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.first_name IS 'First name of the employee. A not null column.';


--
-- Name: COLUMN employees.last_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.last_name IS 'Last name of the employee. A not null column.';


--
-- Name: COLUMN employees.email; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.email IS 'Email id of the employee';


--
-- Name: COLUMN employees.phone_number; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.phone_number IS 'Phone number of the employee; includes country code and area code';


--
-- Name: COLUMN employees.hire_date; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.hire_date IS 'Date when the employee started on this job. A not null column.';


--
-- Name: COLUMN employees.job_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.job_id IS 'Current job of the employee; foreign key to job_id column of the
jobs table. A not null column.';


--
-- Name: COLUMN employees.salary; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.salary IS 'Monthly salary of the employee. Must be greater
than zero (enforced by constraint emp_salary_min)';


--
-- Name: COLUMN employees.commission_pct; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.commission_pct IS 'Commission percentage of the employee; Only employees in sales
department elgible for commission percentage';


--
-- Name: COLUMN employees.manager_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.manager_id IS 'Manager id of the employee; has same domain as manager_id in
departments table. Foreign key to employee_id column of employees table.
(useful for reflexive joins and CONNECT BY query)';


--
-- Name: COLUMN employees.department_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN employees.department_id IS 'Department id where employee works; foreign key to department_id
column of the departments table';


--
-- Name: job_history; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE job_history (
    employee_id integer NOT NULL,
    start_date timestamp without time zone NOT NULL,
    end_date timestamp without time zone NOT NULL,
    job_id character varying(10) NOT NULL,
    department_id smallint,
    CONSTRAINT jhist_date_interval CHECK ((end_date > start_date))
);



--
-- Name: TABLE job_history; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE job_history IS 'Table that stores job history of the employees. If an employee
changes departments within the job or changes jobs within the department,
new rows get inserted into this table with old job information of the
employee. Contains a complex primary key: employee_id+start_date.
Contains 25 rows. References with jobs, employees, and departments tables.';


--
-- Name: COLUMN job_history.employee_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN job_history.employee_id IS 'A not null column in the complex primary key employee_id+start_date.
Foreign key to employee_id column of the employee table';


--
-- Name: COLUMN job_history.start_date; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN job_history.start_date IS 'A not null column in the complex primary key employee_id+start_date.
Must be less than the end_date of the job_history table. (enforced by
constraint jhist_date_interval)';


--
-- Name: COLUMN job_history.end_date; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN job_history.end_date IS 'Last day of the employee in this job role. A not null column. Must be
greater than the start_date of the job_history table.
(enforced by constraint jhist_date_interval)';


--
-- Name: COLUMN job_history.job_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN job_history.job_id IS 'Job role in which the employee worked in the past; foreign key to
job_id column in the jobs table. A not null column.';


--
-- Name: COLUMN job_history.department_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN job_history.department_id IS 'Department id in which the employee worked in the past; foreign key to deparment_id column in the departments table';


--
-- Name: jobs; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE jobs (
    job_id character varying(10) NOT NULL,
    job_title character varying(35) NOT NULL,
    min_salary integer,
    max_salary integer
);



--
-- Name: TABLE jobs; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE jobs IS 'jobs table with job titles and salary ranges. Contains 19 rows.
References with employees and job_history table.';


--
-- Name: COLUMN jobs.job_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN jobs.job_id IS 'Primary key of jobs table.';


--
-- Name: COLUMN jobs.job_title; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN jobs.job_title IS 'A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT';


--
-- Name: COLUMN jobs.min_salary; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN jobs.min_salary IS 'Minimum salary for a job title.';


--
-- Name: COLUMN jobs.max_salary; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN jobs.max_salary IS 'Maximum salary for a job title';


--
-- Name: locations; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE locations (
    location_id smallint NOT NULL,
    street_address character varying(40),
    postal_code character varying(12),
    city character varying(30) NOT NULL,
    state_province character varying(25),
    country_id character(2)
);



--
-- Name: TABLE locations; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE locations IS 'Locations table that contains specific address of a specific office,
warehouse, and/or production site of a company. Does not store addresses /
locations of customers. Contains 23 rows; references with the
departments and countries tables. ';


--
-- Name: COLUMN locations.location_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN locations.location_id IS 'Primary key of locations table';


--
-- Name: COLUMN locations.street_address; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN locations.street_address IS 'Street address of an office, warehouse, or production site of a company.
Contains building number and street name';


--
-- Name: COLUMN locations.postal_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN locations.postal_code IS 'Postal code of the location of an office, warehouse, or production site
of a company. ';


--
-- Name: COLUMN locations.city; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN locations.city IS 'A not null column that shows city where an office, warehouse, or
production site of a company is located. ';


--
-- Name: COLUMN locations.state_province; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN locations.state_province IS 'State or Province where an office, warehouse, or production site of a
company is located.';


--
-- Name: COLUMN locations.country_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN locations.country_id IS 'Country where an office, warehouse, or production site of a company is
located. Foreign key to country_id column of the countries table.';


--
-- Name: regions; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE regions (
    region_id bigint NOT NULL,
    region_name character varying(25)
);



--
-- Data for Name: countries; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY countries (country_id, country_name, region_id) FROM stdin;
AR	Argentina	2
AU	Australia	3
BE	Belgium	1
BR	Brazil	2
CA	Canada	2
CH	Switzerland	1
CN	China	3
DE	Germany	1
DK	Denmark	1
EG	Egypt	4
FR	France	1
HK	HongKong	3
IL	Israel	4
IN	India	3
IT	Italy	1
JP	Japan	3
KW	Kuwait	4
MX	Mexico	2
NG	Nigeria	4
NL	Netherlands	1
SG	Singapore	3
UK	United Kingdom	1
US	United States of America	2
ZM	Zambia	4
ZW	Zimbabwe	4
\.


--
-- Data for Name: departments; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY departments (department_id, department_name, manager_id, location_id) FROM stdin;
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	\N	1700
130	Corporate Tax	\N	1700
140	Control And Credit	\N	1700
150	Shareholder Services	\N	1700
160	Benefits	\N	1700
170	Manufacturing	\N	1700
180	Construction	\N	1700
190	Contracting	\N	1700
200	Operations	\N	1700
210	IT Support	\N	1700
220	NOC	\N	1700
230	IT Helpdesk	\N	1700
240	Government Sales	\N	1700
250	Retail Sales	\N	1700
260	Recruiting	\N	1700
270	Payroll	\N	1700
\.


--
-- Data for Name: employees; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) FROM stdin;
100	Steven	King	SKING	515.123.4567	1987-06-17 00:00:00	AD_PRES	24000	\N	\N	90
101	Neena	Kochhar	NKOCHHAR	515.123.4568	1989-09-21 00:00:00	AD_VP	17000	\N	100	90
102	Lex	De Haan	LDEHAAN	515.123.4569	1993-01-13 00:00:00	AD_VP	17000	\N	100	90
103	Alexander	Hunold	AHUNOLD	590.423.4567	1990-01-03 00:00:00	IT_PROG	9000	\N	102	60
104	Bruce	Ernst	BERNST	590.423.4568	1991-05-21 00:00:00	IT_PROG	6000	\N	103	60
105	David	Austin	DAUSTIN	590.423.4569	1997-06-25 00:00:00	IT_PROG	4800	\N	103	60
106	Valli	Pataballa	VPATABAL	590.423.4560	1998-02-05 00:00:00	IT_PROG	4800	\N	103	60
107	Diana	Lorentz	DLORENTZ	590.423.5567	1999-02-07 00:00:00	IT_PROG	4200	\N	103	60
108	Nancy	Greenberg	NGREENBE	515.124.4569	1994-08-17 00:00:00	FI_MGR	12000	\N	101	100
109	Daniel	Faviet	DFAVIET	515.124.4169	1994-08-16 00:00:00	FI_ACCOUNT	9000	\N	108	100
110	John	Chen	JCHEN	515.124.4269	1997-09-28 00:00:00	FI_ACCOUNT	8200	\N	108	100
111	Ismael	Sciarra	ISCIARRA	515.124.4369	1997-09-30 00:00:00	FI_ACCOUNT	7700	\N	108	100
112	Jose Manuel	Urman	JMURMAN	515.124.4469	1998-03-07 00:00:00	FI_ACCOUNT	7800	\N	108	100
113	Luis	Popp	LPOPP	515.124.4567	1999-12-07 00:00:00	FI_ACCOUNT	6900	\N	108	100
114	Den	Raphaely	DRAPHEAL	515.127.4561	1994-12-07 00:00:00	PU_MAN	11000	\N	100	30
115	Alexander	Khoo	AKHOO	515.127.4562	1995-05-18 00:00:00	PU_CLERK	3100	\N	114	30
116	Shelli	Baida	SBAIDA	515.127.4563	1997-12-24 00:00:00	PU_CLERK	2900	\N	114	30
117	Sigal	Tobias	STOBIAS	515.127.4564	1997-07-24 00:00:00	PU_CLERK	2800	\N	114	30
118	Guy	Himuro	GHIMURO	515.127.4565	1998-11-15 00:00:00	PU_CLERK	2600	\N	114	30
119	Karen	Colmenares	KCOLMENA	515.127.4566	1999-08-10 00:00:00	PU_CLERK	2500	\N	114	30
120	Matthew	Weiss	MWEISS	650.123.1234	1996-07-18 00:00:00	ST_MAN	8000	\N	100	50
121	Adam	Fripp	AFRIPP	650.123.2234	1997-04-10 00:00:00	ST_MAN	8200	\N	100	50
122	Payam	Kaufling	PKAUFLIN	650.123.3234	1995-05-01 00:00:00	ST_MAN	7900	\N	100	50
123	Shanta	Vollman	SVOLLMAN	650.123.4234	1997-10-10 00:00:00	ST_MAN	6500	\N	100	50
124	Kevin	Mourgos	KMOURGOS	650.123.5234	1999-11-16 00:00:00	ST_MAN	5800	\N	100	50
125	Julia	Nayer	JNAYER	650.124.1214	1997-07-16 00:00:00	ST_CLERK	3200	\N	120	50
126	Irene	Mikkilineni	IMIKKILI	650.124.1224	1998-09-28 00:00:00	ST_CLERK	2700	\N	120	50
127	James	Landry	JLANDRY	650.124.1334	1999-01-14 00:00:00	ST_CLERK	2400	\N	120	50
128	Steven	Markle	SMARKLE	650.124.1434	2000-03-08 00:00:00	ST_CLERK	2200	\N	120	50
129	Laura	Bissot	LBISSOT	650.124.5234	1997-08-20 00:00:00	ST_CLERK	3300	\N	121	50
130	Mozhe	Atkinson	MATKINSO	650.124.6234	1997-10-30 00:00:00	ST_CLERK	2800	\N	121	50
131	James	Marlow	JAMRLOW	650.124.7234	1997-02-16 00:00:00	ST_CLERK	2500	\N	121	50
132	TJ	Olson	TJOLSON	650.124.8234	1999-04-10 00:00:00	ST_CLERK	2100	\N	121	50
133	Jason	Mallin	JMALLIN	650.127.1934	1996-06-14 00:00:00	ST_CLERK	3300	\N	122	50
134	Michael	Rogers	MROGERS	650.127.1834	1998-08-26 00:00:00	ST_CLERK	2900	\N	122	50
135	Ki	Gee	KGEE	650.127.1734	1999-12-12 00:00:00	ST_CLERK	2400	\N	122	50
136	Hazel	Philtanker	HPHILTAN	650.127.1634	2000-02-06 00:00:00	ST_CLERK	2200	\N	122	50
137	Renske	Ladwig	RLADWIG	650.121.1234	1995-07-14 00:00:00	ST_CLERK	3600	\N	123	50
138	Stephen	Stiles	SSTILES	650.121.2034	1997-10-26 00:00:00	ST_CLERK	3200	\N	123	50
139	John	Seo	JSEO	650.121.2019	1998-02-12 00:00:00	ST_CLERK	2700	\N	123	50
140	Joshua	Patel	JPATEL	650.121.1834	1998-04-06 00:00:00	ST_CLERK	2500	\N	123	50
141	Trenna	Rajs	TRAJS	650.121.8009	1995-10-17 00:00:00	ST_CLERK	3500	\N	124	50
142	Curtis	Davies	CDAVIES	650.121.2994	1997-01-29 00:00:00	ST_CLERK	3100	\N	124	50
143	Randall	Matos	RMATOS	650.121.2874	1998-03-15 00:00:00	ST_CLERK	2600	\N	124	50
144	Peter	Vargas	PVARGAS	650.121.2004	1998-07-09 00:00:00	ST_CLERK	2500	\N	124	50
145	John	Russell	JRUSSEL	011.44.1344.429268	1996-10-01 00:00:00	SA_MAN	14000	0.400000006	100	80
146	Karen	Partners	KPARTNER	011.44.1344.467268	1997-01-05 00:00:00	SA_MAN	13500	0.300000012	100	80
147	Alberto	Errazuriz	AERRAZUR	011.44.1344.429278	1997-03-10 00:00:00	SA_MAN	12000	0.300000012	100	80
148	Gerald	Cambrault	GCAMBRAU	011.44.1344.619268	1999-10-15 00:00:00	SA_MAN	11000	0.300000012	100	80
149	Eleni	Zlotkey	EZLOTKEY	011.44.1344.429018	2000-01-29 00:00:00	SA_MAN	10500	0.200000003	100	80
150	Peter	Tucker	PTUCKER	011.44.1344.129268	1997-01-30 00:00:00	SA_REP	10000	0.300000012	145	80
151	David	Bernstein	DBERNSTE	011.44.1344.345268	1997-03-24 00:00:00	SA_REP	9500	0.25	145	80
152	Peter	Hall	PHALL	011.44.1344.478968	1997-08-20 00:00:00	SA_REP	9000	0.25	145	80
153	Christopher	Olsen	COLSEN	011.44.1344.498718	1998-03-30 00:00:00	SA_REP	8000	0.200000003	145	80
154	Nanette	Cambrault	NCAMBRAU	011.44.1344.987668	1998-12-09 00:00:00	SA_REP	7500	0.200000003	145	80
155	Oliver	Tuvault	OTUVAULT	011.44.1344.486508	1999-11-23 00:00:00	SA_REP	7000	0.150000006	145	80
156	Janette	King	JKING	011.44.1345.429268	1996-01-30 00:00:00	SA_REP	10000	0.349999994	146	80
157	Patrick	Sully	PSULLY	011.44.1345.929268	1996-03-04 00:00:00	SA_REP	9500	0.349999994	146	80
158	Allan	McEwen	AMCEWEN	011.44.1345.829268	1996-08-01 00:00:00	SA_REP	9000	0.349999994	146	80
159	Lindsey	Smith	LSMITH	011.44.1345.729268	1997-03-10 00:00:00	SA_REP	8000	0.300000012	146	80
160	Louise	Doran	LDORAN	011.44.1345.629268	1997-12-15 00:00:00	SA_REP	7500	0.300000012	146	80
161	Sarath	Sewall	SSEWALL	011.44.1345.529268	1998-11-03 00:00:00	SA_REP	7000	0.25	146	80
162	Clara	Vishney	CVISHNEY	011.44.1346.129268	1997-11-11 00:00:00	SA_REP	10500	0.25	147	80
163	Danielle	Greene	DGREENE	011.44.1346.229268	1999-03-19 00:00:00	SA_REP	9500	0.150000006	147	80
164	Mattea	Marvins	MMARVINS	011.44.1346.329268	2000-01-24 00:00:00	SA_REP	7200	0.100000001	147	80
165	David	Lee	DLEE	011.44.1346.529268	2000-02-23 00:00:00	SA_REP	6800	0.100000001	147	80
166	Sundar	Ande	SANDE	011.44.1346.629268	2000-03-24 00:00:00	SA_REP	6400	0.100000001	147	80
167	Amit	Banda	ABANDA	011.44.1346.729268	2000-04-21 00:00:00	SA_REP	6200	0.100000001	147	80
168	Lisa	Ozer	LOZER	011.44.1343.929268	1997-03-11 00:00:00	SA_REP	11500	0.25	148	80
169	Harrison	Bloom	HBLOOM	011.44.1343.829268	1998-03-23 00:00:00	SA_REP	10000	0.200000003	148	80
170	Tayler	Fox	TFOX	011.44.1343.729268	1998-01-24 00:00:00	SA_REP	9600	0.200000003	148	80
171	William	Smith	WSMITH	011.44.1343.629268	1999-02-23 00:00:00	SA_REP	7400	0.150000006	148	80
172	Elizabeth	Bates	EBATES	011.44.1343.529268	1999-03-24 00:00:00	SA_REP	7300	0.150000006	148	80
173	Sundita	Kumar	SKUMAR	011.44.1343.329268	2000-04-21 00:00:00	SA_REP	6100	0.100000001	148	80
174	Ellen	Abel	EABEL	011.44.1644.429267	1996-05-11 00:00:00	SA_REP	11000	0.300000012	149	80
175	Alyssa	Hutton	AHUTTON	011.44.1644.429266	1997-03-19 00:00:00	SA_REP	8800	0.25	149	80
176	Jonathon	Taylor	JTAYLOR	011.44.1644.429265	1998-03-24 00:00:00	SA_REP	8600	0.200000003	149	80
177	Jack	Livingston	JLIVINGS	011.44.1644.429264	1998-04-23 00:00:00	SA_REP	8400	0.200000003	149	80
178	Kimberely	Grant	KGRANT	011.44.1644.429263	1999-05-24 00:00:00	SA_REP	7000	0.150000006	149	\N
179	Charles	Johnson	CJOHNSON	011.44.1644.429262	2000-01-04 00:00:00	SA_REP	6200	0.100000001	149	80
180	Winston	Taylor	WTAYLOR	650.507.9876	1998-01-24 00:00:00	SH_CLERK	3200	\N	120	50
181	Jean	Fleaur	JFLEAUR	650.507.9877	1998-02-23 00:00:00	SH_CLERK	3100	\N	120	50
182	Martha	Sullivan	MSULLIVA	650.507.9878	1999-06-21 00:00:00	SH_CLERK	2500	\N	120	50
183	Girard	Geoni	GGEONI	650.507.9879	2000-02-03 00:00:00	SH_CLERK	2800	\N	120	50
184	Nandita	Sarchand	NSARCHAN	650.509.1876	1996-01-27 00:00:00	SH_CLERK	4200	\N	121	50
185	Alexis	Bull	ABULL	650.509.2876	1997-02-20 00:00:00	SH_CLERK	4100	\N	121	50
186	Julia	Dellinger	JDELLING	650.509.3876	1998-06-24 00:00:00	SH_CLERK	3400	\N	121	50
187	Anthony	Cabrio	ACABRIO	650.509.4876	1999-02-07 00:00:00	SH_CLERK	3000	\N	121	50
188	Kelly	Chung	KCHUNG	650.505.1876	1997-06-14 00:00:00	SH_CLERK	3800	\N	122	50
189	Jennifer	Dilly	JDILLY	650.505.2876	1997-08-13 00:00:00	SH_CLERK	3600	\N	122	50
190	Timothy	Gates	TGATES	650.505.3876	1998-07-11 00:00:00	SH_CLERK	2900	\N	122	50
191	Randall	Perkins	RPERKINS	650.505.4876	1999-12-19 00:00:00	SH_CLERK	2500	\N	122	50
192	Sarah	Bell	SBELL	650.501.1876	1996-02-04 00:00:00	SH_CLERK	4000	\N	123	50
193	Britney	Everett	BEVERETT	650.501.2876	1997-03-03 00:00:00	SH_CLERK	3900	\N	123	50
194	Samuel	McCain	SMCCAIN	650.501.3876	1998-07-01 00:00:00	SH_CLERK	3200	\N	123	50
195	Vance	Jones	VJONES	650.501.4876	1999-03-17 00:00:00	SH_CLERK	2800	\N	123	50
196	Alana	Walsh	AWALSH	650.507.9811	1998-04-24 00:00:00	SH_CLERK	3100	\N	124	50
197	Kevin	Feeney	KFEENEY	650.507.9822	1998-05-23 00:00:00	SH_CLERK	3000	\N	124	50
198	Donald	OConnell	DOCONNEL	650.507.9833	1999-06-21 00:00:00	SH_CLERK	2600	\N	124	50
199	Douglas	Grant	DGRANT	650.507.9844	2000-01-13 00:00:00	SH_CLERK	2600	\N	124	50
200	Jennifer	Whalen	JWHALEN	515.123.4444	1987-09-17 00:00:00	AD_ASST	4400	\N	101	10
201	Michael	Hartstein	MHARTSTE	515.123.5555	1996-02-17 00:00:00	MK_MAN	13000	\N	100	20
202	Pat	Fay	PFAY	603.123.6666	1997-08-17 00:00:00	MK_REP	6000	\N	201	20
203	Susan	Mavris	SMAVRIS	515.123.7777	1994-06-07 00:00:00	HR_REP	6500	\N	101	40
204	Hermann	Baer	HBAER	515.123.8888	1994-06-07 00:00:00	PR_REP	10000	\N	101	70
205	Shelley	Higgins	SHIGGINS	515.123.8080	1994-06-07 00:00:00	AC_MGR	12000	\N	101	110
206	William	Gietz	WGIETZ	515.123.8181	1994-06-07 00:00:00	AC_ACCOUNT	8300	\N	205	110
\.


--
-- Data for Name: job_history; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY job_history (employee_id, start_date, end_date, job_id, department_id) FROM stdin;
102	1993-01-13 00:00:00	1998-07-24 00:00:00	IT_PROG	60
101	1989-09-21 00:00:00	1993-10-27 00:00:00	AC_ACCOUNT	110
101	1993-10-28 00:00:00	1997-03-15 00:00:00	AC_MGR	110
201	1996-02-17 00:00:00	1999-12-19 00:00:00	MK_REP	20
114	1998-03-24 00:00:00	1999-12-31 00:00:00	ST_CLERK	50
122	1999-01-01 00:00:00	1999-12-31 00:00:00	ST_CLERK	50
200	1987-09-17 00:00:00	1993-06-17 00:00:00	AD_ASST	90
176	1998-03-24 00:00:00	1998-12-31 00:00:00	SA_REP	80
176	1999-01-01 00:00:00	1999-12-31 00:00:00	SA_MAN	80
200	1994-07-01 00:00:00	1998-12-31 00:00:00	AC_ACCOUNT	90
\.


--
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY jobs (job_id, job_title, min_salary, max_salary) FROM stdin;
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
\.


--
-- Data for Name: locations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY locations (location_id, street_address, postal_code, city, state_province, country_id) FROM stdin;
1000	1297 Via Cola di Rie	00989	Roma	\N	IT
1100	93091 Calle della Testa	10934	Venice	\N	IT
1200	2017 Shinjuku-ku	1689	Tokyo	Tokyo Prefecture	JP
1300	9450 Kamiya-cho	6823	Hiroshima	\N	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	\N	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	\N	SG
2400	8204 Arthur St	\N	London	\N	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
\.


--
-- Data for Name: regions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY regions (region_id, region_name) FROM stdin;
1	Europe
2	Americas
3	Asia
4	Middle East and Africa
\.


--
-- Name: countries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY countries
    ADD CONSTRAINT countries_pkey PRIMARY KEY (country_id);


--
-- Name: departments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY departments
    ADD CONSTRAINT departments_pkey PRIMARY KEY (department_id);


--
-- Name: employees_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY employees
    ADD CONSTRAINT employees_email_key UNIQUE (email);


--
-- Name: employees_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY employees
    ADD CONSTRAINT employees_pkey PRIMARY KEY (employee_id);


--
-- Name: job_history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY job_history
    ADD CONSTRAINT job_history_pkey PRIMARY KEY (employee_id, start_date);


--
-- Name: jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (job_id);


--
-- Name: locations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY locations
    ADD CONSTRAINT locations_pkey PRIMARY KEY (location_id);


--
-- Name: regions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY regions
    ADD CONSTRAINT regions_pkey PRIMARY KEY (region_id);


--
-- Name: dept_location_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX dept_location_ix ON departments USING btree (location_id);


--
-- Name: emp_department_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX emp_department_ix ON employees USING btree (department_id);


--
-- Name: emp_job_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX emp_job_ix ON employees USING btree (job_id);


--
-- Name: emp_manager_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX emp_manager_ix ON employees USING btree (manager_id);


--
-- Name: emp_name_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX emp_name_ix ON employees USING btree (last_name, first_name);


--
-- Name: jhist_department_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX jhist_department_ix ON job_history USING btree (department_id);


--
-- Name: jhist_employee_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX jhist_employee_ix ON job_history USING btree (employee_id);


--
-- Name: jhist_job_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX jhist_job_ix ON job_history USING btree (job_id);


--
-- Name: loc_city_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX loc_city_ix ON locations USING btree (city);


--
-- Name: loc_country_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX loc_country_ix ON locations USING btree (country_id);


--
-- Name: loc_state_province_ix; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX loc_state_province_ix ON locations USING btree (state_province);


--
-- Name: countr_reg_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY countries
    ADD CONSTRAINT countr_reg_fk FOREIGN KEY (region_id) REFERENCES regions(region_id);


--
-- Name: dept_loc_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY departments
    ADD CONSTRAINT dept_loc_fk FOREIGN KEY (location_id) REFERENCES locations(location_id);


--
-- Name: dept_mgr_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY departments
    ADD CONSTRAINT dept_mgr_fk FOREIGN KEY (manager_id) REFERENCES employees(employee_id);


--
-- Name: emp_dept_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY employees
    ADD CONSTRAINT emp_dept_fk FOREIGN KEY (department_id) REFERENCES departments(department_id);


--
-- Name: emp_job_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY employees
    ADD CONSTRAINT emp_job_fk FOREIGN KEY (job_id) REFERENCES jobs(job_id);


--
-- Name: emp_manager_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY employees
    ADD CONSTRAINT emp_manager_fk FOREIGN KEY (manager_id) REFERENCES employees(employee_id);


--
-- Name: jhist_dept_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY job_history
    ADD CONSTRAINT jhist_dept_fk FOREIGN KEY (department_id) REFERENCES departments(department_id);


--
-- Name: jhist_emp_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY job_history
    ADD CONSTRAINT jhist_emp_fk FOREIGN KEY (employee_id) REFERENCES employees(employee_id);


--
-- Name: jhist_job_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY job_history
    ADD CONSTRAINT jhist_job_fk FOREIGN KEY (job_id) REFERENCES jobs(job_id);


--
-- Name: loc_c_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY locations
    ADD CONSTRAINT loc_c_id_fk FOREIGN KEY (country_id) REFERENCES countries(country_id);


--
-- PostgreSQL database dump complete
--

