studyproject

테이블 (4)

부서 (Dept)

  • departementNum (dept_num) — INT — 기본 키 — NOT NULL
  • departmentName (dept_name) — VARCHAR
  • team — INT

사원 (Emp)

  • employeeNum (emp_num) — INT — 기본 키 — NOT NULL
  • employeeName (emp_name) — VARCHAR
  • age — VARCHAR
  • email — VARCHAR
  • hireDate — TIMESTAMP
  • phoneNum (phone_num) — VARCHAR
  • managerNum — INT
  • departementNum (dept_num) — INT — 외래 키 → 부서.departementNum — NOT NULL
  • gradeNum (grade_num) — INT — 외래 키 → 직급.gradeNum — NOT NULL
  • jobNum (job_num) — INT — 외래 키 → 직무.jobNum — NOT NULL

직급 (Grade)

  • gradeNum (grade_num) — INT — 기본 키 — NOT NULL
  • gradeName — VARCHAR

직무 (Job)

  • jobNum (job_num) — INT — 기본 키 — NOT NULL
  • jobName (job_name) — VARACHAR