工作流引擎數(shù)據(jù)庫(kù)設(shè)計(jì)VIP

1、SybasePowerDesignerLogicalDataModelReportModel:04數(shù)據(jù)庫(kù)設(shè)計(jì)Report:數(shù)據(jù)庫(kù)設(shè)計(jì)Author:AdministratorVersion:Date:2016/8/3Summary:吁儀索眸aHW,：M34”Uhiflirwi*UTd'HAUTW"t-sE;-3amjt一IU.H»hBI二:£IIT3TL.TT-MH3TMHPuh*!>"UE:k國(guó)u二urtFbH1.IEMJ"一若二修-£-：m二靠wHhwHuri-hriH-lIIJl-riHd江H.Bi«*“u

2、euL:llTLlniH口3彳n線二心二片J=.”-3*,UMgll”Tlll-B77T.盆用牛事津W憎即靜川味拘套nr醺曲學(xué)段芾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：時(shí)AEIIH臺(tái)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、歸斯鼾說(shuō);叮«<»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臺(tái)群的升*4.H/博咻區(qū)編

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簡(jiǎn)單模型描述實(shí)體的清單名稱代碼21流程定

6、義WF_WorkFlow22環(huán)節(jié)定義WF_Activity23流轉(zhuǎn)定義WF_Rule24環(huán)節(jié)角色WF_ActiRole26流程實(shí)例WF_CaseFlow27環(huán)節(jié)實(shí)例WF_CaseActivity28流轉(zhuǎn)實(shí)例WF_CaseRule29實(shí)例任務(wù)WF_CaseTask29A任務(wù)指派WF_CaseTaskAssign29B流程審批信息WF_CaseApprove29C實(shí)例環(huán)節(jié)角色WF_CaseActiRole完全模型描述實(shí)體21流程定義實(shí)體21流程定義的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariablecharacters(50)流程ID:UniquelDVariablecharacters(50)

7、IDIDVariablecharacters(50)流程名稱NAMEVariablecharacters(50)描述DescriptionVariablecharacters(500)寬度WidthVariablecharacters(50)高度:HeightVariablecharacters(50)創(chuàng)建日期CreateDateDate&Time創(chuàng)建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)實(shí)體22環(huán)節(jié)定義實(shí)體22環(huán)節(jié)定義的屬性的清單名稱

8、代碼數(shù)據(jù)類型主鍵OIDVariablecharacters(50)流程外鍵WF_OIDVariablecharacters(50)環(huán)節(jié)定義主鍵UniquelDVariablecharacters(50)狀態(tài)StateVariablecharacters(50)用戶名UserNameVariablecharacters(50)環(huán)節(jié)名稱ActivityNameVariablecharacters(50)環(huán)衛(wèi)類型TypeVariablecharacters(50)順序號(hào)OrderVariablecharacters(50)X坐標(biāo)PositionXVariablecharacters(50)丫坐標(biāo)Po

9、sitionYVariablecharacters(50)重復(fù)方1可RepeatDirectionVariablecharacters(50)Z標(biāo)簽ZIndexVariablecharacters(50)配置內(nèi)容ValueVariablecharacters(1000)創(chuàng)建日期CreateDateDate&Time創(chuàng)建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)實(shí)體23流轉(zhuǎn)定義實(shí)體23流轉(zhuǎn)定義的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariab

10、lecharacters(50)流程外鍵WF_OIDVariablecharacters(50)流轉(zhuǎn)主鍵UniqueIDVariablecharacters(50)狀態(tài)StateVariablecharacters(50)方法名MethodNameVariablecharacters(50)流轉(zhuǎn)名稱RuleNameVariablecharacters(50)流轉(zhuǎn)類型LineTypeVariablecharacters(50)開始環(huán)節(jié)ID1BeginActivityUniqueIDVariablecharacters(50)結(jié)束環(huán)節(jié)IDEndActivityUniqueIDVariablecha

11、racters(50)開始點(diǎn)X坐標(biāo)一BeginPointXVariablecharacters(50)開始點(diǎn)Y坐標(biāo)BeginPointYVariablecharacters(50)結(jié)束點(diǎn)X坐標(biāo)EndPointXVariablecharacters(50)結(jié)束點(diǎn)Y坐標(biāo)EndPointYVariablecharacters(50)中間點(diǎn)1Z坐標(biāo)TurnPoint1XVariablecharacters(50)中間點(diǎn)1Y坐標(biāo)TurnPoint1YVariablecharacters(50)中間點(diǎn)2X坐標(biāo)TurnPoint2XVariablecharacters(50)中間點(diǎn)2Y坐標(biāo)TurnPoint

12、2YVariablecharacters(50)Z標(biāo)簽ZIndexVariablecharacters(50)創(chuàng)建日期CreateDateDate&Time創(chuàng)建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)實(shí)體24環(huán)節(jié)角色實(shí)體24環(huán)節(jié)角色的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariablecharacters(50)環(huán)節(jié)定義主鍵UniqueIDVariablecharacters(50)角色外鍵Role_OIDVariablecharacte

