1、1.對象數(shù)據(jù)模塊1.1部件Master部件master(WTPartMaster)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2,wt.part.WTPartMaster該表對應的類name部件名稱wtpartnumber,部件編號createstampa2創(chuàng)建時間modifystampa2,更新時間updatecounta2updatestampa2更新時間description描述ida3containerreference對應表(PDMLinkProduc中ida2a2)外鍵(PDMLinkProduct)classnamekeycontainerreferen

2、該外鍵表對應類enabledserieswt.series.HarvardSeriesida3organizationreference對應表(WTOrganization中ida2a2外鍵(WTOrganization)classnamekeyorganizationrefe1.2部件(WTPart)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.part.WTPart該表對應的類modifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3container

3、reference對應表(PDMLinkProduct中ida2a2)外鍵(PDMLinkProduct)classnamekeycontainerreferen該外鍵表對應類statecheckoutinfo檢入，檢出狀態(tài)值為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生命周期狀態(tài)ida3view對應表（View中ida2a2）外鍵（View）classnamekeyviewwt.vc.views.View該外鍵表對應類（視圖）ida2typedefinitionreference對應表(WTTypeDefinition中ida2a2)外鍵(WTTypeDefinition)1.3部件關(guān)聯(lián)部件關(guān)聯(lián)部件（

7、WTPartUsageLink）字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.part.WTPartUsageLinkmodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3a5對應表（WTPart中的ida2a2）外鍵（WTPart）classnamekeyroleaobjectrefwt.part.WTPartida3b5對應表(WTPartMaster的ida2a2)外鍵(WTPartMaster)classnamekeyrolebobjectre

8、fwt.part.WTPartMasterlinenumberisnull行號valueb7位號amounta7數(shù)量unita7單位select*fromwtpartmasterpmtwherepmt.ida2a2in(selectpul.ida3b5fromwtpartpt,wtpartmasterptm,wtpartusagelinkpulwherept.ida3masterreference=ptm.ida2a2andpul.ida3a5=pt.ida2a2andpt.latestiterationinfo=1andptm.wtpartnumber=GC000040)1.4說明文檔關(guān)聯(lián)說

9、明文檔關(guān)聯(lián)表(WTPartDescribeLink)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.part.WTPartDescribeLinkmodifystampa2更新時間createstampa2創(chuàng)建時間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參考文檔關(guān)聯(lián)參考文檔關(guān)聯(lián)表（WTPartReferenceLink）字段名字段描述關(guān)系描述ida2a2

11、唯一標識主鍵classnamea2a2wt.part.WTPartReferenceLinkmodifystampa2更新時間createstampa2創(chuàng)建時間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)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵cla

13、ssnamea2a2wt.part.WTPartSubstituteLinkmodifystampa2更新時間createstampa2創(chuàng)建時間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)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2m.ptc.core.meta

15、.type.mgmt.server.impl.WTTypeDefinitionMastermodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間displaynamekey顯示名稱descriptionkey描述hierarchydisplaynamekey分級顯示名稱軟類型軟類型(WTTypeDefinition)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2com.ptc.core.meta.type.mgmt.server.impl.WTTypeDefinit

16、ionmodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3domainref對應表(AdministrativeDomain中ida2a2)夕卜鍵(AdministrativeDomain)classnamekeydomainrefwt.admin.AdministrativeDomainida3a2folderinginfo,對應表（Cabinet中ida2a2）外鍵(Cabinet)classnamekeya2folderinginfowt.folder.Cabinetstat

17、echeckoutinfo檢入檢出狀態(tài)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)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.iba.definition.StringDefinitionmodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2u

19、pdatestampa2更新時間ida3domainref對應表(AdministrativeDomain中ida2a2)夕卜鍵(AdministrativeDomain)classnamekeydomainrefwt.admin.AdministrativeDomainhierarchydisplayname分級顯示名稱name名稱description描述displayname顯示名稱軟屬性值軟屬性值(stringvaue)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.iba.value.StringValuemodifystampa2更新時間creates

20、tampa2創(chuàng)建時間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軟屬性值根據(jù)軟屬性名與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)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.csm.navigation.ClassificationStructmodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3domainref對應表(Administrati

23、veDomain的ida2a2)夕卜鍵AdministrativeDomainclassnamekeydomainrefwt.admin.AdministrativeDomainida3a5對應表(ReferenceDefinition的ida2a2)外鍵(ReferenceDefinition)classnamekeya5wt.iba.definition.ReferenceDefinitionclassname對應的類型分類（如wt.part.WTPart）1.12分類容器分類容器(referencedefinition)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2

24、a2wt.iba.definition.ReferenceDefinitionmodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3definitionparentreferenc對應表(AttributeOrganizer等的ida2a2)外鍵(AttributeOrganizer)classnamekeydefinitionparentwt.iba.definition.AttributeOrganizerida3domainref對應表(AdministrativeDomain

25、的ida2a2)夕卜鍵AdministrativeDomainclassnamekeydomainrefwt.admin.AdministrativeDomaindescription分類容器描述displayname分類容器顯示名name分類容器名referencedclassname分類容器對應的分類類型根據(jù)分類容器類型查出分類容器selectrefd*fromclassificationstructeft,referencedefinitionrefdwherecft.ida3a5=refd.ida2a2andcft.classname=wt.part.WTPart1.10分類分類(Cl

26、assificationNode)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.csm.navigation.ClassificationNodemodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3a6對應表(ClassificationStruct的ida2a2)外鍵(ClassificationStruct)classnamekeya6wt.csm.navigation.ClassificationStructida3domainref對應表(A

27、dministrativeDomain的ida2a2)夕卜鍵AdministrativeDomainclassnamekeydomainrefwt.admin.AdministrativeDomainida3b6對應表(ClassificationNode的ida2a2)外鍵ClassificationNodeclassnamekeyb6wt.csm.navigation.ClassificationNodedescription分類描述image分類顯示圖片name分類名根據(jù)分類容器名與分類容器類型查詢分類select*fromclassificationnodectnwherectn.id

