工作流引擎数据库设计

1、SybasePowerDesignerLogicalDataModelReportModel:04数据库设计Report:数据库设计Author:AdministratorVersion:Date:2016/8/3Summary:吁仪索眸aHW,：M34”Uhiflirwi*UTd'HAUTW"t-sE;-3amjt一IU.H»hBI二:£IIT3TL.TT-MH3TMHPuh*!>"UE:k国u二urtFbH1.IEMJ"一若二修-£-：m二靠wHhwHuri-hriH-lIIJl-riHd江H.Bi«*“u

2、euL:llTLlniH口3彳n线二心二片J=.”-3*,UMgll”Tlll-B77T.盆用牛事津W憎即静川味拘套nr醺曲学段芾3-Lrne:-mw:iTH-l汽日忖跳WIKu-Cur：刎hh厢姗灯图H|«i.!单健r：.10中通力日克:"X3,Hk3HIOO«OOQ4CP门力金曲立部H|3?Mb.auMlLB'TLlirtiTMh5*5-43-警UHEwvuh*Tu'rlPHfll.“£”ma“二-!:-£1c/li-lUTZnn'uTarTJ?Hn-Hu'"i.nAall*Tu'ri-ri

3、HkuqMLHaHhuMHtuu”thmi-i-口士-1ut1-h二三二A的&tIU咄明W!U：时AEIIH台GJ加目后1SH*ZTHriTHIMBiBTS1.,=/wu'11-rrETHTTHd-riu;钳mAITliIETU5附5；酶忸咎：.；用T”：E,电七加WH.r.：iI!pJ!中汨=i®Hvl,i4】KfnmTvT_M-最喜1-/|二嗝*wkA-urihHU七匕一片“三"THEmewil1“.2中>#曰V15:.kHt!H-:TmA日©:4)l«.m«Tl二上聊事修:%4*玄咏皆13lnHlT康和耙山澳H|HW

4、归斯鼾说;叮«<»I>ii«dniin.r11，助LEITIT3a加*r£w”fKIMnTMWHOI月u-隰f.-%_1已*IT-4口liI4-H",l玄-匕“仆-belfda-T5:mTn>,TmIHww:Im-511-=wrnabhrihHPU*TmM-riJLH'L.-.就一IU-二TM"=EllilHiwllalTLIHIT"i-H中孤仃口|昨间期利勾工融归lb,i卅M则廿叮UIW©rfiiii-<uj|P4J*-”*西“H福纠Tnnim，,沙林加K台群的升*4.H/博咻区编

5、*也集IfHK"i"ii!"al!l卜唱iI*-I!-!III:"!.?:ME-:.HdMmf-i1111:-unhn"ixfah:T>a7*HQII樽即目叩MY柳唧"物1帧旧例即I'i"'-,1M：H'i.5|.界|已寸1工二3EH:口I'rvqlar:一二上，1J1厘系黑H'II'*则1*m''"slEMl-iliEl,HIa-li-*一J'eIirKlu"ri_ri_irurtrLU简单模型描述实体的清单名称代码21流程定

6、义WF_WorkFlow22环节定义WF_Activity23流转定义WF_Rule24环节角色WF_ActiRole26流程实例WF_CaseFlow27环节实例WF_CaseActivity28流转实例WF_CaseRule29实例任务WF_CaseTask29A任务指派WF_CaseTaskAssign29B流程审批信息WF_CaseApprove29C实例环节角色WF_CaseActiRole完全模型描述实体21流程定义实体21流程定义的属性的清单名称代码数据类型主键OIDVariablecharacters(50)流程ID:UniquelDVariablecharacters(50)

7、IDIDVariablecharacters(50)流程名称NAMEVariablecharacters(50)描述DescriptionVariablecharacters(500)宽度WidthVariablecharacters(50)高度:HeightVariablecharacters(50)创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)实体22环节定义实体22环节定义的属性的清单名称

8、代码数据类型主键OIDVariablecharacters(50)流程外键WF_OIDVariablecharacters(50)环节定义主键UniquelDVariablecharacters(50)状态StateVariablecharacters(50)用户名UserNameVariablecharacters(50)环节名称ActivityNameVariablecharacters(50)环卫类型TypeVariablecharacters(50)顺序号OrderVariablecharacters(50)X坐标PositionXVariablecharacters(50)丫坐标Po

9、sitionYVariablecharacters(50)重复方1可RepeatDirectionVariablecharacters(50)Z标签ZIndexVariablecharacters(50)配置内容ValueVariablecharacters(1000)创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)实体23流转定义实体23流转定义的属性的清单名称代码数据类型主键OIDVariab

10、lecharacters(50)流程外键WF_OIDVariablecharacters(50)流转主键UniqueIDVariablecharacters(50)状态StateVariablecharacters(50)方法名MethodNameVariablecharacters(50)流转名称RuleNameVariablecharacters(50)流转类型LineTypeVariablecharacters(50)开始环节ID1BeginActivityUniqueIDVariablecharacters(50)结束环节IDEndActivityUniqueIDVariablecha

