econrich

Tables (7)

countries (Untitled)

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

departments (Untitled5)

  • department_id (Key) — Long — Primary key — NOT NULL
  • department_name (Field) — String
  • manager_id (Key3) — Long — Foreign key → employees.employee_id — NOT NULL
  • location_id (Key2) — Long — Foreign key → locations.location_id — NOT NULL

employees (Untitled4)

  • employee_id (Key) — Long — Primary key — NOT NULL
  • manager_id (Key2) — Long — Foreign key → employees.employee_id — NOT NULL
  • first_name (Field) — String
  • last_name (Field2) — String
  • email (Field3) — String
  • phone_number (Field4) — String
  • hire_date (Field5) — Date
  • salary (Field6) — Long
  • commission_pct (Field7) — Long
  • job_id (Key3) — String — Foreign key → jobs.job_id — NOT NULL
  • department_id (Key4) — Long — Foreign key → departments.department_id — NOT NULL

job_history (Untitled7)

  • start_date (Key2) — Date — Primary key — NOT NULL
  • employee_id (Key) — Long — Foreign key → employees.employee_id — NOT NULL
  • end_date (Field2) — Date
  • job_id (Key3) — String — Foreign key → jobs.job_id — NOT NULL
  • department_id (Key4) — Long — Foreign key → departments.department_id — NOT NULL

jobs (Untitled2)

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

locations (Untitled6)

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

regions (Untitled3)

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