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