근태관리

테이블 (24)

accessAuthorities

  • departmentInfoEntityDepartmentId — uuid — 기본 키 — NOT NULL
  • userEntityUserId — uuid — 기본 키 — NOT NULL

approval_history_info_entity

  • historyId — uuid — 기본 키 — NOT NULL
  • action — varchar(20) — NOT NULL
  • actionAt — timestamp — NOT NULL
  • comments — text
  • actionByUserId — uuid
  • requestRequestId — uuid

approval_request_base_info_entity

  • requestId — uuid — 기본 키 — NOT NULL
  • requestType — varchar(50) — NOT NULL
  • requestTitle — text — NOT NULL
  • requestContent — text — NOT NULL
  • status — varchar(20) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • type — varchar — NOT NULL
  • requesterUserId — uuid
  • dataSnapshotDataSnapshotId — uuid

approval_step_info_entity

  • stepId — uuid — 기본 키 — NOT NULL
  • stepOrder — int4 — NOT NULL
  • status — varchar(20) — NOT NULL
  • reason — varchar(200)
  • approverUserId — uuid
  • requestRequestId — uuid

attendance_type_entity

  • attendanceTypeId — uuid — 기본 키 — NOT NULL
  • title — varchar — NOT NULL
  • workTime — int4 — NOT NULL
  • isRecognizedWorkTime — bool — NOT NULL
  • startWorkTime — varchar
  • endWorkTime — varchar
  • deductedAnnualLeave — float8 — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL

base_notification_entity

  • notificationId — uuid — 기본 키 — NOT NULL
  • title — varchar — NOT NULL
  • content — varchar — NOT NULL
  • createdAt — timestamp — NOT NULL
  • isRead — bool — NOT NULL
  • status — text
  • type — varchar — NOT NULL
  • userId — uuid
  • requestId — uuid

daily_event_summary_entity

  • dailyEventSummaryId — uuid — 기본 키 — NOT NULL
  • date — date — NOT NULL
  • isHoliday — bool — NOT NULL
  • enter — varchar
  • leave — varchar
  • realEnter — varchar
  • realLeave — varchar
  • isChecked — bool — NOT NULL
  • isLate — bool — NOT NULL
  • isEarlyLeave — bool — NOT NULL
  • isAbsent — bool — NOT NULL
  • workTime — int4
  • note — varchar
  • employeeEmployeeId — uuid

data_snapshot_child_info_entity

  • dataSnapshotChildId — uuid — 기본 키 — NOT NULL
  • employeeId — varchar — NOT NULL
  • employeeName — varchar — NOT NULL
  • employeeNumber — varchar — NOT NULL
  • yyyy — varchar — NOT NULL
  • mm — varchar — NOT NULL
  • snapshotData — json — NOT NULL
  • createdAt — timestamp — NOT NULL
  • parentSnapshotDataSnapshotId — uuid

data_snapshot_info_entity

  • dataSnapshotId — uuid — 기본 키 — NOT NULL
  • snapshotName — varchar — NOT NULL
  • description — varchar — NOT NULL
  • snapshotType — text — NOT NULL
  • yyyy — varchar — NOT NULL
  • mm — varchar — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • departmentId — uuid

department_employee_entity

  • departmentEmployeeId — uuid — 기본 키 — NOT NULL
  • departmentDepartmentId — uuid
  • employeeEmployeeId — uuid

department_info_entity

  • departmentId — uuid — 기본 키 — NOT NULL
  • departmentName — varchar — NOT NULL
  • isExclude — bool — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • departmentCode — varchar
  • mmsDepartmentId — varchar
  • parentDepartmentId — uuid
  • orgChartInfoId — uuid

employee_annual_leave_entity

  • annualLeaveId — uuid — 기본 키 — NOT NULL
  • year — int4 — NOT NULL
  • fiscalYearTotalLeave — float8 — NOT NULL
  • currentFiscalYearLeave — float8 — NOT NULL
  • entryDateBasedTotalLeave — int4 — NOT NULL
  • usedAnnualLeave — float8 — NOT NULL
  • birthDayLeaveStatus — text — NOT NULL
  • birthDayLeaveDetails — text
  • note — varchar
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • isAdjusted — bool — NOT NULL
  • employeeId — uuid
  • remainedAnnualLeave — float8 — NOT NULL

