인사관리

테이블 (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