02工作流引擎数据库设计说明

Sybase PowerDesignerLogical Data Model ReportModel: 04 数据库设计Report: 数据库设计Author: AdministratorVersion: Date: 2024/8/3Summary: IER 图II 简单模型描述II.1 实体的清单名称代码21 流程定义WF_WorkFlow22 环节定义WF_Activity23 流转定义WF_Rule24 环节角色WF_ActiRole26 流程实例WF_CaseFlow27 环节实例WF_CaseActivity28 流转实例WF_CaseRule29 实例任务WF_CaseTask29A 任务指派WF_CaseTaskAssign29B 流程审批信息WF_CaseApprove29C 实例环节角色WF_CaseActiRoleIII 完全模型描述III.1.1实体 21 流程定义III.1.1.1实体 21 流程定义的属性的清单名称代码数据类型主键OIDVariable characters (50)流程 IDUniqueIDVariable characters (50)IDIDVariable characters (50)流程名称NAMEVariable characters (50)描述DescriptionVariable characters (500)宽度WidthVariable characters (50)高度HeightVariable characters (50)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.2实体 22 环节定义III.1.2.1实体 22 环节定义的属性的清单名称代码数据类型主键OIDVariable characters (50)流程外键WF_OIDVariable characters (50)环节定义主键UniqueIDVariable characters (50)状态StateVariable characters (50)用户名UserNameVariable characters (50)环节名称ActivityNameVariable characters (50)环节类型TypeVariable characters (50)顺序号OrderVariable characters (50)X 坐标PositionXVariable characters (50)Y 坐标PositionYVariable characters (50)重复方向RepeatDirectionVariable characters (50)Z 标签ZIndexVariable characters (50)配置容ValueVariable characters (1000)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.3实体 23 流转定义III.1.3.1实体 23 流转定义的属性的清单名称代码数据类型主键OIDVariable characters (50)流程外键WF_OIDVariable characters (50)流转主键UniqueIDVariable characters (50)状态StateVariable characters (50)方法名MethodNameVariable characters (50)流...