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

1、 Sybase PowerDesignerLogical Data Model ReportModel: 04 數(shù)據(jù)庫設(shè)計Report: 數(shù)據(jù)庫設(shè)計Author: AdministratorVersion: Date: 2016/8/3Summary: I ER 圖II 簡單模型描述II.1 實體的清單名稱代碼21 流程定義WF_WorkFlow22 環(huán)節(jié)定義WF_Activity23 流轉(zhuǎn)定義WF_Rule24 環(huán)節(jié)角色WF_ActiRole26 流程實例WF_CaseFlow27 環(huán)節(jié)實例WF_CaseActivity28 流轉(zhuǎn)實例WF_CaseRule29 實例任務(wù)WF_CaseTask

2、29A 任務(wù)指派WF_CaseTaskAssign29B 流程審批信息WF_CaseApprove29C 實例環(huán)節(jié)角色WF_CaseActiRoleIII 完全模型描述III.1.1 實體21 流程定義III.1.1.1 實體21 流程定義的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)流程IDUniqueIDVariable characters (50)IDIDVariable characters (50)流程名稱NAMEVariable characters (50)描述DescriptionVariable characters (500)寬度W

3、idthVariable characters (50)高度HeightVariable characters (50)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.2 實體22 環(huán)節(jié)定義III.1.2.1 實體22 環(huán)節(jié)定義的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)流程外鍵WF_OIDVariable characters

4、 (50)環(huán)節(jié)定義主鍵UniqueIDVariable characters (50)狀態(tài)StateVariable characters (50)用戶名UserNameVariable characters (50)環(huán)節(jié)名稱ActivityNameVariable characters (50)環(huán)節(jié)類型TypeVariable characters (50)順序號OrderVariable characters (50)X坐標PositionXVariable characters (50)Y坐標PositionYVariable characters (50)重復(fù)方向RepeatDirec

5、tionVariable characters (50)Z標簽ZIndexVariable characters (50)配置內(nèi)容ValueVariable characters (1000)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.3 實體23 流轉(zhuǎn)定義III.1.3.1 實體23 流轉(zhuǎn)定義的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characte

6、rs (50)流程外鍵WF_OIDVariable characters (50)流轉(zhuǎn)主鍵UniqueIDVariable characters (50)狀態(tài)StateVariable characters (50)方法名MethodNameVariable characters (50)流轉(zhuǎn)名稱RuleNameVariable characters (50)流轉(zhuǎn)類型LineTypeVariable characters (50)開始環(huán)節(jié)IDBeginActivityUniqueIDVariable characters (50)結(jié)束環(huán)節(jié)IDEndActivityUniqueIDVariabl

7、e characters (50)開始點X坐標BeginPointXVariable characters (50)開始點Y坐標BeginPointYVariable characters (50)結(jié)束點X坐標EndPointXVariable characters (50)結(jié)束點Y坐標EndPointYVariable characters (50)中間點1Z坐標TurnPoint1XVariable characters (50)中間點1Y坐標TurnPoint1YVariable characters (50)中間點2X坐標TurnPoint2XVariable characters (

8、50)中間點2Y坐標TurnPoint2YVariable characters (50)Z標簽ZIndexVariable characters (50)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.4 實體24 環(huán)節(jié)角色III.1.4.1 實體24 環(huán)節(jié)角色的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)環(huán)節(jié)定義主鍵Uniqu

9、eIDVariable characters (50)角色外鍵Role_OIDVariable characters (50)工作權(quán)值WEIGHTFloat順序號OrderByNumber辦理權(quán)限HandleRIghtInteger創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.5 實體26 流程實例III.1.5.1 實體26 流程實例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵

10、OIDVariable characters (50)流程外鍵WF_OIDVariable characters (50)流程IDUniqueIDVariable characters (50)IDIDVariable characters (50)業(yè)務(wù)難度BusiDiffictFloat流程名稱NAMEVariable characters (50)描述DescriptionVariable characters (500)寬度WidthVariable characters (50)高度HeightVariable characters (50)完成狀態(tài)FinishStateInteger

