employees

Tables (4)

departments (Untitled4)

  • 부서아이디 (department_id) — INT — Primary key — NOT NULL
  • 부서이름 (department_name) — VARCHAR(30) — NOT NULL
  • 매니저아이디 (manager_id) — INT
  • Field

employees (Untitled)

  • 사원번호 (employee_id) — INT — Primary key — NOT NULL
  • 직업아이디 (job_id) — VARCHAR(10) — Foreign key → jobs.직업아이디 — NOT NULL
  • 사수번호 (manager_id) — INT — Foreign key → employees.사원번호 — NOT NULL
  • 부서아이디 (department_id) — INT — Foreign key → departments.부서아이디 — NOT NULL
  • 이름 (first_name) — VARCHAR(20)
  • 이름 (last_name) — VARCHAR(25) — NOT NULL
  • 이메일 (email) — VARCHAR(25) — NOT NULL
  • 번호 (phone_number) — VARCHAR(20)
  • 급여 (salary) — DECIMAL(8,2)
  • (commission_pct) — DECIMAL(2,2)
  • 고용일 (hire_date) — DATE — NOT NULL
  • Field

job_history (Untitled3)

  • 시작일 (start_date) — DATE — Primary key — NOT NULL
  • 사원번호 (employee_id) — INT — Foreign key → employees.사원번호 — NOT NULL
  • 직업아이디 (job_id) — VARCHAR(10) — Foreign key → jobs.직업아이디 — NOT NULL
  • 부서아이디 (department_id) — INT — Foreign key → departments.부서아이디 — NOT NULL
  • 종료일 (end_date) — NOT NULL

jobs (Untitled2)

  • 직업아이디 (job_id) — VARCHAR(10) — Primary key — NOT NULL
  • 직업이름 (job_title) — VARCHAR(35) — NOT NULL
  • 최소급여 (min_salary) — INT
  • 최대급여 (max_salary) — INT