Surround SCM 2017.2 - 2020.1 ERD
Diagram
Tables
Additional information
List of tables
Table details
Name
Comment
ARCHIVEFILE
Contains the master list of files in Surround SCM
ATTACHACTION
Contains information about Surround SCM files attached to Helix ALM items
BRANCH
Contains a list of branches in the RDBMS database
BRANCHCREATION
Contains branch creation information
BRANCHFILE
Contains file data for branches
BRANCHFILEVERSION
Contains file version data for branches
BRANCHREPOSITORY
Contains repository data for branches
CHANGELIST
Contains pending and committed changelist information
CHANGELISTCODEREVIEW
Contains changelist code review information
CHANGELISTCUSTOMFIELDVALUE
Contains custom field values associated with changelists
CHANGELISTDEFECTACTION
Contains Helix ALM item actions associated with changelists
CHANGELISTEVENT
Contains events associated with a changelist
CHECKOUTFILE
Contains file check out information
CMISPWC
Contains CMIS private working copy file information
CODEREVIEW
Contains information about code reviews
CODEREVIEWCOMMENT
Contains code review comment information
CODEREVIEWEVENT
Contains code review event information.
CODEREVIEWFILE
Contains code review file information.
CODEREVIEWFILEUSER
Contains code review file user information
CODEREVIEWFILEVERSION
Contains code review file version information
CODEREVIEWUSER
Contains code review user information
DEFECTACTION
Contains Helix ALM issue event information, such as fix
DEFECTACTIONASSIGNEDUSER
Contains Helix ALM user assignment information
DEFECTEVENTCUSTOMVALUE
Contains Helix ALM issue event custom values
EVENT
Contains a list of events performed in Surround SCM
EVENTCUSTOMFIELDVALUE
Contains historical information about file custom field value changes
EXTERNALISSUEATTACHMENT
Contains information about external issue attachments
EXTERNALISSUECUSTOMFIELD
Contains custom field information for external issue attachments
EXTERNALISSUEFILEATTACHMENT
Contains file information for external issue attachments
FILECUSTOMFIELDVALUE
Contains all file custom field values
FILEREVISION
Contains the master list of file revisions
LABEL
Contains all label information
LABELEVENT
Contains all events related to labels
LABELFILE
Contains information about labels and files they are applied to
MAINLINE
Contains a list of mainline branches stored in the RDBMS database
MAINLINEOPTN
Contains a list of mainline options
MERGEEVENT
Contains information about file merges
OLDLABEL
Contains legacy labels found when upgrading a non-RDBMS mainline branch
OLDLABELFILE
Contains legacy labeled file revisions
OWNERLCK
Contains information about the database version and Surround SCM Server it is associated with
RDBMSOPTNS
Contains RDBMS vendor-specific options used for database connections
REPOSITORY
Contains the master list of repositories
REPOSITORYSECURITY
Contains information about security group permissions set for the repository and branch
REVISIONDELTA
Contains a list of file delta data
REVISIONTHUMB
Contains thumbnails generated for images
SCMAUDITLOG
Audit log of electronically signed events
SCMCUSTOMFLDS
Contains custom field rules used in filters, reports, and triggers
SCMGROUPS
Contains security group information
SCMSTATES
Contains workflow state information
SCMUSERS
Contains Surround SCM user information
SCMWORKFLOWS
Contains workflow information
SCMWRKFLWDFLT
Contains default workflow information
SCMWRKFLWSTATES
Contains workflow states
SCMWRKFLWTRANS
Contains workflow transitions
SHELF
Contains a list of shelves for the mainlines in the RDBMS database
SHELFFILE
Contains file data in shelves
SHELFSHARING
Contains information about users shelves are shared with
SYNCTRACK
Contains information used to track the last time changes were made to tables to sync mainlines stored in other RDBMS databases
TTPRODBCONF
Contains Helix ALM connection information