12test

Tables (8)

Countries

  • country_id — VARCHAR(10) — Primary key — NOT NULL
  • country_name — VARCHAR(50)
  • region_id — INT — Foreign key → Regions.region_id

Departments

  • department_id — INT — Primary key — NOT NULL
  • department_name — VARCHAR(20)
  • employee_id — INT — Foreign key → Employees.employee_id
  • location_id — INT — Foreign key → Locations.location_id — NOT NULL

Employees

  • employee_id — INT — Primary key — NOT NULL
  • first_name — VARCHAR(30)
  • last_name — VARCHAR(30)
  • email — VARCHAR(30)
  • phone_number — VARCHAR(20)
  • hire_date — DATE
  • job_id — VARCHAR(10) — Foreign key → Jobs.job_id
  • salary — INT
  • commission_pct — INT
  • manager_id — INT — Foreign key → Employees.employee_id
  • department_id — INT — Foreign key → Departments.department_id

Job_grades

  • grade_level — CHAR(1) — NOT NULL
  • lowest_sal — INT — NOT NULL
  • highest_sal — INT — NOT NULL

Job_history

  • start_date — DATE — Primary key — NOT NULL — 직원의 업무 시작일
  • job_id2 — VARCHAR(10) — Foreign key → Jobs.job_id — NOT NULL
  • employee_id2 — INT — Foreign key → Employees.employee_id
  • end_date — DATE — 직원 과거 직무 종료일
  • department_id2 — INT — Foreign key → Departments.department_id

Jobs

  • job_id — VARCHAR(10) — Primary key — NOT NULL
  • job_title — VARCHAR(50) — 직무명
  • min_salary — INT — NOT NULL — 최소 급여
  • max_salary — INT — 최대 급여

Locations

  • location_id — INT — Primary key — NOT NULL
  • street_address — VARCHAR(50)
  • postal_code — VARCHAR(20)
  • city — VARCHAR(20)
  • state_province — VARCHAR(20)
  • country_id — VARCHAR(10) — Foreign key → Countries.country_id

Regions

  • region_id — INT — Primary key — NOT NULL
  • region_name — VARCHAR(30)