HR_presentation

Tables (4)

attendance

  • pk — Primary key — NOT NULL
  • 아이디 (id) — Foreign key → employees.아이디 — NOT NULL
  • 날짜 (date)
  • 출퇴근 (clock_in_out)
  • 시각 (time)

employees

  • 아이디 (id) — Primary key — NOT NULL
  • 이름 (name)
  • 부서 (department)
  • 직급 (position)
  • 주소 (address)
  • 전화번호 (phone)
  • 사진 (photo)
  • 입사일 (join_date)

leave_requests

  • pk — Primary key — NOT NULL
  • 아이디 (id) — Foreign key → employees.아이디 — NOT NULL
  • 휴가시작 (start_date)
  • 휴가끝 (end_date)
  • 사유 (reason)
  • 승인상태 (status)

salary

  • pk — Primary key — NOT NULL
  • 아이디 (id) — Foreign key → employees.아이디 — NOT NULL
  • 부서 (department)
  • 직급 (position)
  • 근속년수 (year)
  • 실급여 (total_salary)