Workflow ERD

Tables (11)

ActivityActions (Activity 매핑 테이블)

  • Id (activity_action_id) — NOTNULL — Primary key — NOT NULL
  • Id (instance_action_id) — Foreign key → InstanceActions.Id — NOT NULL
  • Id (activity_id) — NOTNULL — Foreign key → Acvities.Id — NOT NULL

Acvities (Activity 데이터)

  • Id (activity_id) — NOTNULL — Primary key — NOT NULL
  • StatusId (status_id) — NOTNULL — Foreign key → Status.Id — NOT NULL
  • TemplateId (template_id) — NOTNULL — Foreign key → Templates.Id — NOT NULL

Assignees (Assignee 매핑 테이블)

  • Id (assignee_id) — NOTNULL — Primary key — NOT NULL
  • InstanceActionId (instance_action_id) — NOTNULL — Foreign key → InstanceActions.Id — NOT NULL
  • UserId (user_id) — NOTNULL — Foreign key → Users.Id — NOT NULL

InstanceActions (인스턴스 행위 목록)

  • Id (instance_action_id) — Primary key — NOT NULL
  • InstanceId (instance_id) — NOTNULL — Foreign key → Instances.Id — NOT NULL
  • Status (Field)
  • Comment (instance_comment) — NULL
  • IsCompleted (instance_completed) — NOTNULL

Instances (인스턴스)

  • Id (instance_id) — NOTNULL — Primary key — NOT NULL
  • TemplateId (template_id) — NOTNULL — Foreign key → Templates.Id — NOT NULL
  • Creator (instance_creator) — NOT NULL
  • ModelId (model_id) — NOTNULL — Foreign key → Models.Id — NOT NULL

Models (워크플로우대상데이터)

  • Id (model_id) — NOTNULL — Primary key — NOT NULL
  • Name (model_name) — NULL
  • StautsName (model_statusname) — NULL — string 으로 가져가는게 맞나
  • WorkflowId (instance_id) — NOTNULL — Foreign key → Instances.Id — NOT NULL
  • StatusId (status_id) — NOTNULL — Foreign key → Status.Id — NOT NULL
  • TrackerId (tracker_id) — NOTNULL — Foreign key → Trackers.Id — NOT NULL

Status (생성된 Status 목록)

  • Id (status_id) — NOTNULL — Primary key — NOT NULL
  • Name (status_name) — NULL

Templates (템플릿디자인)

  • Id (template_id) — NOTNULL — Primary key — NOT NULL
  • Name — NOTNULL
  • Activities (Field)
  • Transitions (Field2)
  • TrackerId (tracker_id) — NOTNULL — Foreign key → Trackers.Id — NOT NULL

Trackers (TrackerType 데이터)

  • Id (tracker_id) — NOTNULL — Primary key — NOT NULL
  • Name (tracker_name) — NOTNULL

Transitions (Transition 데이터)

  • Id (transition_id) — NOTNULL — Primary key — NOT NULL
  • Name (transition_name) — NOTNULL
  • TemplateId (template_id) — NOTNULL — Foreign key → Templates.Id — NOT NULL
  • FromId (activity_from_id) — NOTNULL — Foreign key → Acvities.Id — NOT NULL
  • ToId (activity_to_id) — NOTNULL — Foreign key → Acvities.Id — NOT NULL

Users (프로젝트멤버든유저든 아무튼 유저테이블)

  • Id (user_id) — NOTNULL — Primary key — NOT NULL
  • Name (user_name)