ㅁ

Tables (7)

countries

  • country_id — CHAR(2) — Primary key — NOT NULL
  • region_id (region_id2) — NUMBER — Foreign key → regions.region_id — NOT NULL
  • country_name — VARCHAR2(40)
  • region_id — NUMBER

departments

  • department_id — NUMBER — Primary key — NOT NULL
  • department_name — VARCHAR2(30) — NOT NULL
  • manager_id — NUMBER
  • location_id — NUMBER

employees

  • employee_id — NUMBER — Primary key — NOT NULL
  • first_name — VARCHAR2(20)
  • last_name — VARCHAR2(25) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • phone_number — VARCHAR2(20)
  • hire_date — DATE — NOT NULL
  • job_id — VARCHAR2(10) — NOT NULL
  • salary — NUMBER
  • commission_pct — NUMBER
  • manager_id — NUMBER
  • department_id — NUMBER

job_history

  • employee_id — NUMBER — Primary key — NOT NULL
  • start_date — DATE — Primary key — NOT NULL
  • end_date — DATE — NOT NULL
  • job_id — VARCHAR2(10) — NOT NULL
  • department_id — NUMBER — NOT NULL

jobs

  • job_id — VARCHAR2(10) — Primary key — NOT NULL
  • job_title — VARCHAR2(35) — NOT NULL
  • min_salary — NUMBER
  • max_salary — NUMBER

locations

  • location_id — NUMBER — Primary key — NOT NULL
  • country_id (country_id2) — CHAR(2) — Foreign key → countries.country_id — NOT NULL
  • region_id (region_id2) — NUMBER — Foreign key → countries.region_id — NOT NULL
  • street_address — VARCHAR2(40)
  • postal_code — VARCHAR2(12)
  • city — VARCHAR2(30) — NOT NULL
  • state_province — VARCHAR2(25)
  • country_id — CHAR(2)

regions

  • region_id — NUMBER — Primary key — NOT NULL
  • region_name — VARCHAR2(25)