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