선한병원 전자결재 시스템 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