11、racters(50)开始点X坐标一BeginPointXVariablecharacters(50)开始点Y坐标BeginPointYVariablecharacters(50)结束点X坐标EndPointXVariablecharacters(50)结束点Y坐标EndPointYVariablecharacters(50)中间点1Z坐标TurnPoint1XVariablecharacters(50)中间点1Y坐标TurnPoint1YVariablecharacters(50)中间点2X坐标TurnPoint2XVariablecharacters(50)中间点2Y坐标TurnPoint

12、2YVariablecharacters(50)Z标签ZIndexVariablecharacters(50)创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)实体24环节角色实体24环节角色的属性的清单名称代码数据类型主键OIDVariablecharacters(50)环节定义主键UniqueIDVariablecharacters(50)角色外键Role_OIDVariablecharacte

13、rs(50)工作权值WEIGHTFloat顺序号OrderByNumber办理权限HandleRIghtInteger创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)实体26流程实例实体26流程实例的属性的清单名称代码数据类型主键OIDVariablecharacters(50)流程外键WF_OIDVariablecharacters(50)流程IDUniquelDVariablecharacte

14、rs(50)IDIDVariablecharacters(50)业务难度BusiDiffictFloat流程名称一NAMEVariablecharacters(50)描述DescriptionVariablecharacters(500)宽度WidthVariablecharacters(50)高度HeightVariablecharacters(50)完成状态FinishStateInteger当前主办人CurrentUserVariablecharacters(50)当前流转标签RuleNameVariablecharacters(100)创建日期CreateDateDate&Ti

15、me创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)实体27环节实例实体27环节实例的属性的清单名称代码数据类型主键OIDVariablecharacters(50)实例外键CaseOIDVariablecharacters(50)环节定义主键UniqueIDVariablecharacters(50)状态StateVariablecharacters(50)用户名UserNameVariablecharacters(50)环节名称ActivityN

16、ameVariablecharacters(50)环卫类型TypeVariablecharacters(50)顺序号OrderVariablecharacters(50)X坐标PositionXVariablecharacters(50)丫坐标PositionYVariablecharacters(50)重复方1可RepeatDirectionVariablecharacters(50)Z标签ZIndexVariablecharacters(50)配置内容ValueVariablecharacters(1000)创建日期CreateDateDate&Time创建人CreateUserV

17、ariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)实体28流转实例实体28流转实例的属性的清单名称代码数据类型主键OIDVariablecharacters(50)实例外键CaseOIDVariablecharacters(50)流转主键UniquelDVariablecharacters(50)状态StateVariablecharacters(50)方法名MethodNameVariablecharacters(50)流转名称RuleNameVariablecharacter

18、s(50)流转类型LineTypeVariablecharacters(50)开始环节IDBeginActivityUniqueIDVariablecharacters(50)结束环节IDEndActivityUniqueIDVariablecharacters(50)开始点X坐标BeginPointXVariablecharacters(50)开始点Y坐标BeginPointYVariablecharacters(50)结束点X坐标EndPointXVariablecharacters(50)结束点Y坐标EndPointYVariablecharacters(50)中间点1Z坐标TurnPo

19、int1XVariablecharacters(50)中间点1Y坐标TurnPoint1YVariablecharacters(50)中间点2X坐标TurnPoint2XVariablecharacters(50)中间点2Y坐标TurnPoint2YVariablecharacters(50)Z标签ZIndexVariablecharacters(50)创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(5

20、0)实体29实例任务实体29实例任务的属性的清单名称代码数据类型主键OIDVariablecharacters(50)实例外键CaseOIDVariablecharacters(50)环节实例外键AC_OIDVariablecharacters(50)来源流转SourceRuleVariablecharacters(500)来源环节SourceActivityVariablecharacters(500)完成用户IDFinishUserOIDVariablecharacters(50)来源任务SourceTaskVariablecharacters(500)退回任务BackTaskVariab

21、lecharacters(500)完成时间FinishTimeDate&Time完成状态FinishStateInteger接收状态ReceiveStateInteger创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)实体29A任务指派实体29A任务指派的属性的清单名称代码数据类型主键OIDVariablecharacters(50)实例外键CaseOIDVariablecharacter

22、s(50)任务外键Task_OIDVariablecharacters(50)实例分配人员外键CaseRoleUser_OIDVariablecharacters(50)办理人员IDUserOIDVariablecharacters(50)角色外键Role_OIDVariablecharacters(50)完成时间FinishTimeDate&Time办理状态HandleStateInteger完成人OIDFinishUserOIDVariablecharacters(50)完成状态FinishStateInteger接收状态ReceiveStateInteger创建日期CreateDateDate&Time创建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)实体29B流程审批信息实体29B流程审批信息的属性的清单名称代码数据类型主键OIDVariablecharacte