SOLIDWORKS PDM SQL Tables Commonly Used in Queries

This article is an introduction to some of the SQL tables more commonly used in queries. Many of these tables fall into two categories. The first identifies a list and gives them ID’s. The second lists the use of those attributes by file. A good example of this is the Transitions table identifies each of the transitions in the workflows, and the TransitionHistory Table lists all the transitions that any file has gone through. In this case, the Transitions table is used to give meaning to the TransitionNr listed in the Transitionhistory table. 

For more information on the use of these tables see: 

• Querying SOLIDWORKS PDM Database - SQL Table Diagrams
• SOLIDWORKS PDM Database: Query Planning

Attribute 

This table lists the Block name, and attribute for all the SOLIDWORKS PDM Variables. 

Documents 

This table is the main table used to identify each file using the Document ID, and File name. 

DocumentsInProjects 

This table links the Documents and the Projects tables. Allowing you to link the file name to the file location. 

Groups 

This table Identifies the user groups by ID 

GroupMembers 

This table links the Groups table and the Users tables. 

Projects 

This table Lists the folder and the file location for each file. 

Revisions 

This table lists the revisions for each file. 

Status 

This table identifies the Workflow States by ID. 

Transitions 

This table identifies the Workflow Transitions by ID.

TransitionHistory 

This table lists each State transition any file has gone through. Other useful information here could be the user who initiated the state and the revision.

Users 

This table Is used to link the UserID to the Username. Also, you can use this table to correct misspelled usernames not governed by the active directory. 

Variable 

This table identifies the Variables by ID.

VariableValue 

This table lists the values for Each variable for each file, revision, and configuration 

Workflows 

This table identifies the Workflows by ID. 

Xrefs 

This table lists files that are referenced by a file. 

Tables

Attribute
AttributeID
VariableID	Links with variables table
AttributeName
BlockName
AttributeType

 

Documents
DocumentID	This id is used to identify each document
Filename	Name of file
LockProject
UserID	Links with Users Table
LockDomain
LockPath
Busy
Flushed
DefValStored

RevGenCounter
LatestRevisionNo
CurrentStatusID	Links with Status table
WorkingVersionModified
ExtensionID
LockDate
UserDocRefsModified
Deleted	Boolean value 1= has been deleted
Shared
LockViewID

Link
DocTypeID
ObjectTypeID
Flags

 

DocumentsInProjects
ProjectID	Links with Projects table
DocumentID	Links with Documents table
Deleted

 

Groups
GroupID
Groupname
Description
AutoAdd

 

GroupMembers
GroupID	Links with groups table
UserID	Links with users table
ProjectID
IsMember

 

Projects
ProjectID	ID used to identify the folder
Name	Name of folder file is located in
StatusID	Links with Status Table

StartTime
Deadline
TimeEstimate
Busy
MoveCount
Path	Path to file
Deleted
FolderType

 

Revisions
DocumentID	Links with Documents Table
RevNr
Date
UserID	Links with Users Table
Comment
FileSize
FileDate
Root
WebRoot

ProjectName
FlushedDate
LockDate
ActiveConfigurationID
VersionUID
FileTimeStamp
IsOverwritten

 

Status
StatusID
IconName
Name	State name
BoxXPos
BoxYPos
BoxWidth
BoxHeight
Enabled
Description

RevNumID
BlockRights
WorkFlowID	Links with Workflows Table
StatusType
RevisionVarID

 

Transitions
TransitionID
Name
Source	Links with StatusID
Destination	Links with StatusID
BoxXPos
BoxYPos
BoxWidth
BoxHeight
Enabled

Description
ConditionSQL
ArrowNodeIndex
WorkflowID	Links with Workflows table
Authentication
SrcStatusName
DestStatusName
ExtWorkflowLinkGUID
Type
HideWhenParSiblingUsed

LatestVersionOverwrite

 

TransitionHistory
DocumentID	Links with Documents Table
TransitionNr
RevNr
Date
UserID	Links with Users Table
Comment
TransitionID	Links with Transitions Table
PostActionVerNo

 

Users
UserID
Username
Enabled
LoggedIn
SessionID
Email
SettingsTableVersion
FullName
Initials

UserData
InitialStatusID

 

Variable
VariableID
VariableName
VariableType
IsDeleted
FlagUnique
FlagMandatory
FlagFreeUpdateAllVersion
FlagFreeUpdateLatestVersion

 

Variable value
VariableID	Links with Variable Table
DocumentID	Links with Documents Table
ProjectID	Links with Projects Table
RevisionNo	Links with Revisions Table
ConfigurationID
ValueText
ValueInt
ValueFloat
ValueDate

ValueCache
IsLongText

 

Workflows
WorkflowID
Name
Description
InitialTransitionID
WorkflowGUID
ExtWorkflowGUID

 

Xrefs
DocumentID	Links with Documents table
RevNr	Links with Revisions table
XRefDocument	Links with Documents table
XRefProjectID	Links with Projects table
XRefRevNr
HasFullPath
RelativePath
RefCount
XRefID

RefCountEdit
RefTimeStamp
XrType

 

Learn More About SOLIDWORKS PDM 

SOLIDWORKS PDM Web2 Guide: Server Setup, Accounts, Application Pool, & Testing

Option File - A Great Solution for Managing Your SNL(s)

Fixing SOLIDWORKS PDM Error Message: The Program and the File Vault Are Of Incompatible Versions

SOLIDWORKS PDM - Complete Guide to Client Installation

SOLIDWORKS PDM - Guide to PDM Standard Backups

VIEW ALL SOLIDWORKS PDM TUTORIALS