《工作流引擎数据库设计.doc》由会员分享，可在线阅读，更多相关《工作流引擎数据库设计.doc（8页珍藏版）》请在三一文库上搜索。
1、Sybase PowerDesig ner Logical Data Model ReportModel: 04数据库设计Repo比数据库设计Author: Admi nistratorVersion:Date: 2016/8/3Summary:ER图Vi- -I - - - -na-a- Fi f9 Ji. Jx T13d% JfV. -llli:Z5E1- 二:-=CJ|u h Ata b bBAJ h 5 Ifr J -ariaEl : ha*33 er!： afL-ifle :?araefT 7gar i ! bt 圧 nz l - 1 =: _ x =r a. IsmsTLizls-
2、 :nazaz:sr3:?i：oi 【ZC：13： tX石老人左 番叮rriii如“ EHrtrt 或.誉.irlz.il?二二zr a.二:匚屯 ufi tel t :古* 去左ViviliA倉 c risii-r. 3-上*工-L- 32：cIT L ir *ULLZiaZT-STS.12ffllT:x .l=1-bsHu*： TflFB pe-ar .-a -ecIE；N d：】cJlITCTtT 9Bar1 i3.r 】klT3.X!HT E =，2m:*i 4 3 l:K曲邛程瞇一蚤“ r ASRA2 V n 一 士m TargS .a.T xatla V*i idbl.?-疋 4;
3、=4 P=- ar m * rripilM c.r jk/= L = aria; k ar ia:! S-IHU 静S3 建唱 后左无丹鼻芒-文!VuiulfEKsriEstnVuiaclrcLar lEt l-FEin 迅 rtalMT-diAill r -：I4r-ci.triaElf:LiriTITX3.TT 3cl Ke Yaor ie-t rcCaOCrlalElar&Gie-irjEvifiabiwELariczEFf:辽1上丄二barie：:卜 匸H人W宅近*-廉注吉口 二 m Ja-F 旦 Juffi咙 -=-_一詣汙 -工-IZlKTll =u?t La=. 土 T: aw-
4、 IfillKf 1Variazle zhzzra.zrixclr avrti* VriMv H1近丄r Viriafalt Varixcl*Vul-thlt 叶匕 T：ztariz-srs 对亡壮rf- t UT uHzr.iJL：L：ri =Kir4E：irx = Ka? J. = T-I T-E blAbLih kI简单模型描述 实体的清单称21流程定义WF WorkFlow22环节定义WF Activity23流转定义WF_Rule24环节角色WF ActiRole26流程实例WF CaseFlow27环节实例WF CaseActivity28流转实例WF CaseRule29实例任务
5、WF CaseTask29A任务指派WF CaseTaskAssig n29B流程审批信息WF CaseApprove29C实例环节角色WF CaseActiRole完全模型描述实体21流程定义实体21流程定义的属性的清单名称代码数据类型主键OIDVariable characters (50)流程ID:Uni quelDVariable characters (50)IDIDVariable characters (50)流程名称NAMEVariable characters (50)描述Descripti onVariable characters (500)宽度WidthVariable
6、 characters (50)高度1HeightVariable characters (50)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体22环节定义实体22环节定义的属性的清单名称代码数据类型主键OIDVariable characters (50)流程外键WF OIDVariable characters (50)环节定义主键Uni quelDVariable characters
7、 (50)状态StateVariable characters (50)用户名UserNameVariable characters (50)环节名称ActivityNameVariable characters (50)环节类型TypeVariable characters (50)顺序号OrderVariable characters (50)X坐标Positio nXVariable characters (50)Y坐标Positio nYVariable characters (50)重复万向RepeatDirectio nVariable characters (50)Z标签ZI n
8、dexVariable characters (50)配置内容ValueVariable characters (1000)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体23流转定义实体23流转定义的属性的清单名称代码数据类型主键OIDVariable characters (50)流程外键WF OIDVariable characters (50)流转主键Uni quelDVariable
9、 characters (50)状态StateVariable characters (50)方法名MethodNameVariable characters (50)流转名称RuleNameVariable characters (50)流转类型Lin eTypeVariable characters (50)开始环节ID:Begi nActivity Un iqueIDVariable characters (50)结束环节IDEn dActivityU ni queIDVariable characters (50)开始点X坐标Beg in Po intXVariable charact
10、ers (50)开始点Y坐标Beg in Po intYVariable characters (50)结束点X坐标En dPo intXVariable characters (50)结束点Y坐标En dPo intYVariable characters (50)中间点1Z坐标TurnPoi nt1XVariable characters (50)中间点1Y坐标TurnPoi nt1YVariable characters (50)中间点2X坐标TurnPoi nt2XVariable characters (50)中间点2Y坐标TurnPoi nt2YVariable character
11、s (50)Z标签ZI ndexVariable characters (50)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体24环节角色实体24环节角色的属性的清单名称代码数据类型主键OIDVariable characters (50)环节定义主键Uni quelDVariable characters (50)角色外键Role OIDVariable characters (50)工作
12、权值WEIGHTFloat顺序号OrderByNumber办理权限Han dleRIghtIn teger创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体26流程实例实体26流程实例的属性的清单名称代码数据类型主键OIDVariable characters (50)流程外键WF OIDVariable characters (50)流程IDUni quelDVariable characte
13、rs (50)IDIDVariable characters (50)业务难度BusiDiffictFloat流程名称NAMEVariable characters (50)描述Descripti onVariable characters (500)宽度WidthVariable characters (50)高度HeightVariable characters (50)完成状态Fini shStateIn teger当前主办人Curren tUserVariable characters (50)当前流转标签RuleNameVariable characters (100)创建日期Cre
14、ateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体27环节实例实体27环节实例的属性的清单名称代码数据类型主键OIDVariable characters (50)实例外键CaseOIDVariable characters (50)环节定义主键Uni quelDVariable characters (50)状态StateVariable characters (50)用户名UserNameVariable
15、 characters (50)环节名称ActivityNameVariable characters (50)环节类型TypeVariable characters (50)顺序号OrderVariable characters (50)X坐标Positio nXVariable characters (50)Y坐标Positio nYVariable characters (50)重复万向RepeatDirectio nVariable characters (50)Z标签ZI ndexVariable characters (50)配置内容ValueVariable characters
16、 (1000)创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体28流转实例实体28流转实例的属性的清单名称代码数据类型主键OIDVariable characters (50)实例外键CaseOIDVariable characters (50)流转主键Uni quelDVariable characters (50)状态StateVariable characters (50)方法名Meth
17、odNameVariable characters (50)流转名称RuleNameVariable characters (50)流转类型Lin eTypeVariable characters (50)开始环节IDBegi nActivity Un iqueIDVariable characters (50)结束环节IDEn dActivityU ni queIDVariable characters (50)开始点X坐标Beg in Po intXVariable characters (50)开始点Y坐标Beg in Po intYVariable characters (50)结束点
18、X坐标En dPo intXVariable characters (50)结束点Y坐标En dPo intYVariable characters (50)中间点1Z坐标TurnPoi nt1XVariable characters (50)中间点1Y坐标TurnPoi nt1YVariable characters (50)中间点2X坐标:TurnPoi nt2XVariable characters (50)中间点2Y坐标TurnPoi nt2YVariable characters (50)Z标签ZI ndexVariable characters (50)创建日期CreateDate
19、Date & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体29实例任务实体29实例任务的属性的清单名称代码数据类型主键OIDVariable characters (50)实例外键CaseOIDVariable characters (50)环节实例外键AC_OIDVariable characters (50)来源流转SourceRuleVariable characters (500)来源环节SourceActivityVar
20、iable characters (500)完成用户IDFini shUserOIDVariable characters (50)来源任务SourceTaskVariable characters (500)退回任务BackTaskVariable characters (500)完成时间Fin ishTimeDate & Time完成状态Fini shStateIn teger接收状态ReceiveStateIn teger创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & T
21、ime修改人UpdateUserVariable characters (50)实体29A任务指派实体29A任务指派的属性的清单名称代码数据类型主键OIDVariable characters (50)实例外键CaseOIDVariable characters (50)任务外键Task OIDVariable characters (50)实例分配人员外键CaseRoleUser_OIDVariable characters (50)办理人员IDUserOIDVariable characters (50)角色外键Role_OIDVariable characters (50)完成时间Fin
22、 ishTimeDate & Time办理状态Han dleStateIn teger完成人OIDFini shUserOIDVariable characters (50)完成状态Fini shStateIn teger接收状态ReceiveStateIn teger创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体29B流程审批信息实体29B流程审批信息的属性的清单名称代码数据类型主键OID
23、Variable characters (50)实例外键CaseOIDVariable characters (50)任务外键TaskOIDVariable characters (50)任务指派外键ASSIGN_OIDVariable characters (50)流转标签RuleNameVariable characters (50)审批信息ApprovalI nfoVariable characters (200)用户OIDUserOIDVariable characters (50)用户名称UserNameVariable characters (50)创建日期CreateDateDa
24、te & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)实体29C实例环节角色实体29C实例环节角色的属性的清单名称代码数据类型主键OIDVariable characters (50)环节实例外键AC OIDVariable characters (50)环节定义主键Uni quelDVariable characters (50)实例外键CaseOIDVariable characters (50)角色外键Role OIDVariable characters (50)工作权值WEIGHTFloat办理权限Han dleRIghtIn teger顺序号OrderByNumber创建日期CreateDateDate & Time创建人CreateUserVariable characters (50)修改日期UpdateDateDate & Time修改人UpdateUserVariable characters (50)