02 工作流引擎数据库设计

. 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_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)流转名称RuleNameVariable characters (50)流转类型LineTypeVariable characters (50)开始环节IDBeginActivityUniqueIDVariable characters (50)结束环节IDEndActivityUniqueIDVariable 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 (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)环节定义主键UniqueIDVariable 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 流程实例的属性的清单名称代码数据类型主键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当前主办人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)实例外键CaseOIDVariable 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.7 实体28 流转实例III.1.7.1 实体28 流转实例的属性的清单名称代码数据类型主键OIDVariable characters (50)实例外键CaseOIDVariable characters (50)流转主键UniqueIDVariable characters (50)状态StateVariable characters (50)方法名MethodNameVariable characters (50)流转名称RuleNameVariable characters (50)流转类型LineTypeVariable characters (50)开始环节IDBeginActivityUniqueIDVariable characters (50)结束环节IDEndActivityUniqueIDVariable 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 (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 characters (50)实例外键CaseOIDVariable characters (50)环节实例外键AC_OIDVariable characters (50)来源流转SourceRuleVariable characters (500)来源环节SourceActivityVariable characters (500)完成用户IDFinishUserOIDVariable characters (50)来源任务SourceTaskVariable characters (500)退回任务BackTaskVariable characters (500)完成时间FinishTimeDate & 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 (50)任务外键Task_OIDVariable characters (50)实例分配人员外键CaseRoleUser_OIDVariable characters (50)办理人员IDUserOIDVariable characters (50)角色外键Role_OIDVariable characters (50)完成时间FinishTimeDate & Time办理状态HandleStateInteger完成人OIDFinishUserOIDVariable characters (50)完成状态FinishStateInteger接收状态ReceiveStateInteger创建日期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)流转标签RuleNameVariabl