工作流引擎数据库设计

1、Sybase PowerDesignerLogical Data Model ReportModel: 04数据库设计Report:数据库设计Author: AdministratorVersion:Date: 2016/8/3Summary:I ER图n;!:, S蛋 鞋 一£- -.王达总算urr 户二二H售方坦前 至齐抗会方第，鼠亡"E交"ftriiAWlf .3* * 工r= jxj zrars irLible dw-a ：m j cE zkxrs*. .2 _.<r：4,Dl4Jt :mn.:x：4 > ,ir :ar le zhizazT-

2、rs "Z ''v tu-3i tiiiih it« r > ' 10r-REr- At-TK1 Jw£4一:支乃M 角土ft-c.L二3匕m rfrie："， 'T?I*三 力9二 EK1T3E - ar iztEtrja.t=上 Ilse'r-uTkfli« I ha.i » i *r i.irxiclt :田*mr1"zrii:1* ziiriz i罡片 片二1，、 沪5ew氨L r asisMA mF=次=E口矗：； :上jR：mar za.: 一 = ztatz. :_

3、*z s-"i'*r La.： ZrE Etj:二F=H 3- -jj h： 1-e _：-j.i jL.iEi ,4-r U.： Ifl'3.T ：.3.'： 1 ETL3.3T3 ： ±-»T KfAkniiiiiir"a. . La.':二七 =» a.: z± 二 3/ IF TJ t D t ) - 二二二- r二二期"二二3 =i -M."三手*:广* Jt RH«*壬=* 土*0««0，注4子* 尹 rflw/二，亡II号 LIJt =MT

4、ikor* " rbaiiTters1*3TTL=1cT：iF.F r- V r- r£«金厘恒把*不需更工 二一=-干=工_=±七2E茫上mI ZZ11.Z1;LWl*f f - * 11* 11 X七E 早 : 423 h2Ei电七ir ztarizttrsB LdU 4：*? L :lari zz tn ii-r = i.WI.-EarBw 二一；门二“二二=-.-: 7-mvriEy：案 Mhir?=严工1:匿.3不:三_-.& 注±豆不： 疝rJ:.”咬_:金二 二-"， 垂的飘室硝工丹店L一二二更1超章更 主%号&

5、#163;_=ae 逼：一 ；£»& 工AZ4鼻e:一位口，/1 -r s/hffttwA,?-. .-.,-二-皂 龙Er z三二- 二一江UI： ：£：1 = h-Z3T3 rE blHU.«E 18 c A -MraCTSTS zhiri:-： S kkrKi hr *-bmrTe-rsJ一！ HBl5li皆4.>«|8 .二三二一三二 曜良 MimhE's: 看:一百秀普宋，. 0«9白«'|»6>>.UtriLsljtVsxi xcl»El改”Viria

6、ileV«=-i«sl eVlTlLEltI>a-e-百 7ZLL'LZIif 1 =l_ar j.=-r re blrrib.<k Llr fe 匚kr窜 zlarizisrs KuLvurn 二Ef 1二： EWAdEStri褰，奉津 £ 美saiht ( a±A-lzl2 ，鱼ei包-«,JC."iiC)(issrII简单模型描述II .1实体的清单名称代码21流程定义WF_WorkFlow22环节定义WF_Activity23流转定义WF_Rule24环节角色WF_ActiRole26流程实例WF_Case

7、Flow27环节实例WF_CaseActivity28流转实例WF_CaseRule29实例任务WF_CaseTask29A任务指派WF_CaseTaskAssign29B流程审批信息WF_CaseApprove29C实例环节角色WF_CaseActiRoleIII完全模型描述III .1.1实体21流程定义1.1.1.1 .1实体21流程定义的属性的清单名称代码数据类型主键OIDVariable characters (50)流程IDUniqueIDVariable characters (50)IDIDVariable characters (50)流程名称NAMEVariable cha

8、racters (50)描述DescriptionVariable characters (500)宽度WidthVariable characters (50)高度HeightVariable characters (50)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)111.1.2 实体22环节定义111.1.2.1 实体22环节定义的属性的清单名称代码数据类型主键OIDVa

9、riable characters (50)流程外键WF_OIDVariable characters (50)环小定义主键UniquelDVariable characters (50)状态StateVariable characters (50)用户名UserNameVariable characters (50)划、节名称ActivityNameVariable characters (50)划、下类型TypeVariable characters (50)顺序号OrderVariable characters (50)X坐标PositionXVariable characters (5

10、0)Y坐标PositionYVariable characters (50)重复方向RepeatDirectionVariable characters (50)Z标签ZIndexVariable characters (50)配置内容ValueVariable characters (1000)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)111.1.3 实体23流转定义111

11、.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)开始环节IDBeginActivityUniqueIDVari

12、able characters (50)结束环节ID 一EndActivityUniqueIDVariable characters (50)开始点X坐标BeginPointXVariable characters (50)开始点Y坐标BeginPointYVariable characters (50)结束点X坐标EndPointXVariable characters (50)结束点Y坐标EndPointYVariable characters (50)中间点1Z坐标TurnPointlXVariable characters (50)中间点1Y坐标TurnPointlYVariable

13、characters (50)中间点2X坐标TurnPoint2XVariable characters (50)中间点2Y坐标TurnPoint2YVariable characters (50)Z标签ZIndexVariable characters (50)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)111.1.4 实体24环节角色111.1.4.1 实体24环节角色的属

14、性的清单名称代码数据类型主键OIDVariable characters (50)环小定义主键UniqueIDVariable characters (50)角色外键Role_OIDVariable characters (50)工作权值WEIGHTFloat顺序号OrderByNumber办理权限HandleRIghtInteger创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)

15、111.1.5 实体26流程实例111.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)高度He

16、ightVariable characters (50)完成状态FinishStateInteger当前主办人CurrentUserVariable characters (50)当前流转标签RuleNameVariable characters (100)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)111.1.6 实体27环节实例111.1.6.1 实体27环节实例的属性的清

17、单名称代码数据类型主键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坐标PositionXVaria

18、ble 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)11

19、1.1.7 实体28流转实例111.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)开始环节IDBeginAc

20、tivityUniquelDVariable 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坐标 1Tu

21、rnPoint1YVariable characters (50)中间点2X坐标TurnPoint2XVariable characters (50)中间点2Y坐标TurnPoint2YVariable characters (50)Z标签ZIndexVariable characters (50)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)111.1.8 实体29实例任务11

22、1.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)退回任务

23、BackTaskVariable characters (500)完成时间FinishTimeDate & Time完成状态FinishStateInteger接收状态ReceiveStateInteger创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)111.1.9 实体29A任务指派111.1.9.1 实体29A任务指派的属性的清单名称代码数据类型主键OIDVariab

24、le 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)111.1.10 实体29B流程审批信息111.1.10.1 实体29B流程审批信息的属性的清单名称代码数据类型主键OIDVar