근태관리
테이블 (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