Sybase PowerDesignerLogical Data Model ReportModel: 04 數(shù)據(jù)庫(kù)設(shè)計(jì)Report: 數(shù)據(jù)庫(kù)設(shè)計(jì)Author: AdministratorVersion: Date: 2016/8/3Summary: Logical Data Model 04 數(shù)據(jù)庫(kù)設(shè)計(jì)Report 數(shù)據(jù)庫(kù)設(shè)計(jì)I ER 圖Sybase PowerDesigner2016/8/3Page 9 of 9II 簡(jiǎn)單模型描述II.1 實(shí)體的清單名稱代碼21 流程定義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_CaseActiRoleIII 完全模型描述III.1.1 實(shí)體21 流程定義III.1.1.1 實(shí)體21 流程定義的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)流程IDUniqueIDVariable characters (50)IDIDVariable characters (50)流程名稱NAMEVariable characters (50)描述DescriptionVariable characters (500)寬度WidthVariable characters (50)高度HeightVariable characters (50)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.2 實(shí)體22 環(huán)節(jié)定義III.1.2.1 實(shí)體22 環(huán)節(jié)定義的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)流程外鍵WF_OIDVariable 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)順序號(hào)OrderVariable characters (50)X坐標(biāo)PositionXVariable characters (50)Y坐標(biāo)PositionYVariable characters (50)重復(fù)方向RepeatDirectionVariable characters (50)Z標(biāo)簽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 實(shí)體23 流轉(zhuǎn)定義III.1.3.1 實(shí)體23 流轉(zhuǎn)定義的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (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)開(kāi)始環(huán)節(jié)IDBeginActivityUniqueIDVariable characters (50)結(jié)束環(huán)節(jié)IDEndActivityUniqueIDVariable characters (50)開(kāi)始點(diǎn)X坐標(biāo)BeginPointXVariable characters (50)開(kāi)始點(diǎn)Y坐標(biāo)BeginPointYVariable characters (50)結(jié)束點(diǎn)X坐標(biāo)EndPointXVariable characters (50)結(jié)束點(diǎn)Y坐標(biāo)EndPointYVariable characters (50)中間點(diǎn)1Z坐標(biāo)TurnPoint1XVariable characters (50)中間點(diǎn)1Y坐標(biāo)TurnPoint1YVariable characters (50)中間點(diǎn)2X坐標(biāo)TurnPoint2XVariable characters (50)中間點(diǎn)2Y坐標(biāo)TurnPoint2YVariable characters (50)Z標(biāo)簽ZIndexVariable characters (50)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.4 實(shí)體24 環(huán)節(jié)角色I(xiàn)II.1.4.1 實(shí)體24 環(huán)節(jié)角色的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)環(huán)節(jié)定義主鍵UniqueIDVariable characters (50)角色外鍵Role_OIDVariable characters (50)工作權(quán)值WEIGHTFloat順序號(hào)OrderByNumber辦理權(quán)限HandleRIghtInteger創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.5 實(shí)體26 流程實(shí)例III.1.5.1 實(shí)體26 流程實(shí)例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵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當(dāng)前主辦人CurrentUserVariable characters (50)當(dāng)前流轉(zhuǎn)標(biāo)簽RuleNameVariable characters (100)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.6 實(shí)體27 環(huán)節(jié)實(shí)例III.1.6.1 實(shí)體27 環(huán)節(jié)實(shí)例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)實(shí)例外鍵CaseOIDVariable 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)順序號(hào)OrderVariable characters (50)X坐標(biāo)PositionXVariable characters (50)Y坐標(biāo)PositionYVariable characters (50)重復(fù)方向RepeatDirectionVariable characters (50)Z標(biāo)簽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 實(shí)體28 流轉(zhuǎn)實(shí)例III.1.7.1 實(shí)體28 流轉(zhuǎn)實(shí)例的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)實(shí)例外鍵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)開(kāi)始環(huán)節(jié)IDBeginActivityUniqueIDVariable characters (50)結(jié)束環(huán)節(jié)IDEndActivityUniqueIDVariable characters (50)開(kāi)始點(diǎn)X坐標(biāo)BeginPointXVariable characters (50)開(kāi)始點(diǎn)Y坐標(biāo)BeginPointYVariable characters (50)結(jié)束點(diǎn)X坐標(biāo)EndPointXVariable characters (50)結(jié)束點(diǎn)Y坐標(biāo)EndPointYVariable characters (50)中間點(diǎn)1Z坐標(biāo)TurnPoint1XVariable characters (50)中間點(diǎn)1Y坐標(biāo)TurnPoint1YVariable characters (50)中間點(diǎn)2X坐標(biāo)TurnPoint2XVariable characters (50)中間點(diǎn)2Y坐標(biāo)TurnPoint2YVariable characters (50)Z標(biāo)簽ZIndexVariable characters (50)創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.8 實(shí)體29 實(shí)例任務(wù)III.1.8.1 實(shí)體29 實(shí)例任務(wù)的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)實(shí)例外鍵CaseOIDVariable characters (50)環(huán)節(jié)實(shí)例外鍵AC_OIDVariable characters (50)來(lái)源流轉(zhuǎn)SourceRuleVariable characters (500)來(lái)源環(huán)節(jié)SourceActivityVariable characters (500)完成用戶IDFinishUserOIDVariable characters (50)來(lái)源任務(wù)SourceTaskVariable characters (500)退回任務(wù)BackTaskVariable characters (500)完成時(shí)間FinishTimeDate & Time完成狀態(tài)FinishStateInteger接收狀態(tài)ReceiveStateInteger創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.9 實(shí)體29A 任務(wù)指派III.1.9.1 實(shí)體29A 任務(wù)指派的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)實(shí)例外鍵CaseOIDVariable characters (50)任務(wù)外鍵Task_OIDVariable characters (50)實(shí)例分配人員外鍵CaseRoleUser_OIDVariable characters (50)辦理人員IDUserOIDVariable characters (50)角色外鍵Role_OIDVariable characters (50)完成時(shí)間FinishTimeDate & Time辦理狀態(tài)HandleStateInteger完成人OIDFinishUserOIDVariable characters (50)完成狀態(tài)FinishStateInteger接收狀態(tài)ReceiveStateInteger創(chuàng)建日期CreateDateDate & Time創(chuàng)建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)III.1.10 實(shí)體29B 流程審批信息III.1.10.1 實(shí)體29B 流程審批信息的屬性的清單名稱代碼數(shù)據(jù)類型主鍵OIDVariable characters (50)實(shí)例外鍵CaseOIDVariable characters (50)任務(wù)外鍵TaskOIDVariable characters (50)任務(wù)指派外鍵ASSIGN_OIDVariable characters (50)流轉(zhuǎn)標(biāo)簽RuleName