02工作流引擎数据库设计资料.docx

Sybase PowerDesigner Logical Data Model Report Model: 04 数据库设计 Report: 数据库设计 Author: Administrator Version: Date: 2016/8/3 Summary: Logical Data Model 04 数据库设计 Report 数据库设计 Sybase PowerDesigner 2016/8/3 Page  PAGE 9 of  NUMPAGES 9 ER 图 简单模型描述 实体的清单 名称代码21 流程定义WF_WorkFlow22 环节定义WF_Activity23 流转定义WF_Rule24 环节角色WF_ActiRole26 流程实例WF_CaseFlow27 环节实例WF_CaseActivity28 流转实例WF_CaseRule29 实例任务WF_CaseTask29A 任务指派WF_CaseTaskAssign29B 流程审批信息WF_CaseApprove29C 实例环节角色WF_CaseActiRole 完全模型描述 实体21 流程定义 实体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) 实体22 环节定义 实体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) 实体23 流转定义 实体23 流转定义的属性的清单 名称代码数据类型主键OIDVariable characters (50)流程外键WF_OIDVariable characters (50)流转主键UniqueIDVariable characters (50)状态StateVariable characters (50)方法名MethodNameVariable characters (50)流转名称R