Windchill数据字典

1、1.对象数据模块1.1部件Master部件master(WTPartMaster)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2,wt.part.WTPartMaster该表对应的类name部件名称wtpartnumber,部件编号createstampa2创建时间modifystampa2,更新时间updatecounta2updatestampa2更新时间description描述ida3containerreference对应表(PDMLinkProduc中ida2a2)外键(PDMLinkProduct)classnamekeycontainerreferen

2、该外键表对应类enabledserieswt.series.HarvardSeriesida3organizationreference对应表(WTOrganization中ida2a2外键(WTOrganization)classnamekeyorganizationrefe1.2部件(WTPart)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.part.WTPart该表对应的类modifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3container

3、reference对应表(PDMLinkProduct中ida2a2)外键(PDMLinkProduct)classnamekeycontainerreferen该外键表对应类statecheckoutinfo检入，检出状态值为c/i检入,c/o检出ida3a2checkoutinfoclassnamekeya2checkoutinfocontractnumberida3domainref对应表(AdministrativeDomain中ida2a2)夕卜键(AdministrativeDomain)classnamekeydomainrefwt.admin.AdministrativeDom

4、ain该外键表对应类ida3a2folderinginfo对应表(Cabinet中ida2a2)外键(Cabinet)classnamekeya2folderinginfowt.folder.Cabinet该外键表对应类ida3b2folderinginfo对应表(SubFolder中ida2a2)外键(SubFolder)classnamekeyb2folderinginfowt.folder.SubFolder该外键表对应类Nameb2folderinginfo文件夹名ida3d2iterationinfo对应表(WTUser中ida2a2)外键（WTUser）classnamekeyd2

5、.WTUser该外键表对应类ida3b2iterationinfo对应表(WTUser中ida2a2)外键（WTUser）.WTUser该外键表对应类iterationida2iterationinfo小版本值如（1,2）latestiterationinfo是否为最新版本值为（0/1）,1即为最新版本ida3masterreference对应表(WTPartMaster中ida2a2)外键(WTPartMaster)classnamekeymasterreferencewt.part.WT

6、PartMasterida3a2state对应表(LifeCycleTemplate中ida2a2)外键(LifeCycleTemplate)classnamekeya2statewt.lifecycle.LifeCycleTemplatestatestate生命周期状态ida3view对应表（View中ida2a2）外键（View）classnamekeyviewwt.vc.views.View该外键表对应类（视图）ida2typedefinitionreference对应表(WTTypeDefinition中ida2a2)外键(WTTypeDefinition)1.3部件关联部件关联部件（

7、WTPartUsageLink）字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.part.WTPartUsageLinkmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3a5对应表（WTPart中的ida2a2）外键（WTPart）classnamekeyroleaobjectrefwt.part.WTPartida3b5对应表(WTPartMaster的ida2a2)外键(WTPartMaster)classnamekeyrolebobjectre

8、fwt.part.WTPartMasterlinenumberisnull行号valueb7位号amounta7数量unita7单位select*fromwtpartmasterpmtwherepmt.ida2a2in(selectpul.ida3b5fromwtpartpt,wtpartmasterptm,wtpartusagelinkpulwherept.ida3masterreference=ptm.ida2a2andpul.ida3a5=pt.ida2a2andpt.latestiterationinfo=1andptm.wtpartnumber=GC000040)1.4说明文档关联说

9、明文档关联表(WTPartDescribeLink)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.part.WTPartDescribeLinkmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3a5对应表(WTPart中ida2a2)外键(WTPart)classnamekeyroleaobjectrefwt.part.WTPartida3b5对应表(WTDocument中ida2a2)外键(WTDocument)classnamekeyroleb

10、objectrefwt.doc.WTDocumentselect*fromwtdocumenttdwheretd.ida2a2in(selectpd.ida3b5fromwtpartpt,wtpartmasterptm,WTPartDescribeLinkpdwherept.ida3masterreference=ptm.ida2a2andpd.ida3a5=pt.ida2a2andpt.latestiterationinfo=1andptm.wtpartnumber=GC000040)1.5参考文档关联参考文档关联表（WTPartReferenceLink）字段名字段描述关系描述ida2a2

11、唯一标识主键classnamea2a2wt.part.WTPartReferenceLinkmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3a5对应表（WTPart中ida2a2）外键（WTPart）classnamekeyroleaobjectrefwt.part.WTPartida3b5对应表(WTDocumentMaster中ida2a2)外键(WTDocumentMaster)classnamekeyrolebobjectrefwt.doc.WTDocumentMast

12、erselect*fromwtdocumentmasterdmwheredm.ida2a2in(selectpr.ida3b5fromwtpartpt,wtpartmasterptm,wtpartreferencelinkprwherept.ida3masterreference=ptm.ida2a2andpr.ida3a5=pt.ida2a2andpt.latestiterationinfo=1andptm.wtpartnumber=GC000040)1.6WTPartSubstituteLink(WTPartSubstituteLink)字段名字段描述关系描述ida2a2唯一标识主键cla

13、ssnamea2a2wt.part.WTPartSubstituteLinkmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3a5对应表(WTPartUsageLink中ida2a2)外键(WTPartUsageLink)classnamekeyroleaobjectrefwt.part.WTPartUsageLinkida3b5对应表(WTPartMaster中ida2a2)外键(WTPartMaster)classnamekeyrolebobjectrefwt.part.WT

14、PartMasterida3domainref对应表(AdministrativeDomain中ida2a2)夕卜键(AdministrativeDomain)classnamekeydomainrefwt.admin.AdministrativeDomainselect*fromwtpartsubstitutelinksub,wtpartusagelinkusagewheresub.ida3a5=usage.ida2a2软类型Master软类型(WTTypeDefinitionMaster)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2m.ptc.core.meta

15、.type.mgmt.server.impl.WTTypeDefinitionMastermodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间displaynamekey显示名称descriptionkey描述hierarchydisplaynamekey分级显示名称软类型软类型(WTTypeDefinition)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2com.ptc.core.meta.type.mgmt.server.impl.WTTypeDefinit

16、ionmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3domainref对应表(AdministrativeDomain中ida2a2)夕卜键(AdministrativeDomain)classnamekeydomainrefwt.admin.AdministrativeDomainida3a2folderinginfo,对应表（Cabinet中ida2a2）外键(Cabinet)classnamekeya2folderinginfowt.folder.Cabinetstat

17、echeckoutinfo检入检出状态icon图片路径name类型名称ida3masterreference对应表(WTTypeDefinitionMaster中ida2a2)外键(WTTypeDefinitionMaster)classnamekeymasterreferencecom.ptc.core.meta.type.mgmt.server.impl.WTTypeDefinitionMasterlatestiterationinfo是否为最新版本查询软类型SELECTA2.*FROMWTTypeDefinitionMasterA0,WTTypeDefinitionAl,WTPartA2

18、WHERE(A0.IDA2A2=A1.IDA3MASTERREFERENCE)AND(A1.IDA2A2=A2.IDA2TYPEDEFINITIONREFERENCE)AND(A2.LATESTITERATI0NINF0=T)AND(A0.INTHID=wt.part.WTPart)软属性名软属性名(stringdefintion)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.iba.definition.StringDefinitionmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2u

19、pdatestampa2更新时间ida3domainref对应表(AdministrativeDomain中ida2a2)夕卜键(AdministrativeDomain)classnamekeydomainrefwt.admin.AdministrativeDomainhierarchydisplayname分级显示名称name名称description描述displayname显示名称软属性值软属性值(stringvaue)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.iba.value.StringValuemodifystampa2更新时间creates

20、tampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3a4对应表如下(WTPart、ClassificationNode、WTTypeDefinition、WTDocment等的ida2a2)外键(WTPart)外键(ClassificationNode)外键(WTTypeDefinition)外键(WTDocment)等classnamekeya4wt.part.WTPartwt.csm.navigation.ClassificationNodeida3a6对应表(StringDefinition的ida2a2)外键(Strin

21、gDefinition)classnamekeya6wt.iba.definition.StringDefinitionvalue软属性值value2软属性值根据软属性名与part编号查询软属性值selectsv.valuefromstringdefinitionsf,stringvaluesvwheresv.ida3a6=sf.ida2a2andsv.classnamekeya4=wt.part.WTPartandsv.ida3a4=(selecttp.ida2a2fromwtparttp,wtpartmastertpmwheretp.ida3masterreference=tpm.ida2

22、a2andtp.latestiterationinfo=1andtpm.wtpartnumber=0000000141)=Description1.11分类容器类型分类类型(ClassificationStruct)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.csm.navigation.ClassificationStructmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3domainref对应表(Administrati

23、veDomain的ida2a2)夕卜键AdministrativeDomainclassnamekeydomainrefwt.admin.AdministrativeDomainida3a5对应表(ReferenceDefinition的ida2a2)外键(ReferenceDefinition)classnamekeya5wt.iba.definition.ReferenceDefinitionclassname对应的类型分类（如wt.part.WTPart）1.12分类容器分类容器(referencedefinition)字段名字段描述关系描述ida2a2唯一标识主键classnamea2

24、a2wt.iba.definition.ReferenceDefinitionmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3definitionparentreferenc对应表(AttributeOrganizer等的ida2a2)外键(AttributeOrganizer)classnamekeydefinitionparentwt.iba.definition.AttributeOrganizerida3domainref对应表(AdministrativeDomain

25、的ida2a2)夕卜键AdministrativeDomainclassnamekeydomainrefwt.admin.AdministrativeDomaindescription分类容器描述displayname分类容器显示名name分类容器名referencedclassname分类容器对应的分类类型根据分类容器类型查出分类容器selectrefd*fromclassificationstructeft,referencedefinitionrefdwherecft.ida3a5=refd.ida2a2andcft.classname=wt.part.WTPart1.10分类分类(Cl

26、assificationNode)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.csm.navigation.ClassificationNodemodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3a6对应表(ClassificationStruct的ida2a2)外键(ClassificationStruct)classnamekeya6wt.csm.navigation.ClassificationStructida3domainref对应表(A

27、dministrativeDomain的ida2a2)夕卜键AdministrativeDomainclassnamekeydomainrefwt.admin.AdministrativeDomainida3b6对应表(ClassificationNode的ida2a2)外键ClassificationNodeclassnamekeyb6wt.csm.navigation.ClassificationNodedescription分类描述image分类显示图片name分类名根据分类容器名与分类容器类型查询分类select*fromclassificationnodectnwherectn.id

28、a3a6in(selectcft.ida2a2fromclassificationstructcft,referencedefinitionrefdwherecft.ida3a5=refd.ida2a2andcft.classname=wt.part.WTP=Part)根据分类容器名与分类容器类型查询顶级分类select*fromclassificationnodectnwherectn.ida3a6in(selectcft.ida2a2fromclassificationstructcft,referencedefinitionrefdwherecft.ida3

29、a5=refd.ida2a2andcft.classname=wt.part.WTP=Part)andctn.idA3B6=02.生命周期管理模块2.1生命周期模版master生命周期模版master(LifeCycleTemplateMatser)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2,wt.lifecycle.LifeCycleTemplateMastername生命周期名称createstampa2创建时间modifystampa2,更新时间updatecounta2updatestampa2更新时间description描

30、述ida3containerreference对应表(ExchangeContainer中ida2a2)夕卜键(ExchangeContainer)classnamekeycontainerreferenwt.inf.container.ExchangeContainer(交换容器)supportedclass所关联的对象类型2.2生命周期模版生命周期模版(lifecycletemplate)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.lifecycle.LifeCycleTemplatename工作流模版名称modifystampa2更新时间createst

31、ampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3containerreference对应表(ExchangeContainer中ida2a2)夕卜键(ExchangeContainer)classnamekeycontainerreferenwt.inf.container.ExchangeContainer(容器)ida3b9对应表(PhaseTemplate中ida2a2)外键(PhaseTemplate)classnamekeyb9ida3b8对应表（WTUser中ida2a2）外键（WTUser）classnameke

32、.WTUserdescription描述ida3masterreference对应(LifeCycleTemplateMaster中ida2a2)外键(LifeCycleTemplateMaster)classnamekeymasterreferencewt.lifecycle.LifeCycleTemplateMasterida3domainref对应表(AdministrativeDomain的ida2a2)夕卜键AdministrativeDomainclassnamekeydomainrefwt.admin.AdministrativeDomainida3a2fold

33、eringinfo对应表(Cabinet中ida2a2)外键(Cabinet)classnamekeya2folderinginfowt.folder.Cabinet该外键表对应类ida3d2iterationinfo对应表(WTUser中ida2a2)外键（WTUser）.WTUserida3b2iterationinfo对应表(WTUser中ida2a2)外键（WTUser）.WTUserlatestiterationinfo疋否为取新版本1/0（是/否）st

34、atecheckoutinfo检出状态c/I检入根据生命周期名查询SELECTA1.*FROMLifeCycleTemplateMasterAO,LifeCycleTemplateA1WHERE(A0.idA2A2=A1.idA3masterReference)AND(AO.name=基本)AND(A1.latestiterationInfo=1)2.3生命周期状态生命周期状态(phasetemplate)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.lifecycle.PhaseTemplatename生命周期状态名称phasestate生命周期状态keycr

35、eatestampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3a7classnamekeya7ida3b7classnamekeyb71.4生命周期状态关联生命周期状态关联(phaselink)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.lifecycle.PhaseLinkmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3b5对应表(PhaseTemplate中ida2a2)外键

36、(PhaseTemplate)classnamekeyrolebobjectrefwt.lifecycle.PhaseTemplateida3a5对应表(LifeCycleTemplate中ida2a2)外键(LifeCycleTemplate)classnamekeyroleaobjectref,wt.lifecycle.LifeCycleTemplate查询生命周期模板所对应的状态select*fromphasetemplatephwhereph.ida2a2in(SELECTA3.Ida3b5FROMLifeCycleTemplateMasterAO,LifeCycleTemplateA

37、l,phaselinkA3WHERE(A0.idA2A2=A1.idA3masterReference)ANDA3.ida3a5=A1.ida2a2and(A0.name=基本)AND(A1.latestiterationInfo=1).工作流管理模块11工作流模版master工作流模版master(Wfprocesstemplatemaster)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2,wt.workflow.definer.WfProcessTemplateMastername工作流模版名称createstampa2创建时间modifystampa2,更新时

38、间updatecounta2updatestampa2更新时间description描述ida3containerreference对应表(ExchangeContainer中ida2a2)夕卜键(ExchangeContainer)classnamekeycontainerreferenwt.inf.container.ExchangeContainer(交换容器)enabledseriesmarkfordeletea21.2工作流模版工作流模版(Wfprocesstemplate)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.workflow.definer

39、.WfProcessTemplatename工作流模版名称modifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3containerreference对应表(ExchangeContainer中ida2a2)夕卜键(ExchangeContainer)classnamekeycontainerreferenwt.inf.container.ExchangeContainer(容器)statecheckoutinfo检入，检出状态ida3a2checkoutinfoclassnameke

40、ya2checkoutinfoida3b8对应表（WTUser中ida2a2）外键（WTUser）.WTUserdescription描述ida3masterreference对应(WfProcessTemplateMaster中ida2a2)外键(WfProcessTemplateMaster)classnamekeymasterreferencewt.workflow.definer.WfProcessTemplateMasterida3domainrefclassnamekeydomainrefwt.admin.AdministrativeDoma

41、indurationeventconfigurationida3a2folderinginfoclassnamekeya2folderinginfowt.folder.Cabinetida3b2folderinginfoclassnamekeyb2folderinginfonameb2folderinginfoida3formatclassnamekeyformatwt.content.DataFormaticonname图片路径inheriteddomainbranchiditerationinfoida3d2iterationinfoclassnamekeyd2iterationinfow

42、.WTU.WTUsernoteiterationinfoida3c2iterationinfoclassnamekeyc2iterationinfostateiterationinfodatelockclassnamekeya2lockida3a2locknotelockoverduenotificationlistoverviewindexida3a2ownershipclassnam

43、ekeya2ownershipida3a5classnamekeya5ida3parenttemplateclassnamekeyparenttemplateprocessdurationresponsibleroleroutertypesecuritylabelsstartdelaystartprocessdelaytimepastdeadlinetimetodeadlineusereventlistxcoordycoordcontextsignaturecheckoutinfoisnullcategoryblob$overviewindexblob$contextsignature1.3工

44、作流实列工作流实列（WfProcess）字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.workflow.engine.WfProcessname工作流实列名称modifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3a5对应表(WfProcessTemplate中的ida2a2)外键(WfProcessTemplate)classnamekeya5wt.workflow.definer.WfProcessTemplatestate工作流的状态startti

45、me工作流启动时间endtime工作流终止时间wtkey工作流key标识ida3containerreference对应表（产品或存储等容器中的ida2a2）外键（产品、存储等容器）classnamekeycontainerreferen（产品、存储等容器类）businessobjreference对象流key如(VR:wt.doc.WTDocument:114244)ida3b7对应表（WTUser中ida2a2）外键（WTUser）.WTUserida3domainrefclassnamekeydomainrefwt.admin.Administra

46、tiveDomaindescription描述ida3teamid对应表（Team中ida2a2）外键（Team）classnamekeyteamidwt.team.Teamida3teamtemplateid对应表(TeamTemplate中ida2a2)外键(TeamTemplate)classnamekeyteamtemplateidwt.team.TeamTemplateadsqenalerttimeblob$contextchangestatetimecontextida3c7classnamekeyc7timetostartcreatorisnulldsqendeadlinedea

47、dlinedurationdescriptioneventconfigurationeventsetinheriteddomainida3a2ownershipclassnamekeya2ownershippdsqenpriorityida3a7classnamekeya7ida3d7classnamekeyd7ida3a6classnamekeya6roleprincipalmapsecuritylabelssuspendtimeteamidisnullteamtemplateidisnulltemplateisnull,1.4工作流任务工作流任务（Workitem）字段名字段描述关系描述i

48、da2a2唯一标识主键classnamea2a2wt.workflow.work.WorkItemmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间status状态completedby完成任务用户名description工作流任务描述（说明）ida3c4对应表(WfAssignment中ida2a2)外键(WfAssignment)classnamekeyc4wt.workflow.work.WfAssignmentclassnamekeyb4对象任务key如(VR:wt.doc.WT

49、Document:122232)ida3a4对应表(WfAssignedActivity中ida2a2)外键(WfAssignedActivity)classnamekeya4,wt.workflow.work.WfAssignedActivitytaskurlpathinfoTaskUrlrole角色ida3d4classnamekeyd4blob$contextcontexteventsetida3a2ownershipclassnamekeya2ownershippriorityreassignedrequiredvariablepermissionmap1.5工作流活动模板工作流活动模

50、板(WfassignedactiVtytemplate)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.workflow.definer.WfAssignedActivityTemplatemodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3containerreference对应表(ExchangeContainer中ida2a2)夕卜键(ExchangeContainer)classnamekeycontainerreferenwt.inf.con

51、tainer.ExchangeContainer(容器)ida3domainrefclassnamekeydomainrefwt.admin.AdministrativeDomainname工作流活动模版名description工作流活动模版描述（说明）iconname工作流活动图片路径ida3a5对应表(ProcessStepTemplateLink中ida2a2)外键(ProcessStepTemplateLink)classnamekeya5wt.workflow.definer.ProcessStepTemplateLinkida3parenttemplate对应表(WfProcess

52、Template中ida2a2)外键(WfProcessTemplate)classnamekeyparenttemplatewt.workflow.definer.WfProcessTemplatetasknameTaskNameusereventlist工作流活动模版路由事件器集合ida3a6classnamekeya6ida3b6classnamekeyb6actorrolelistblob$contextsignaturecategorycontextsignaturedurationeventconfigurationinheriteddomaininstructionsoverdu

53、enotificationlistprincipalreflistprocessdurationprojectreflistresponsiblerolerolelistroutertypesecuritylabelssendnotificationsigningrequiredstartdelaystartprocessdelayteamreflistteamreferenceisnullteamtemplatereferenceisnull,teamvariablenametimepastdeadlinetimetodeadlinevariablereflistxcoordycoord1.

54、6工作流活动实列工作流活动实列（Wfassignedactivity）字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.workflow.work.WfAssignedActivitymodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间name工作流活动名称wtkey工作流活动key标识ida3containerreference对应表（产品或存储等容器中的ida2a2）外键（产品、存储等容器）classnamekeycontainerreferen（产品、存储

55、等容器类）ida3domainrefclassnamekeydomainrefwt.admin.AdministrativeDomainida3parentprocessref对应表(WfProcess中ida2a2)外键(WfProcess)classnamekeyparentprocessrefwt.workflow.engine.WfProcessstate状态starttime开始时间endtime结束时间ida3a5对应表(WfAssignedActivityTemplate中ida2a2)外键(WfAssignedActivityTemplate)classnamekeya5wt.

56、workflow.definer.WfAssignedActivityTemplateusereventlist工作流活动路由事件器集合description工作流活动描述(说明)adsqenalerttimetimetostart,tripcounttemplateisnullsuspendtimesecuritylabelsroutertypeprioritypdsqenparentprocessrefisnulloutputvariablemapinstructionsinputvariablemapinheriteddomaineventseteventconfigurationdea

57、dlinedurationblob$contextdeadlinedsqenchangestatetimecontext17工作流活动路由工作流活动路由(wfvotingeventaudit)字段名字段描述关系描述ida2a2唯一标识主键classnamea2a2wt.workflow.engine.WfVbtingEventAuditmodifystampa2更新时间createstampa2创建时间markfordeletea2updatecounta2updatestampa2更新时间ida3domainrefclassnamekeydomainrefwt.admin.Administr

58、ativeDomainactivitykey,对应表(WfAssignedActivity中wtkey)外键(WfAssignedActivity)activityname工作流活动名称processkey对应表(WfProcess中wtkey)外键(WfProcess)processname工作流实列名processtemplatename工作流模版名role角色ida3a6对应表（WTUser中ida2a2）表示负责该路由用户外键（WTUser）.WTUserida3a5对应表（WTUser中ida2a2）表示完成该路由用户外键（WTUser）.WTUsereventlist表示兀成路由事件中选取的路由信息集合eventtype路由事件类型assigneerefisnullinheritedd