winchill磁盘文件与document的映射关系在数据库中的体现

这几天，研究了一下，winchill如何把磁盘文件，映射到数据库。

目前看来是这样，winchill分成了三个大层，五个小层，从用户层面，一直映射到磁盘。

层	表名
应用层	WTDocument、WTDocumentMaster、WTDocumentMasterKey
连接层	HoldertoContent
永久化层	ApplicationData、FvItem,FvFolder,DataFormat

代码：

SELECT
PDM8.WTDOCUMENT.DESCRIPTION,
PDM8.WTDOCUMENT.IDA3FORMAT,
PDM8.WTDOCUMENT.IDA2A2 AS "DocumentKey",
PDM8.WTDOCUMENT.TITLE AS "DocumentTitle",
PDM8.WTDOCUMENT.VERSIONIDA2VERSIONINFO,
PDM8.WTDOCUMENT.VERSIONLEVELA2VERSIONINFO,
PDM8.WTDOCUMENT.CREATESTAMPA2,
PDM8.WTDOCUMENTMASTERKEY.WTKEY AS "MasterKeyKey",
PDM8.WTDOCUMENTMASTER.NAME AS "MasterName",
PDM8.WTDOCUMENTMASTER.WTDOCUMENTNUMBER AS "DocumentNumber",
PDM8.APPLICATIONDATA.FILENAME,
PDM8.APPLICATIONDATA.FILESIZE,
PDM8.APPLICATIONDATA.DESCRIPTION AS "appDesc",
PDM8.FVITEM.UNIQUESEQUENCENUMBER,
PDM8.FVITEM.MARKFORDELETEA2,
PDM8.FVFOLDER.NAME,
PDM8.DATAFORMAT.DESCRIPTION AS "filetypeDescs",
PDM8.DATAFORMAT.MIMETYPE
FROM
PDM8.WTDOCUMENT
INNER JOIN PDM8.WTDOCUMENTMASTER ON PDM8.WTDOCUMENT.IDA3MASTERREFERENCE = PDM8.WTDOCUMENTMASTER.IDA2A2
INNER JOIN PDM8.WTDOCUMENTMASTERKEY ON PDM8.WTDOCUMENTMASTERKEY.IDA3A4 = PDM8.WTDOCUMENTMASTER.IDA2A2
INNER JOIN PDM8.HOLDERTOCONTENT ON PDM8.WTDOCUMENT.IDA2A2 = PDM8.HOLDERTOCONTENT.IDA3A5
INNER JOIN PDM8.APPLICATIONDATA ON PDM8.HOLDERTOCONTENT.IDA3B5 = PDM8.APPLICATIONDATA.IDA2A2
INNER JOIN PDM8.FVITEM ON PDM8.APPLICATIONDATA.IDA3A5 = PDM8.FVITEM.IDA2A2
INNER JOIN PDM8.FVFOLDER ON PDM8.FVITEM.IDA3A4 = PDM8.FVFOLDER.IDA2A2
INNER JOIN PDM8.DATAFORMAT ON PDM8.DATAFORMAT.IDA2A2 = PDM8.APPLICATIONDATA.IDA3B4
WHERE
PDM8.WTDOCUMENTMASTER.UPDATESTAMPA2 > to_date('2015/01/01','yyyy/MM/dd HH24:MI:SS')

大家将就看吧。因为研究这玩意的人也不多。

忘了说明 一个最重要的事情：

在表fvItem中，有个位置存放了文件名的信息：