hr
Tables (6)
countries
- country_id — CHAR(2) — Primary key — NOT NULL
- country_name — VARCHAR(40)
- region_id — INT — NOT NULL
departments
- department_id — INT — Primary key — NOT NULL
- department_name — VARCHAR(30) — NOT NULL
- manager_id — INT — Foreign key → employees.employee_id
- location_id — INT
employees
- employee_id — INT — Primary key — NOT NULL
- first_name — VARCHAR(20)
- last_name — VARCHAR(25) — NOT NULL
- email — VARCHAR(25) — NOT NULL
- phone_number — VARCHAR(20)
- hire_date — DATE — NOT NULL
- job_id — VARCHAR(10) — NOT NULL
- salary — DECIMAL(8, 2) — NOT NULL
- commission_pct — DECIMAL(2, 2)
- manager_id — INT
- department_id — INT
job_history
- employee_id — INT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- job_id — VARCHAR(10) — NOT NULL
- department_id — INT — NOT NULL
jobs
- job_id — VARCHAR(10) — Primary key — NOT NULL
- job_title — VARCHAR(35) — NOT NULL
- min_salary — DECIMAL(8, 0)
- max_salary — DECIMAL(8, 0)
locations
- location_id — INT — Primary key — NOT NULL
- street_address — VARCHAR(40)
- postal_code — VARCHAR(12)
- city — VARCHAR(30) — NOT NULL
- state_province — VARCHAR(25)
- country_id — CHAR(2) — NOT NULL