approvalLineERD
Tables (6)
approval (결재)
- id — bigint — Primary key — NOT NULL
- requesterId (Field) — bigint
- requestType — varchar(50) — NOT NULL
- requestTypeId (reuqestId) — bigint — NOT NULL — id, zoneList, 배포정보로 JSON으로 묶음
- createDateTime — datetime — 생성날짜
- title — varchar(100) — 결재요청명
- aqpprovalStatus — varchar(50) — 결재상태
- description — longtext — 결재설명
approval_result (결재 프로세스)
- id — bigint — Primary key — NOT NULL
- arrovalId — bigint — Foreign key → approval.id — NOT NULL
- approverType (Field2)
- approverTypeId (Field) — bigint
- approvedUserId (Field4) — bigint
- approvalOrder — int — NOT NULL — 결재 라인 순서
- comment — VARCHAR(500) — 결재자 코멘트
- approvalResultStatus (approvalProcessStatus) — VARCHAR(20) — NOT NULL — 결재 상태 (WAIT_ANSWER,NOT_ANSWER, APPROVED, REJECTED)
- approvedDateTime — datetime — 승인된 날짜 값
- candidatesApprovers (Field3) — JSON(LIST
approver (결재자)
- id — bigint — Primary key — NOT NULL
- defaultApprovalStepId (defaultApprovalLineId) — bigint — Foreign key → default_approval_step.id — NOT NULL
- approverType — varchar(20) — NOT NULL
- approverTargetId — bigint
default_approval_config (결재라인config)
- id — bigint — Primary key — NOT NULL
- defaultApprovalName (Field6) — VARCHAR(50)
- createDateTime (Field5) — datetime
- lastUpdateTime (Field) — datetime
- description (Field2) — VARCHAR(500)
- creatorId (Field4)
- deletable (Field3)
default_approval_step (결재라인)
- id — bigint — Primary key — NOT NULL
- defaultApprovalConfigId (id2) — bigint — Foreign key → default_approval_config.id — NOT NULL
- approvalOrder — int — NOT NULL
- approvalStepName — VARCHAR(100)
default_approval_target (결재라인정보)
- id — bigint — Primary key — NOT NULL
- defaultApprovalConfigId — bigint — Foreign key → default_approval_config.id — NOT NULL
- defaultApprovalType — varchar(50) — NOT NULL
- requestTargetInfo — JSON — NOT NULL — id, zoneList, 배포정보로 JSON으로 묶음
- categoryId — bigint