13、rs(50)工作權(quán)值WEIGHTFloat順序號(hào)OrderByNumber辦理權(quán)限HandleRIghtInteger創(chuàng)建日期CreateDateDate&Time創(chuàng)建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)實(shí)體26流程實(shí)例實(shí)體26流程實(shí)例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariablecharacters(50)流程外鍵WF_OIDVariablecharacters(50)流程IDUniquelDVariablecharacte

14、rs(50)IDIDVariablecharacters(50)業(yè)務(wù)難度BusiDiffictFloat流程名稱一NAMEVariablecharacters(50)描述DescriptionVariablecharacters(500)寬度WidthVariablecharacters(50)高度HeightVariablecharacters(50)完成狀態(tài)FinishStateInteger當(dāng)前主辦人CurrentUserVariablecharacters(50)當(dāng)前流轉(zhuǎn)標(biāo)簽RuleNameVariablecharacters(100)創(chuàng)建日期CreateDateDate&Ti

15、me創(chuàng)建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)實(shí)體27環(huán)節(jié)實(shí)例實(shí)體27環(huán)節(jié)實(shí)例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariablecharacters(50)實(shí)例外鍵CaseOIDVariablecharacters(50)環(huán)節(jié)定義主鍵UniqueIDVariablecharacters(50)狀態(tài)StateVariablecharacters(50)用戶名UserNameVariablecharacters(50)環(huán)節(jié)名稱ActivityN

16、ameVariablecharacters(50)環(huán)衛(wèi)類型TypeVariablecharacters(50)順序號(hào)OrderVariablecharacters(50)X坐標(biāo)PositionXVariablecharacters(50)丫坐標(biāo)PositionYVariablecharacters(50)重復(fù)方1可RepeatDirectionVariablecharacters(50)Z標(biāo)簽ZIndexVariablecharacters(50)配置內(nèi)容ValueVariablecharacters(1000)創(chuàng)建日期CreateDateDate&Time創(chuàng)建人CreateUserV

17、ariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)實(shí)體28流轉(zhuǎn)實(shí)例實(shí)體28流轉(zhuǎn)實(shí)例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariablecharacters(50)實(shí)例外鍵CaseOIDVariablecharacters(50)流轉(zhuǎn)主鍵UniquelDVariablecharacters(50)狀態(tài)StateVariablecharacters(50)方法名MethodNameVariablecharacters(50)流轉(zhuǎn)名稱RuleNameVariablecharacter

18、s(50)流轉(zhuǎn)類型LineTypeVariablecharacters(50)開始環(huán)節(jié)IDBeginActivityUniqueIDVariablecharacters(50)結(jié)束環(huán)節(jié)IDEndActivityUniqueIDVariablecharacters(50)開始點(diǎn)X坐標(biāo)BeginPointXVariablecharacters(50)開始點(diǎn)Y坐標(biāo)BeginPointYVariablecharacters(50)結(jié)束點(diǎn)X坐標(biāo)EndPointXVariablecharacters(50)結(jié)束點(diǎn)Y坐標(biāo)EndPointYVariablecharacters(50)中間點(diǎn)1Z坐標(biāo)TurnPo

19、int1XVariablecharacters(50)中間點(diǎn)1Y坐標(biāo)TurnPoint1YVariablecharacters(50)中間點(diǎn)2X坐標(biāo)TurnPoint2XVariablecharacters(50)中間點(diǎn)2Y坐標(biāo)TurnPoint2YVariablecharacters(50)Z標(biāo)簽ZIndexVariablecharacters(50)創(chuàng)建日期CreateDateDate&Time創(chuàng)建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(5

20、0)實(shí)體29實(shí)例任務(wù)實(shí)體29實(shí)例任務(wù)的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariablecharacters(50)實(shí)例外鍵CaseOIDVariablecharacters(50)環(huán)節(jié)實(shí)例外鍵AC_OIDVariablecharacters(50)來(lái)源流轉(zhuǎn)SourceRuleVariablecharacters(500)來(lái)源環(huán)節(jié)SourceActivityVariablecharacters(500)完成用戶IDFinishUserOIDVariablecharacters(50)來(lái)源任務(wù)SourceTaskVariablecharacters(500)退回任務(wù)BackTaskVariab

21、lecharacters(500)完成時(shí)間FinishTimeDate&Time完成狀態(tài)FinishStateInteger接收狀態(tài)ReceiveStateInteger創(chuàng)建日期CreateDateDate&Time創(chuàng)建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)實(shí)體29A任務(wù)指派實(shí)體29A任務(wù)指派的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariablecharacters(50)實(shí)例外鍵CaseOIDVariablecharacter

22、s(50)任務(wù)外鍵Task_OIDVariablecharacters(50)實(shí)例分配人員外鍵CaseRoleUser_OIDVariablecharacters(50)辦理人員IDUserOIDVariablecharacters(50)角色外鍵Role_OIDVariablecharacters(50)完成時(shí)間FinishTimeDate&Time辦理狀態(tài)HandleStateInteger完成人OIDFinishUserOIDVariablecharacters(50)完成狀態(tài)FinishStateInteger接收狀態(tài)ReceiveStateInteger創(chuàng)建日期CreateDateDate&Time創(chuàng)建人CreateUserVariablecharacters(50)修改日期UpdateDateDate&Time修改人UpdateUserVariablecharacters(50)實(shí)體29B流程審批信息實(shí)體29B流程審批信息的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariablecharacte