Request

Tables (3)

Department

  • dept_id — Long — Primary key — NOT NULL
  • head — Long — Foreign key → Employee.employee_id — 부서장은 NULL값 가능. 인사팀에서 처리할 수 있다.
  • parent_dept — ong — 상위 부서는 여러 개의 하위 부서 가질 수 있기에 N:1
  • dept_name — String
  • location — String

Employee

  • employee_id — Long — Primary key — NOT NULL
  • Key (dept_id) — Long — Foreign key → Department.dept_id — NOT NULL
  • employee_id (manager_id) — Long — Foreign key → Employee.employee_id — NOT NULL
  • login_id — String — NOT NULL
  • password — String — NOT NULL
  • name — String — NOT NULL
  • profile — String — 프로필 이미지 설정. 이후 마이페이지에서 설정
  • date_of_birth — String — NOT NULL
  • phone_number — String — NOT NULL
  • role — String — 토큰 값이기에 따로 지정 X
  • salary — Long

LeaveRequest

  • Key (leaveRequestId) — Long — Primary key — NOT NULL
  • employee_id — Long — Foreign key → Employee.employee_id — NOT NULL
  • Key (appover_id) — Long — Foreign key → Employee.Key — NOT NULL
  • Field (work_type) — String(Enum) — NOT NULL
  • Field2 (start_date) — LocalDate — NOT NULL
  • Field3 (end_date) — LocalDate — NOT NULL
  • Field4 (status) — String(Enum) — NOT NULL — APPROVED, REJECTED
  • Field (reason) — String