인사관리 시스템 ERD

테이블 (5)

ATTENDANCE

  • Key — 기본 키 — NOT NULL
  • attend_id — INT
  • emp_id — INT — 외래 키 → EMPLOYEE.emp_id — NOT NULL
  • work_date — DATE — NOT NULL
  • check_in — TIME
  • check_out — TIME
  • status — VARCHAR(10)

DEPARTMENT

  • dept_id — INT
  • dept_name — VARCHAR(50) — NOT NULL
  • manager_id — INT — 외래 키 → EMPLOYEE.emp_id

EMPLOYEE

  • emp_id — INT
  • name — VARCHAR(30) — NOT NULL
  • birth_date — DATE
  • hire_date — DATE
  • phone — VARCHAR(20)
  • email — VARCHAR(50)
  • dept_id — INT — 외래 키 → DEPARTMENT.dept_id — NOT NULL
  • position_id — INT — 외래 키 → POSITION.position_id — NOT NULL
  • status — VARCHAR(10)

POSITION

  • position_id — INT
  • position_name — VARCHAR(30) — NOT NULL
  • level — INT

WORK_HISTORY

  • history_id — INT
  • emp_id — INT — 외래 키 → EMPLOYEE.emp_id — NOT NULL
  • dept_id — INT — 외래 키 → DEPARTMENT.dept_id
  • position_id — INT — 외래 키 → POSITION.position_id
  • change_date — DATE — NOT NULL
  • change_type — VARCHAR(20)