hr

Tables (8)

COUNTRIES (Untitled7)

  • country_id (Key) — Primary key — NOT NULL
  • country_name (Field)
  • region_id (Key2) — Foreign key → REGIONS.region_id — NOT NULL

DEPARTMENTS (Untitled)

  • department_id (Key) — Primary key — NOT NULL
  • department_name (Field)
  • manager_id (Field2)
  • location_id (Key2) — Foreign key → LOCATIONS.location_id — NOT NULL

EMPLOYEES (Untitled2)

  • employee_id (Key) — Primary key — NOT NULL
  • department_id (Key2) — Foreign key → DEPARTMENTS.department_id — NOT NULL
  • job_id (Key3) — Foreign key → JOBS.job_id — NOT NULL
  • first_name (Field)
  • last_name (Field2)
  • email (Field3)
  • phone_number (Field4)
  • hire_date (Field5)
  • salary (Field7)
  • commission_pct (Field8)
  • manager_id (Field9)

JOBS (Untitled3)

  • job_id (Key) — Primary key — NOT NULL
  • job_title (Field)
  • min_salary (Field2)
  • max_salary (Field3)

JOB_GRADES (Untitled5)

  • grade_level (Field)
  • lowest_sal (Field2)
  • highest_sal (Field3)

JOB_HISTORY (Untitled4)

  • start_date (Key2) — Primary key — NOT NULL
  • job_id (Key3) — Foreign key → JOBS.job_id — NOT NULL
  • department_id (Key4) — Foreign key → DEPARTMENTS.department_id — NOT NULL
  • employee_id (Key) — Foreign key → EMPLOYEES.employee_id — NOT NULL
  • end_date (Field)

LOCATIONS (Untitled6)

  • location_id (Key) — Primary key — NOT NULL
  • street_address (Field)
  • postal_code (Field2)
  • city (Field3)
  • state_province (Field4)
  • country_id (Key2) — Foreign key → COUNTRIES.country_id — NOT NULL

REGIONS (Untitled8)

  • region_id (Key) — Primary key — NOT NULL
  • region_name (Field)