ApprovalProcess

Tables (10)

ApprovalTemplate (Untitled2)

  • approval__template_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • target_type (Field2) — String

ApprovalTemplateApprover (Untitled4)

  • node_approval_template_node_id (Key) — Long — Primary key — NOT NULL
  • approval_template_approver_id (Field) — int
  • userid (Field2) — int
  • approval_template_node_id (Key2) — Long — Foreign key → ApprovalTemplateNode.approval_template_node_id — NOT NULL

ApprovalTemplateNode (Untitled3)

  • approval_template_node_id (Key) — Long — Primary key — NOT NULL
  • approval_type (Field) — String
  • seq_order (Field2) — int
  • approval__template_id (Key2) — Long — Foreign key → ApprovalTemplate.approval__template_id — NOT NULL

Post (Untitled)

  • post_id (Key) — Long — Primary key — NOT NULL
  • content (Field) — String
  • status (Field2) — enum
  • ProcessInstanceId — Long — Foreign key → ProcessInstance.ProcessInstanceId — NOT NULL
  • title (Field3) — String

ProcessInstance

  • ProcessInstanceId — Long — Primary key — NOT NULL
  • targetType (Field) — String — 어떤 타입의 엔티티인지?
  • targetId (Field2) — Long — 실제 대상의 Id
  • status (Field3) — String — 현재 승인 상태
  • createdAt (Field4) — String — 요청 일시
  • createdBy (Field5) — String — 승인 요청자

ProcessInstanceHistory

  • ProcessInstanceHistoryId — Long — Primary key — NOT NULL
  • ProcessInstanceId — Long — Foreign key → ProcessInstance.ProcessInstanceId — NOT NULL

ProcessInstanceNode

  • ProcessInstanceNodeId (Key) — Long — Primary key — NOT NULL
  • ProcessInstanceId — Long — Foreign key → ProcessInstance.ProcessInstanceId — NOT NULL
  • sequenceOrder (Field) — Integer — 이 단계가 몇 번째인지
  • approvalType (Field2) — Enum(Sequencte / Parallel)
  • workItems (ProcessInstanceWorkItemId) — Long — Foreign key → ProcessInstanceWorkItem.ProcessInstanceWorkItemId — NOT NULL — 이 노드에서 승인해야 할 사람들
  • condition (Field3) — String — 노드가 실행될 조건 (선택 기능)

ProcessInstanceStep

  • Key — Primary key — NOT NULL
  • ProcessInstanceStepId — Long
  • ProcessInstanceId — Long — Foreign key → ProcessInstance.ProcessInstanceId — NOT NULL
  • ProcessInstanceNodeId — Long — Foreign key → ProcessInstanceNode.ProcessInstanceNodeId — NOT NULL
  • stepStatus (Field) — String — 승인 , 거절 , 회수 등
  • createdDate (Field2) — datetime — 행동이 일어난 시점
  • targetObjectId (Field3) — Long — 게시글 Id
  • comments (Field4) — String — 남긴 코멘트

ProcessInstanceWorkItem

  • ProcessInstanceWorkItemId — Long — Primary key — NOT NULL
  • ProcessInstanceNodeId (Key) — Long — Foreign key → ProcessInstanceNode.ProcessInstanceNodeId — NOT NULL
  • ProcessInstanceId — Long — Foreign key → ProcessInstance.ProcessInstanceId — NOT NULL
  • UserId — Long — Foreign key → User.UserId — NOT NULL
  • Status (Field) — ENUM(WAITING / APPROVED / REJECTED)
  • Comment (Field2) — 승인 시 남긴 코멘트
  • ActedAt (Field3) — 승인/거절한 일시

User

  • UserId — Long — Primary key — NOT NULL
  • username (Field) — String