선한병원 전자결재 시스템 V2
테이블 (20)
결재단계 (ApprovalStep)
- Field (id) — long — 기본 키
- Field (approvalLineId) — long — 외래 키 → 결재라인.Field
- Field (deptCode) — string — 외래 키 → 부서.Field
- Field (approverId) — string — 외래 키 → 유저.Field
- Field3 (stepOrder) — int
- Field4 (stepName) — string
- Field5 (approverType) — enum
- Field (jobLevel) — string
- Field (isOptional) — boolean
결재라인 (ApprovalLine)
- Field (id) — long — 기본 키
- Field (createdBy) — string — 외래 키 → 유저.Field
- Field2 (name) — string
- Field3 (description) — string
- Field4 (documnetType) — enum
- Field (isActive) — boolean
- Field (isDeleted) — boolean
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
계약관련메모 (ContractMemo)
- Key (id) — long — 기본 키 — NOT NULL
- Field (targetUserId) — string
- Field2 (memoText) — string
- Field3 (createdBy) — String
- Field4 (createdAt) — timestamp
- Field (updatedAt) — timestamp
근로계약서 (EmploymentContract)
- Field (id) — long — 기본 키
- Field (creatorId) — string — 외래 키 → 유저.Field
- Field (employeeId) — string — 외래 키 → 유저.Field
- Field4 (status) — enum
- Field (formDataJson) — string
- Field (pdfUrl) — string
- Field (contractType) — enum
- Field (printable) — boolean
- Field (rejectReason) — string
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
근무현황표 (WorkSchedule)
- Field (id) — long — 기본 키
- Field (deptCode) — string — 외래 키 → 부서.Field
- Field (createdBy) — string — 외래 키 → 유저.Field
- Field (approvalLineId) — long — 외래 키 → 결재라인.Field
- Field3 (scheduleYearMonth) — string
- Field (currentApprovalStep) — int
- Field (approvalStatus) — enum
- Field (creatorSignatureUrl) — string
- Field (creatorSignedAt) — timestamp
- Field (remarks) — string
- Field (pdfUrl) — string
- Field (isPrintable) — boolean
- Field (isActive) — boolean
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
- Field (isFinalApproved) — boolean
- Field (finalApprovedBy) — String
- Field (finalApprovedAt) — timestamp
근무현황표 목록 (WorkScheduleEntry)
- Field (id) — long — 기본 키
- Field (userId) — string — 외래 키 → 유저.Field
- Field (workScheduleId) — long — 외래 키 → 근무현황표.Field
- Field (positionId) — long — 외래 키 → 부서에 따른 직책.Field
- Field4 (userName) — string
- Field (displayOrder) — int
- Field (workDataJson) — string
- Field (nightDutyRequired) — int
- Field (nightDutyActual) — int
- Field (nightDutyAdditional) — int
- Field (dutyDetailJson) — string
- Field (offCount) — int
- Field (vacationUsedThisMonth) — double
- Field (vacationTotal) — double
- Field (vacationUsedTotal) — double
- Field (remarks) — string
- Field (isDeleted) — boolean
근무현황표 설정(나이트모드, 당직모드) (DeptDutyConfig)
- Field (id) — long — 기본 키
- Field (scheduleId) — long — 외래 키 → 근무현황표.Field
- Field (dutyMode) — enum
- Field (displayName) — string
- Field (cellSymbol) — string
- Field (useWeekday) — boolean
- Field (useFriday) — boolean
- Field (useSaturday) — boolean
- Field (useHolidaySunday) — boolean
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
동의서 작성 인스턴스 (ConsentAgreement)
- Key (id) — long — 기본 키 — NOT NULL
- Key (consentFormId) — long — 외래 키 → 동의서 템플릿.Key — NOT NULL
- Field (targetUserId) — string
- Field (targetUserName) — string
- Field (creatorId) — string
- Field (status) — enum
- Field (formDataJson) — string
- Field (extraDataJson) — string
- Field (pdfUrl) — string
- Field (completedAt) — timestamp
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
- Field (version) — long
- Field (type) — enum
- Field (deptName) — string
- Field (phone) — string
동의서 템플릿 (ConsentForm)
- Key (id) — long — 기본 키 — NOT NULL
- Field (type) — string
- Field (title) — string
- Field (content) — string
- Field (version) — int
- Field (isActive) — boolean
- Field (requiredFields) — string
- Field2 (createdAt) — timestamp
- Field2 (createdBy) — string
- Field2 (description) — string
문서별 결재 프로세스 (DocumentApprovalProcess)
- Field (id) — long — 기본 키
- Field (applicantId) — string — 외래 키 → 유저.Field
- Field (approvalLineId) — long — 외래 키 → 결재라인.Field
- Field2 (documentId) — long
- Field3 (documentType) — enum
- Field6 (currentStepOrder) — int
- Field (status) — enum
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
부서 (Department)
- Field (deptCode) — string — 기본 키
- Field2 (deptName) — string
- Field3 (useFlag) — string
부서권한 (DeptPermissionEntity)
- Field (id) — long — 기본 키
- Field (deptCode) — string — 외래 키 → 부서.Field
- Field (permissionType) — enum
부서에 따른 직책 (Position)
- Field (id) — long — 기본 키
- Field (deptCode) — string — 외래 키 → 부서.Field
- Field3 (positionName) — string
- Field4 (displayOrder) — int
- Field5 (isActive) — boolean
- Field (createdBy) — string
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
사용자연차이력 (UserAnnualVacationHistory)
- Key (id) — long — 기본 키 — NOT NULL
- Field (userId) — string — 외래 키 → 유저.Field
- Field (year) — int
- Field (carryoverDays) — double
- Field (regularDays) — double
- Field (usedCarryoverDays) — double
- Field (usedRegularDays) — double
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
승인단계이력 (ApprovalStepHistory)
- Field (id) — long — 기본 키
- Field (approverId) — string — 외래 키 → 유저.Field
- Field (approvalProcessId) — long — 외래 키 → 문서별 결재 프로세스.Field
- Field3 (stepOrder) — int
- Field4 (stepName) — string
- Field (approverName) — string
- Field (approverJobLevel) — string
- Field (approverDeptCode) — string
- Field (action) — enum
- Field (comment) — string
- Field (signatureLmageUrl) — string
- Field (isSigned) — boolean
- Field (actionDate) — timestamp
- Field (createdAt) — timestamp
유저 (UserEntity)
- Field (userId) — string — 기본 키
- Field2 (userName) — string
- Field3 (passwd) — string
- Field4 (jobType) — string
- Field5 (jobLevel) — string
- Field (deptCode) — string — 외래 키 → 부서.Field
- Field7 (phone) — string
- Field (address) — string
- Field (role) — string
- Field (totalVacationDays) — double
- Field (usedVacationDays) — double
- Field (privacyConsent) — boolean
- Field (notificationConsent) — boolean
- Field (createdAt) — timestamp
유저권한 (UserPermissionEntity)
- Field (id) — long — 기본 키
- Field (userId) — string — 외래 키 → 유저.Field
- Field (permissionType) — enum
휴가원 (LeaveApplication)
- Field (id) — long — 기본 키
- Field (applicantId) — string — 외래 키 → 유저.Field
- Field (substituteId) — string — 외래 키 → 유저.Field
- Field (approvalLineId) — long — 외래 키 → 결재라인.Field
- Field4 (leaveType) — enum
- Field5 (leaveDetail) — string
- Field6 (startDate) — date
- Field7 (endDate) — date
- Field8 (totalDays) — double
- Field (applicationDate) — date
- Field (status) — enum
- Field (approvalHistory) — string
- Field (formDataJson) — string
- Field (rejectionReason) — string
- Field (finalApproverId) — string
- Field (finalApprovalDate) — timestamp
- Field (pdfUrl) — string
- Field (printable) — boolean
- Field (createdAt) — timestamp
- Field (updatedAt) — timestamp
휴가원 증빙 파일 (LeaveApplicationAttachment)
- Field (id) — long — 기본 키
- Field (leaveApplicationId) — long — 외래 키 → 휴가원.Field
- Field3 (originalFileName) — string
- Field4 (storedFilePath) — string
- Field5 (fileType) — string
- Field (fileSzie) — long
휴가일별상세 (LeaveApplicationDay)
- Key (id) — long — 기본 키 — NOT NULL
- Field (leaveApplicationId) — long — 외래 키 → 휴가원.Field
- Field (date) — date
- Field (half_day_type) — varchar(20)
- Field (days) — double
- Field