28、a3a6in(selectcft.ida2a2fromclassificationstructcft,referencedefinitionrefdwherecft.ida3a5=refd.ida2a2andcft.classname=wt.part.WTP=Part)根據(jù)分類容器名與分類容器類型查詢頂級分類select*fromclassificationnodectnwherectn.ida3a6in(selectcft.ida2a2fromclassificationstructcft,referencedefinitionrefdwherecft.ida3

29、a5=refd.ida2a2andcft.classname=wt.part.WTP=Part)andctn.idA3B6=02.生命周期管理模塊2.1生命周期模版master生命周期模版master(LifeCycleTemplateMatser)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2,wt.lifecycle.LifeCycleTemplateMastername生命周期名稱createstampa2創(chuàng)建時間modifystampa2,更新時間updatecounta2updatestampa2更新時間description描

30、述ida3containerreference對應表(ExchangeContainer中ida2a2)夕卜鍵(ExchangeContainer)classnamekeycontainerreferenwt.inf.container.ExchangeContainer(交換容器)supportedclass所關(guān)聯(lián)的對象類型2.2生命周期模版生命周期模版(lifecycletemplate)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.lifecycle.LifeCycleTemplatename工作流模版名稱modifystampa2更新時間createst

31、ampa2創(chuàng)建時間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檢出狀態(tài)c/I檢入根據(jù)生命周期名查詢SELECTA1.*FROMLifeCycleTemplateMasterAO,LifeCycleTemplateA1WHERE(A0.idA2A2=A1.idA3masterReference)AND(AO.name=基本)AND(A1.latestiterationInfo=1)2.3生命周期狀態(tài)生命周期狀態(tài)(phasetemplate)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.lifecycle.PhaseTemplatename生命周期狀態(tài)名稱phasestate生命周期狀態(tài)keycr

35、eatestampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3a7classnamekeya7ida3b7classnamekeyb71.4生命周期狀態(tài)關(guān)聯(lián)生命周期狀態(tài)關(guān)聯(lián)(phaselink)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.lifecycle.PhaseLinkmodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3b5對應表(PhaseTemplate中ida2a2)外鍵

36、(PhaseTemplate)classnamekeyrolebobjectrefwt.lifecycle.PhaseTemplateida3a5對應表(LifeCycleTemplate中ida2a2)外鍵(LifeCycleTemplate)classnamekeyroleaobjectref,wt.lifecycle.LifeCycleTemplate查詢生命周期模板所對應的狀態(tài)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)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2,wt.workflow.definer.WfProcessTemplateMastername工作流模版名稱createstampa2創(chuàng)建時間modifystampa2,更新時

38、間updatecounta2updatestampa2更新時間description描述ida3containerreference對應表(ExchangeContainer中ida2a2)夕卜鍵(ExchangeContainer)classnamekeycontainerreferenwt.inf.container.ExchangeContainer(交換容器)enabledseriesmarkfordeletea21.2工作流模版工作流模版(Wfprocesstemplate)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.workflow.definer

39、.WfProcessTemplatename工作流模版名稱modifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3containerreference對應表(ExchangeContainer中ida2a2)夕卜鍵(ExchangeContainer)classnamekeycontainerreferenwt.inf.container.ExchangeContainer(容器)statecheckoutinfo檢入，檢出狀態(tài)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）字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.workflow.engine.WfProcessname工作流實列名稱modifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間ida3a5對應表(WfProcessTemplate中的ida2a2)外鍵(WfProcessTemplate)classnamekeya5wt.workflow.definer.WfProcessTemplatestate工作流的狀態(tài)startti

45、me工作流啟動時間endtime工作流終止時間wtkey工作流key標識ida3containerreference對應表（產(chǎn)品或存儲等容器中的ida2a2）外鍵（產(chǎn)品、存儲等容器）classnamekeycontainerreferen（產(chǎn)品、存儲等容器類）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）字段名字段描述關(guān)系描述i

48、da2a2唯一標識主鍵classnamea2a2wt.workflow.work.WorkItemmodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間status狀態(tài)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)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.workflow.definer.WfAssignedActivityTemplatemodifystampa2更新時間createstampa2創(chuàng)建時間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）字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.workflow.work.WfAssignedActivitymodifystampa2更新時間createstampa2創(chuàng)建時間markfordeletea2updatecounta2updatestampa2更新時間name工作流活動名稱wtkey工作流活動key標識ida3containerreference對應表（產(chǎn)品或存儲等容器中的ida2a2）外鍵（產(chǎn)品、存儲等容器）classnamekeycontainerreferen（產(chǎn)品、存儲

55、等容器類）ida3domainrefclassnamekeydomainrefwt.admin.AdministrativeDomainida3parentprocessref對應表(WfProcess中ida2a2)外鍵(WfProcess)classnamekeyparentprocessrefwt.workflow.engine.WfProcessstate狀態(tài)starttime開始時間endtime結(jié)束時間ida3a5對應表(WfAssignedActivityTemplate中ida2a2)外鍵(WfAssignedActivityTemplate)classnamekeya5wt.

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

57、dlinedurationblob$contextdeadlinedsqenchangestatetimecontext17工作流活動路由工作流活動路由(wfvotingeventaudit)字段名字段描述關(guān)系描述ida2a2唯一標識主鍵classnamea2a2wt.workflow.engine.WfVbtingEventAuditmodifystampa2更新時間createstampa2創(chuàng)建時間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