工作流引擎数据库设计

1、 Sybase PowerDesignerLogical Data Model ReportModel: 04 数据库设计Report: 数据库设计Author: AdministratorVersion: Date: 2016/8/3Summary: I ER 图II 简单模型描述II.1 实体的清单名称代码21 流程定义WF_WorkFlow22 环节定义WF_Activity23 流转定义WF_Rule24 环节角色WF_ActiRole26 流程实例WF_CaseFlow27 环节实例WF_CaseActivity28 流转实例WF_CaseRule29 实例任务WF_CaseTask

2、29A 任务指派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)宽度W

3、idthVariable 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

4、 (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)重复方向RepeatDirec

5、tionVariable 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 characte

6、rs (50)流程外键WF_OIDVariable characters (50)流转主键UniqueIDVariable characters (50)状态StateVariable characters (50)方法名MethodNameVariable characters (50)流转名称RuleNameVariable characters (50)流转类型LineTypeVariable characters (50)开始环节IDBeginActivityUniqueIDVariable characters (50)结束环节IDEndActivityUniqueIDVariabl

7、e characters (50)开始点X坐标BeginPointXVariable characters (50)开始点Y坐标BeginPointYVariable characters (50)结束点X坐标EndPointXVariable characters (50)结束点Y坐标EndPointYVariable characters (50)中间点1Z坐标TurnPoint1XVariable characters (50)中间点1Y坐标TurnPoint1YVariable characters (50)中间点2X坐标TurnPoint2XVariable characters (

8、50)中间点2Y坐标TurnPoint2YVariable characters (50)Z标签ZIndexVariable characters (50)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.4 实体24 环节角色III.1.4.1 实体24 环节角色的属性的清单名称代码数据类型主键OIDVariable characters (50)环节定义主键Uniqu

9、eIDVariable characters (50)角色外键Role_OIDVariable characters (50)工作权值WEIGHTFloat顺序号OrderByNumber办理权限HandleRIghtInteger创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.5 实体26 流程实例III.1.5.1 实体26 流程实例的属性的清单名称代码数据类型主键

10、OIDVariable characters (50)流程外键WF_OIDVariable characters (50)流程IDUniqueIDVariable characters (50)IDIDVariable characters (50)业务难度BusiDiffictFloat流程名称NAMEVariable characters (50)描述DescriptionVariable characters (500)宽度WidthVariable characters (50)高度HeightVariable characters (50)完成状态FinishStateInteger

11、当前主办人CurrentUserVariable characters (50)当前流转标签RuleNameVariable characters (100)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.6 实体27 环节实例III.1.6.1 实体27 环节实例的属性的清单名称代码数据类型主键OIDVariable characters (50)实例外键CaseOI

12、DVariable 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

13、 (50)重复方向RepeatDirectionVariable characters (50)Z标签ZIndexVariable characters (50)配置内容ValueVariable characters (1000)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.7 实体28 流转实例III.1.7.1 实体28 流转实例的属性的清单名称代码数据类型主键

14、OIDVariable characters (50)实例外键CaseOIDVariable characters (50)流转主键UniqueIDVariable characters (50)状态StateVariable characters (50)方法名MethodNameVariable characters (50)流转名称RuleNameVariable characters (50)流转类型LineTypeVariable characters (50)开始环节IDBeginActivityUniqueIDVariable characters (50)结束环节IDEndAc

15、tivityUniqueIDVariable characters (50)开始点X坐标BeginPointXVariable characters (50)开始点Y坐标BeginPointYVariable characters (50)结束点X坐标EndPointXVariable characters (50)结束点Y坐标EndPointYVariable characters (50)中间点1Z坐标TurnPoint1XVariable characters (50)中间点1Y坐标TurnPoint1YVariable characters (50)中间点2X坐标TurnPoint2X

16、Variable characters (50)中间点2Y坐标TurnPoint2YVariable characters (50)Z标签ZIndexVariable characters (50)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.8 实体29 实例任务III.1.8.1 实体29 实例任务的属性的清单名称代码数据类型主键OIDVariable chara

17、cters (50)实例外键CaseOIDVariable characters (50)环节实例外键AC_OIDVariable characters (50)来源流转SourceRuleVariable characters (500)来源环节SourceActivityVariable characters (500)完成用户IDFinishUserOIDVariable characters (50)来源任务SourceTaskVariable characters (500)退回任务BackTaskVariable characters (500)完成时间FinishTimeDate

18、 & Time完成状态FinishStateInteger接收状态ReceiveStateInteger创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.9 实体29A 任务指派III.1.9.1 实体29A 任务指派的属性的清单名称代码数据类型主键OIDVariable characters (50)实例外键CaseOIDVariable characters

19、(50)任务外键Task_OIDVariable characters (50)实例分配人员外键CaseRoleUser_OIDVariable characters (50)办理人员IDUserOIDVariable characters (50)角色外键Role_OIDVariable characters (50)完成时间FinishTimeDate & Time办理状态HandleStateInteger完成人OIDFinishUserOIDVariable characters (50)完成状态FinishStateInteger接收状态ReceiveStateInteger

20、创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.10 实体29B 流程审批信息III.1.10.1 实体29B 流程审批信息的属性的清单名称代码数据类型主键OIDVariable characters (50)实例外键CaseOIDVariable characters (50)任务外键TaskOIDVariable characters (50)任务指派外键ASSIGN_OIDVariable characters (50)流转标签RuleNameVariable chara