인사관리 시스템 ERD
테이블 (5)
ATTENDANCE
- 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)