인사관리
테이블 (8)
Attendance (근태관리)
- attendance_id (Key) — INT — 기본 키 — NOT NULL
- date (Field) — DATE
- check_in (Field2) — TIME
- check_out (Field3) — TIME
- status (Field4) — ENUM
- memo (Field5) — varchar
- emp_id (Key2) — INT — 외래 키 → employees.emp_id — NOT NULL
Department_transfer_history (부서이동이력)
- transfer_id (Key) — INT — 기본 키 — NOT NULL
- transfer_date (Field) — DATE
- reason (Field2) — VARCHAR
- emp_id (Key2) — INT — 외래 키 → employees.emp_id — NOT NULL
- department_id (Key3) — INT — 외래 키 → Departments.department_id — NOT NULL
Departments (조직관리)
- department_id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — varchar
- parent_id (Field2) — INT
- leader_id (Field3) — INT
- created_at (Field4) — DATETIME
Employee_history (인사이력)
- history_id (Key) — INT — 기본 키 — NOT NULL
- position (Field) — varchar
- change_date (Field2) — DATE
- emp_id (Key2) — INT — 외래 키 → employees.emp_id — NOT NULL
Leaves (휴가 및 연차)
- leave_id (Key) — INT — 기본 키 — NOT NULL
- leave_type (Field) — ENUM
- start_date (Field2) — DATE
- end_date (Field3) — DATE
- reason (Field4) — varchar
- status (Field5) — ENUM
- requested_at (Field6) — DATE
- emp_id (Key2) — INT — 외래 키 → employees.emp_id — NOT NULL
Schedule (일정관리)
- schedule_id (Key) — INT — 기본 키 — NOT NULL
- title (Field) — VARCHAR
- description (Field2) — TEXT
- start_time (Field3) — DEATTIME
- end_time (Field4) — DATETIME
- is_all_day (Field5) — BOOLEAN
- repeat_type (Field6) — ENUM
- shared_with (Field7) — TEXT
- created-at (Field8) — DATETIME
- created_by (Field9) — INT
employees (인사관리)
- emp_id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — varchar
- phone (Field2) — varchar
- address (Field3) — varchar
- hire_date (Field4) — DATE
- retire_date (Field5) — DATE
- position (Field7) — varchar
- grade (Field8) — varchar
- status (Field9) — ENUM
- role (Field10) — ENUM
- department_id (Key2) — INT — 외래 키 → Departments.department_id — NOT NULL
- schedule_id (Key3) — INT — 외래 키 → Schedule.schedule_id — NOT NULL
- approval_id (Key4) — INT — 외래 키 → leave_approval.approval_id — NOT NULL
leave_approval (연차 및 휴가 결재)
- approval_id (Key) — INT — 기본 키 — NOT NULL
- status (Field) — ENUM
- comment (Field2) — VARCHAR
- approved_at (Field3) — DATETIME
- leave_id (Key2) — INT — 외래 키 → Leaves.leave_id — NOT NULL