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