11、當(dāng)前主辦人CurrentUserVariable characters (50)當(dāng)前流轉(zhuǎn)標簽RuleNameVariable characters (100)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.6 實體27 環(huán)節(jié)實例III.1.6.1 實體27 環(huán)節(jié)實例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)實例外鍵CaseOI

12、DVariable characters (50)環(huán)節(jié)定義主鍵UniqueIDVariable characters (50)狀態(tài)StateVariable characters (50)用戶名UserNameVariable characters (50)環(huán)節(jié)名稱ActivityNameVariable characters (50)環(huán)節(jié)類型TypeVariable characters (50)順序號OrderVariable characters (50)X坐標PositionXVariable characters (50)Y坐標PositionYVariable characters

13、 (50)重復(fù)方向RepeatDirectionVariable characters (50)Z標簽ZIndexVariable characters (50)配置內(nèi)容ValueVariable characters (1000)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.7 實體28 流轉(zhuǎn)實例III.1.7.1 實體28 流轉(zhuǎn)實例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵

14、OIDVariable characters (50)實例外鍵CaseOIDVariable characters (50)流轉(zhuǎn)主鍵UniqueIDVariable characters (50)狀態(tài)StateVariable characters (50)方法名MethodNameVariable characters (50)流轉(zhuǎn)名稱RuleNameVariable characters (50)流轉(zhuǎn)類型LineTypeVariable characters (50)開始環(huán)節(jié)IDBeginActivityUniqueIDVariable characters (50)結(jié)束環(huán)節(jié)IDEndAc

15、tivityUniqueIDVariable characters (50)開始點X坐標BeginPointXVariable characters (50)開始點Y坐標BeginPointYVariable characters (50)結(jié)束點X坐標EndPointXVariable characters (50)結(jié)束點Y坐標EndPointYVariable characters (50)中間點1Z坐標TurnPoint1XVariable characters (50)中間點1Y坐標TurnPoint1YVariable characters (50)中間點2X坐標TurnPoint2X

16、Variable characters (50)中間點2Y坐標TurnPoint2YVariable characters (50)Z標簽ZIndexVariable characters (50)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.8 實體29 實例任務(wù)III.1.8.1 實體29 實例任務(wù)的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable chara

17、cters (50)實例外鍵CaseOIDVariable characters (50)環(huán)節(jié)實例外鍵AC_OIDVariable characters (50)來源流轉(zhuǎn)SourceRuleVariable characters (500)來源環(huán)節(jié)SourceActivityVariable characters (500)完成用戶IDFinishUserOIDVariable characters (50)來源任務(wù)SourceTaskVariable characters (500)退回任務(wù)BackTaskVariable characters (500)完成時間FinishTimeDate

18、 & Time完成狀態(tài)FinishStateInteger接收狀態(tài)ReceiveStateInteger創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.9 實體29A 任務(wù)指派III.1.9.1 實體29A 任務(wù)指派的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)實例外鍵CaseOIDVariable characters

19、(50)任務(wù)外鍵Task_OIDVariable characters (50)實例分配人員外鍵CaseRoleUser_OIDVariable characters (50)辦理人員IDUserOIDVariable characters (50)角色外鍵Role_OIDVariable characters (50)完成時間FinishTimeDate & Time辦理狀態(tài)HandleStateInteger完成人OIDFinishUserOIDVariable characters (50)完成狀態(tài)FinishStateInteger接收狀態(tài)ReceiveStateInteger

20、創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.10 實體29B 流程審批信息III.1.10.1 實體29B 流程審批信息的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)實例外鍵CaseOIDVariable characters (50)任務(wù)外鍵TaskOIDVariable characters (50)任務(wù)指派外鍵ASSIGN_OIDVariable characters (50)流轉(zhuǎn)標簽RuleNameVariable chara