employee_info_entity

  • employeeId — uuid — 기본 키 — NOT NULL
  • employeeName — varchar
  • employeeNumber — varchar — NOT NULL
  • email — varchar
  • entryAt — date
  • birthDate — date
  • quitedAt — varchar
  • isExcludedFromCalculation — bool — NOT NULL
  • departmentId — uuid

event_info_entity

  • eventId — uuid — 기본 키 — NOT NULL
  • employeeName — varchar — NOT NULL
  • employeeNumber — varchar
  • eventTime — varchar — NOT NULL
  • yyyymmdd — varchar — NOT NULL
  • hhmmss — varchar — NOT NULL

excel_import_process_entity

  • excelImportProcessId — uuid — 기본 키 — NOT NULL
  • departmentInfoJson — json — NOT NULL
  • employeeInfoJson — json — NOT NULL
  • dataJson — json — NOT NULL
  • extractedExcelDataList — text
  • status — varchar — NOT NULL
  • year — varchar — NOT NULL
  • month — varchar — NOT NULL
  • eventInfoFileId — varchar
  • usedAttendanceFileId — varchar
  • createdAt — timestamp — NOT NULL
  • userId — uuid

file_entity

  • fileId — uuid — 기본 키 — NOT NULL
  • fileName — varchar — NOT NULL
  • fileOriginalName — varchar
  • filePath — varchar — NOT NULL
  • year — varchar
  • month — varchar
  • readAt — varchar
  • status — varchar — NOT NULL
  • error — varchar
  • uploadBy — varchar — NOT NULL
  • uploadedAt — timestamp — NOT NULL

holiday_info_entity

  • holidayId — uuid — 기본 키 — NOT NULL
  • holidayName — varchar — NOT NULL
  • holidayDate — varchar — NOT NULL

monthly_employee_attendance_info_entity

  • monthlyEventSummaryId — uuid — 기본 키 — NOT NULL
  • employeeNumber — varchar — NOT NULL
  • employeeId — varchar — NOT NULL
  • employeeName — varchar
  • yyyymm — varchar — NOT NULL
  • note — varchar
  • additionalNote — varchar — NOT NULL
  • workDaysCount — int4 — NOT NULL
  • totalWorkableTime — int4
  • totalWorkTime — int4 — NOT NULL
  • avgWorkTimes — float8 — NOT NULL
  • attendanceTypeCount — text — NOT NULL
  • dailyEventSummary — text
  • weeklyWorkTimeSummary — text
  • lateDetails — text
  • absenceDetails — text
  • earlyLeaveDetails — text
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL

organization_chart_info_entity

  • orgChartInfoId — uuid — 기본 키 — NOT NULL
  • isSupport — bool — NOT NULL
  • positionX — float8
  • positionY — float8

query-result-cache

  • id — serial4 — 기본 키 — NOT NULL
  • identifier — varchar
  • time — int8 — NOT NULL
  • duration — int4 — NOT NULL
  • query — text — NOT NULL
  • result — text — NOT NULL

reviewAuthorities

  • departmentInfoEntityDepartmentId — uuid — 기본 키 — NOT NULL
  • userEntityUserId — uuid — 기본 키 — NOT NULL

system_variable_info_entity

  • systemVariableId — uuid — 기본 키 — NOT NULL
  • systemVariableName — varchar — NOT NULL
  • systemVariableValue — varchar — NOT NULL

used_attendance_entity

  • usedAttendanceId — uuid — 기본 키 — NOT NULL
  • usedAt — varchar — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • employeeId — uuid
  • attendanceTypeId — uuid

user_entity

  • userId — uuid — 기본 키 — NOT NULL
  • username — varchar — NOT NULL
  • password — varchar — NOT NULL
  • email — varchar
  • roles — text — NOT NULL
  • isActive — bool — NOT NULL
  • isIntegrated — bool — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • type — varchar — NOT NULL
  • mongoId — varchar
  • isEvaluator — bool
  • isInterviewer — bool
  • isRequiredNotifier — bool
  • hasAccessAuthority — bool
  • hasReviewAuthority — bool