工作流引擎数据库设计

《工作流引擎数据库设计》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、.SybasePowerDesignerLogicalDataModelReportModel:04数据库设计Report:数据库设计Author:AdministratorVersion:Date:2016/8/3Summary:....IER图....I简单模型描述I.1实体的清单名称代码21流程定义WF_WorkFlow22环节定义WF_Activity23流转定义WF_Rule24环节角色WF_ActiRole26流程实例WF_CaseFlow27环节实例WF_CaseActivity28流转实例WF_Ca

2、seRule29实例任务WF_CaseTask29A任务指派WF_CaseTaskAssign29B流程审批信息WF_CaseApprove29C实例环节角色WF_CaseActiRoleII完全模型描述II.1.1实体21流程定义II.1.1.1实体21流程定义的属性的清单名称代码数据类型主键OIDVariablecharacters(50)流程IDUniqueIDVariablecharacters(50)IDIDVariablecharacters(50)流程名称NAMEVariablecharacters(

3、50)描述DescriptionVariablecharacters(500)宽度WidthVariablecharacters(50)高度HeightVariablecharacters(50)创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)..I.1.1实体22环节定义I.1.1.1实体22环节定义的属性的清单名称代码数据类型主键

4、OIDVariablecharacters(50)流程外键WF_OIDVariablecharacters(50)环节定义主键UniqueIDVariablecharacters(50)状态StateVariablecharacters(50)用户名UserNameVariablecharacters(50)环节名称ActivityNameVariablecharacters(50)环节类型TypeVariablecharacters(50)顺序号OrderVariablecharacters(50)X坐标Posi

5、tionXVariablecharacters(50)Y坐标PositionYVariablecharacters(50)重复方向RepeatDirectionVariablecharacters(50)Z标签ZIndexVariablecharacters(50)配置内容ValueVariablecharacters(1000)创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUser

6、Variablecharacters(50)I.1.2实体23流转定义I.1.2.1实体23流转定义的属性的清单名称代码数据类型主键OIDVariablecharacters(50)流程外键WF_OIDVariablecharacters(50)流转主键UniqueIDVariablecharacters(50)状态StateVariablecharacters(50)方法名MethodNameVariablecharacters(50)流转名称RuleNameVariablecharacters(50)流转类型L

7、ineTypeVariablecharacters(50)开始环节IDBeginActivityUniqueIDVariablecharacters(50)结束环节IDEndActivityUniqueIDVariablecharacters(50)开始点X坐标BeginPointXVariablecharacters(50)开始点Y坐标BeginPointYVariablecharacters(50)..结束点X坐标EndPointXVariablecharacters(50)结束点Y坐标EndPointYVar

8、iablecharacters(50)中间点1Z坐标TurnPoint1XVariablecharacters(50)中间点1Y坐标TurnPoint1YVariablecharacters(50)中间点2X坐标TurnPoint2XVariablecharacters(50)中间点2Y坐标TurnPoint2YVariablecharacters(50)Z