Surround SCM 2017.2 - 2020.1 ERD
List of tables
Table details

NameComment
ARCHIVEFILEContains the master list of files in Surround SCM
ATTACHACTIONContains information about Surround SCM files attached to Helix ALM items
BRANCHContains a list of branches in the RDBMS database
BRANCHCREATIONContains branch creation information
BRANCHFILEContains file data for branches
BRANCHFILEVERSIONContains file version data for branches
BRANCHREPOSITORYContains repository data for branches
CHANGELISTContains pending and committed changelist information
CHANGELISTCODEREVIEWContains changelist code review information
CHANGELISTCUSTOMFIELDVALUEContains custom field values associated with changelists
CHANGELISTDEFECTACTIONContains Helix ALM item actions associated with changelists
CHANGELISTEVENTContains events associated with a changelist
CHECKOUTFILEContains file check out information
CMISPWCContains CMIS private working copy file information
CODEREVIEWContains information about code reviews
CODEREVIEWCOMMENTContains code review comment information
CODEREVIEWEVENTContains code review event information.
CODEREVIEWFILEContains code review file information.
CODEREVIEWFILEUSERContains code review file user information
CODEREVIEWFILEVERSIONContains code review file version information
CODEREVIEWUSERContains code review user information
DEFECTACTIONContains Helix ALM issue event information, such as fix
DEFECTACTIONASSIGNEDUSERContains Helix ALM user assignment information
DEFECTEVENTCUSTOMVALUEContains Helix ALM issue event custom values
EVENTContains a list of events performed in Surround SCM
EVENTCUSTOMFIELDVALUEContains historical information about file custom field value changes
EXTERNALISSUEATTACHMENTContains information about external issue attachments
EXTERNALISSUECUSTOMFIELDContains custom field information for external issue attachments
EXTERNALISSUEFILEATTACHMENTContains file information for external issue attachments
FILECUSTOMFIELDVALUEContains all file custom field values
FILEREVISIONContains the master list of file revisions
LABELContains all label information
LABELEVENTContains all events related to labels
LABELFILEContains information about labels and files they are applied to
MAINLINEContains a list of mainline branches stored in the RDBMS database
MAINLINEOPTNContains a list of mainline options
MERGEEVENTContains information about file merges
OLDLABELContains legacy labels found when upgrading a non-RDBMS mainline branch
OLDLABELFILEContains legacy labeled file revisions
OWNERLCKContains information about the database version and Surround SCM Server it is associated with
RDBMSOPTNSContains RDBMS vendor-specific options used for database connections
REPOSITORYContains the master list of repositories
REPOSITORYSECURITYContains information about security group permissions set for the repository and branch
REVISIONDELTAContains a list of file delta data
REVISIONTHUMBContains thumbnails generated for images
SCMAUDITLOGAudit log of electronically signed events
SCMCUSTOMFLDSContains custom field rules used in filters, reports, and triggers
SCMGROUPSContains security group information
SCMSTATESContains workflow state information
SCMUSERSContains Surround SCM user information
SCMWORKFLOWSContains workflow information
SCMWRKFLWDFLTContains default workflow information
SCMWRKFLWSTATESContains workflow states
SCMWRKFLWTRANSContains workflow transitions
SHELFContains a list of shelves for the mainlines in the RDBMS database
SHELFFILEContains file data in shelves
SHELFSHARINGContains information about users shelves are shared with
SYNCTRACKContains information used to track the last time changes were made to tables to sync mainlines stored in other RDBMS databases
TTPRODBCONFContains Helix ALM connection information