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)