Table: ARCHIVEFILE
Comment | Contains the master list of files in Surround SCM |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
FileID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
OrigRepoID | No | NUMERIC(10) | Yes | Foreign key to the REPOSITORY table. Original repository where the archive file was added. |
OrigFileName | No | VARCHAR(255) | Yes | Original archive filename |
FileType | No | NUMERIC(2) | Yes | Archive file type - 0: ASCII, 1: Binary, 2: MacBinary, 3: UTF8, 4: UTF16, 5: Symlink |
Destroyed | No | NUMERIC(1) | No | Indicates if the archive file was destroyed. Destroyed files cannot be restored. |
Table: ATTACHACTION
Comment | Contains information about Surround SCM files attached to Helix ALM items |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
AttachActionID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ChangelistID | No | NUMERIC(10) | No | Foreign key to the CHANGELIST table. Changelist the attach action is associated with. |
ChangelistEventID | No | NUMERIC(10) | No | Foreign key to the CHANGELIST table. Changelist event. |
SCMFile | No | VARCHAR(4096) | No | Surround SCM path for the attached file |
FileVersion | No | NUMERIC(10) | No | File version |
DefectRecordID | No | NUMERIC(10) | No | Record ID of the attached item |
DefectNumber | No | NUMERIC(10) | No | Item number the file is attached to |
TTDbConfigID | No | NUMERIC(10) | No | Foreign key to the TTPRODBCONF table. Helix ALM connection to use. |
UserID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. User who attached the file. |
DTimestamp | No | TIMESTAMP | Yes | Date/time the file was attached |
Comments | No | VARCHAR(4096) | No | Attach action comments |
Destroyed | No | NUMERIC(1) | No | Indicates if the attach action was destroyed. Destroyed actions cannot be restored. |
TTItemType | No | NUMERIC(10) | No | Helix ALM item type attached to |
Table: BRANCH
Comment | Contains a list of branches in the RDBMS database |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
Deleted | No | NUMERIC(1) | No | Indicates if the branch was deleted. Deleted branches can be restored if they were not destroyed. |
BranchName | No | VARCHAR(255) | No | Branch name. Unique for mainline, baseline, and snapshot branches. Workspace branches can have the same name only if the OwnerID value is different. |
BranchType | No | NUMERIC(2) | No | Branch type - 0: Workspace, 1: Baseline, 2: Snapshot |
OwnerID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. Branch owner. Null for baseline and snapshot branches. |
ParentBranchID | No | NUMERIC(10) | No | Foreign key to the BRANCH table. Parent branch. Null indicates the branch is the mainline. |
BaseRepositoryID | No | NUMERIC(10) | No | Foreign key to the REPOSITORY table. Base repository for the record. |
DateCreated | No | TIMESTAMP | No | Date/time the branch was created |
DateModified | No | TIMESTAMP | No | Date/time the branch was last modified |
BranchFlag | No | NUMERIC(10) | No | Branch flag description (e.g., Frozen, Destroyed, Inactive, Hidden, Cache on Demand, Case Sensitive Filenames) |
SecuritySettings | No | NUMERIC(1) | No | Security type - 0: Security applies to all branches 1: Branch has its own security, 2: Branch inherits the parent branch security |
BasePath | No | VARCHAR(1024) | No | Base repository path for the branch |
DateAccessed | No | TIMESTAMP | No | Date/time the branch was last accessed |
Destroyed | No | NUMERIC(1) | No | Indicates if the branch was destroyed. Destroyed branches cannot be restored. |
Comments | No | VARCHAR(4096) | No | Branch description |
Table: BRANCHCREATION
Comment | Contains branch creation information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchID | Yes | NUMERIC(10) | Yes | Foreign key to the BRANCH table. Branch ID. |
CreatorID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. User who created the branch. |
CreationType | No | NUMERIC(2) | No | Branch creation type. Indicates how files are retrieved, the initial custom field values for files, and if removed files are included - 1: Latest version with default custom fields values set, 2: Latest version with custom field values from parent branch, 3: Timestamp with default custom field values set and removed files included, 4: Timestamp with default custom field values set and removed files excluded, 5: Timestamp with custom field values set from parent branch and removed files included, 6: Timestamp with custom field values set from parent branch and removed files excluded, 7: State with default custom field values set and removed files included, 8: State with default custom field values set and removed files excluded, 9: State with custom field values set from parent branch and removed files excluded, 10: State with custom field values set from parent branch and removed files excluded, 11: Label with default custom field values set and removed files included, 12: Label with default custom field values set and removed files excluded, 13: Label with custom field values set from parent branch and removed files included, 14: Label with custom field values set from parent branch and removed files excluded |
idState | No | NUMERIC(10) | No | Foreign key to the SCMSTATES table. Workflow state used when creating the branch. Null if the branch was not created by state. |
LabelID | No | NUMERIC(10) | No | Foreign key to the LABEL table. Label used when creating the branch. Null if the branch was not created by label. |
DateCreatedBy | No | TIMESTAMP | No | Date/time the branch was created |
Table: BRANCHFILE
Comment | Contains file data for branches |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchFileID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
BranchRepoID | No | NUMERIC(10) | No | Foreign key to the BRANCHREPOSITORY table. Repository the file is in. |
FileID | No | NUMERIC(10) | No | Foreign key to the ARCHIVEFILE table. Base file of the branched file. |
Deleted | No | NUMERIC(1) | No | Indicates if the file was deleted |
StatusFlag | No | NUMERIC(10) | No | Branch file status - 1: Branched, 2: Shared, 4: Shared base |
FileName | No | VARCHAR(255) | No | Branch filename |
CurrentVersion | No | NUMERIC(10) | No | Current file version number |
ExpandKeywordOption | No | CHARACTER(1) | No | Keyword expansion - 0: User server default, 1: Expansion off, 2: Expansion on |
TimeLastRenamed | No | TIMESTAMP | No | Date/time branch file was last renamed |
ShareBaseBranchFileID | No | NUMERIC(10) | No | Record ID in the BRANCHFILE table. Base share file if the file is shared. Not an enforced foreign key relationship. |
InheritedFileRevisionID | No | NUMERIC(10) | No | File revision inherited from parent branch |
InheritedStateID | No | NUMERIC(10) | No | State ID inherited from parent branch |
InheritedBranchFileID | No | NUMERIC(10) | No | BranchFileID inherited from parent branch |
InheritedVersion | No | NUMERIC(10) | No | File version inherited from parent branch |
Destroyed | No | NUMERIC(1) | No | Indicates if the branched file was destroyed. Destroyed files cannot be restored. |
Table: BRANCHFILEVERSION
Comment | Contains file version data for branches |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchFileID | Yes | NUMERIC(10) | Yes | Foreign key to the BRANCHFILE table. Branch file the version applies to. |
LocalVersion | Yes | NUMERIC(10) | Yes | File version |
FileRevisionID | No | NUMERIC(10) | No | Foreign key to the FILEREVISION table. Internal Surround SCM version tree of the file. |
VersionTimestamp | No | TIMESTAMP | No | Date/time the file version was added |
VersionFlag | No | NUMERIC(5) | No | File version flag - 0: Inherited, 1: Alternate version is promoted/no merge, 2: Alternate version is promoted with merge, 3: Alternate version is rebased/no merge, 4: Alternate version is rebased with merge, 5: Promoted, 6: Rebased, 7: Version was rolled back, 8: Analyzer marked unfixable |
StateID | No | NUMERIC(10) | No | Foreign key to the SCMSTATES table. Workflow state of the file version. |
AltFileRevisionID | No | NUMERIC(10) | No | Alternate file revision ID. References the FILEREVISION table. Used to track versions promoted and rebased to other branches. |
InheritedBranchID | No | NUMERIC(10) | No | References a branch record in the BRANCH table if VersionFlag field indicates the version was inherited from another branch |
PromotedFromBranchID | No | NUMERIC(10) | No | References a branch record in the BRANCH table. Branch the file version was promoted from. |
Destroyed | No | NUMERIC(1) | No | Indicates if the file version was destroyed. Destroyed versions cannot be restored. |
Table: BRANCHREPOSITORY
Comment | Contains repository data for branches |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchRepoID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
RepositoryID | No | NUMERIC(10) | No | Foreign key to the REPOSITORY table. Base repository. |
Deleted | No | NUMERIC(1) | No | Indicates if the branched repository was deleted |
Excluded | No | NUMERIC(1) | No | Indicates if the branched repository was excluded by the branch template |
RepositoryName | No | TEXT | No | Repository name |
BranchID | No | NUMERIC(10) | No | Foreign key to the BRANCH table. Branch where the repository is located. |
TimeLastRenamed | No | TIMESTAMP | No | Date/time the repository was last renamed |
WorkflowSettings | No | CHARACTER(1) | No | Repository workflow settings - 0: No workflow, 1: Inherit parent workflow, 2: Use specific workflow |
UseWorkflowID | No | NUMERIC(10) | No | Foreign key to the SCMWORKFLOWS table. Workflow used for the repository. |
ParentBranchRepoID | No | NUMERIC(10) | No | Foreign to the BRANCHREPOSITORY table. Parent repository. |
InheritTTIntegrSettings | No | NUMERIC(1) | No | Repository Helix ALM settings - 0: Use specific Helix ALM settings, 1: Inherit parent settings |
TTIntegrOverrideDefault | No | NUMERIC(1) | No | Indicates if the Helix ALM settings can be overridden for the repository |
TTIntegrDbConfigID | No | NUMERIC(10) | No | Foreign key to the TTPRODBCONF table. Helix ALM connection to use. |
TTIntegrDefectOption | No | NUMERIC(1) | No | Repository 'Attach to Helix ALM issue' setting - 0: No change, 1: Enabled, 2: Disabled, 3: Required |
Comments | No | VARCHAR(4096) | No | Repository description |
Destroyed | No | NUMERIC(1) | No | Indicates if the repository was destroyed. Destroyed repositories cannot be restored. |
TTIntegrTestcaseOption | No | NUMERIC(1) | No | Repository 'Attach to Helix ALM test case' setting - 0: No change, 1: Enabled, 2: Disabled, 3: Required |
TTIntegrRequirementOption | No | NUMERIC(1) | No | Repository 'Attach to Helix ALM requirement' setting - 0: No change, 1: Enabled, 2: Disabled, 3: Required |
InheritCodeReviewSettings | No | NUMERIC(1) | No | Repository code review settings - 0: Use specific code review settings, 1: Inherit parent settings |
CodeReviewCheckinOption | No | NUMERIC(1) | No | Repository 'Code review on check in' setting - 0: No change, 1: Enabled, 2: Disabled, 3: Required |
CodeReviewAddOption | No | NUMERIC(1) | No | Repository 'Code review on add files' setting - 0: No change, 1: Enabled, 2: Disabled, 3: Required |
Table: CHANGELIST
Comment | Contains pending and committed changelist information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ChangelistID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ChangelistName | No | VARCHAR(255) | No | Changelist name |
BranchID | No | NUMERIC(10) | No | Foreign key to BRANCH table. Branch where the changelist is located. |
UserId | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table User who created the changelist. |
ComputerName | No | VARCHAR(64) | No | Computer name the changelist was created on. Changelists can only be committed from the computer they were created on. |
IsPending | No | NUMERIC(1) | No | Indicates if the changelist is pending |
DateTime | No | TIMESTAMP | No | Date/time the changelist was created |
Destroyed | No | NUMERIC(1) | No | Indicates if the changelist was destroyed. Destroyed changelists cannot be restored. |
Table: CHANGELISTCODEREVIEW
Comment | Contains changelist code review information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ReviewID | Yes | NUMERIC(10) | Yes | Parent code review ID |
ChangelistID | Yes | NUMERIC(10) | Yes | Foreign key to the CHANGELIST table. Changelist for the code review. |
ChangelistEventID | Yes | NUMERIC(10) | Yes | Foreign key to the CHANGELISTEVENT table. Changelist event for the code review. |
Table: CHANGELISTCUSTOMFIELDVALUE
Comment | Contains custom field values associated with changelists |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ChangelistEventID | Yes | NUMERIC(10) | Yes | Foreign key to the CHANGELISTEVENT table. Changelist event for the custom field. |
CustomFieldID | Yes | NUMERIC(10) | Yes | Foreign key to the SCMCUSTOMFLDS table. Identifier for custom fields that are modified. |
ChangelistID | No | NUMERIC(10) | Yes | Parent changelist ID |
TextValue | No | VARCHAR(255) | No | Text custom field value |
IntegerValue | No | NUMERIC(10) | No | Integer custom field value |
DoubleValue | No | DOUBLE PRECISION | No | Double custom field value |
DateTimeValue | No | TIMESTAMP | No | Date/time custom field value |
CheckBoxValue | No | NUMERIC(1) | No | Check box custom field value |
Destroyed | No | NUMERIC(1) | No | Indicates if the custom field value was destroyed. Destroyed values cannot be restored. |
Table: CHANGELISTDEFECTACTION
Comment | Contains Helix ALM item actions associated with changelists |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ChangelistID | Yes | NUMERIC(10) | Yes | Foreign key to the CHANGELIST table. Changelist the attach action belongs to. |
DefectActionID | Yes | NUMERIC(10) | Yes | Foreign key to the DEFECTACTION table. Changelist the attach action belongs to. |
Table: CHANGELISTEVENT
Comment | Contains events associated with a changelist |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ChangelistEventID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ChangelistID | No | NUMERIC(10) | No | Changelist the event is associated with |
EventType | No | NUMERIC(3) | No | Event type - 1: Add, 2: Remove, 3: Rename, 5: Check in, 8: Create Repository, 13: Move |
MachineName | No | VARCHAR(255) | No | Computer that triggered the changelist event |
FileVersion | No | NUMERIC(10) | No | File version the changelist was committed on |
BranchRepoID | No | NUMERIC(10) | No | Foreign key to the BRANCHREPOSITORY table. Repository the event was performed on. |
BranchFileID | No | NUMERIC(10) | No | Foreign key to the BRANCHFILE table. File the event was performed on. |
OrigBranchName | No | VARCHAR(255) | No | Original branch name |
OrigRepoName | No | VARCHAR(1024) | No | Original repository name |
OrigFileName | No | VARCHAR(255) | No | Original filename |
KeepCheckoutOrBitMask | No | NUMERIC(1) | No | For an add event, indicates if the file should be checked out. For check in, indicates if the file should remain checked out. For rename, indicates if the file is shared or if the rename is a repository rename. For remove, indicates destroy, force delete of empty subrepositories, and repository destroy. For move, indicates if the move is a repository. |
LocalFileOrNewName | No | VARCHAR(1024) | No | Indicates local file path for adding new files. If an item was renamed, indicates the new name. |
ExclusiveLock | No | NUMERIC(1) | No | Indicates if the check out after an event is exclusive |
DoNotReturnCopy | No | NUMERIC(1) | No | Indicates if the server copy should be retrieved |
EOLFormat | No | CHARACTER(1) | No | End of line format used with adds and check ins |
FileType | No | NUMERIC(2) | No | File type. Used for adds. |
FileModifiedTime | No | TIMESTAMP | No | Date/time the file was last modified |
UndeleteAndCheckinIfDeleted | No | NUMERIC(1) | No | Indicates if a deleted file should be undeleted and have a new version checked in when performing an add |
MakeFileWritable | No | NUMERIC(1) | No | Indicates if the get after the event makes the file writable |
LabelID | No | NUMERIC(10) | No | Foreign key to the LABEL table. Label used in the changelist event. |
AllowLabelOverride | No | NUMERIC(1) | No | Indicates if the current file version in a label is replaced |
FileStateID | No | NUMERIC(10) | No | Foreign key to SCMSTATES table. Workflow state used in the changelist event. |
ForceCheckinWOMerge | No | NUMERIC(1) | No | Indicates if the check in is forced if no merge is required |
UpdateIfNoChange | No | NUMERIC(1) | No | Indicates if an update occurs on check in if there are no changes |
RemoveLocalFile | No | NUMERIC(1) | No | Indicates if the local file is removed after the event |
MergedVersion | No | NUMERIC(10) | No | Merged file version number. Used with forced check in. |
ModifiedVersion | No | NUMERIC(10) | No | Modified file version number. Used with check in without check out. |
Comments | No | VARCHAR(4096) | No | Changelist event comments |
RollbackEventID | No | NUMERIC(10) | No | ID for the event that rolled back the changelist action |
Destroyed | No | NUMERIC(1) | No | Indicates if the changelist event was destroyed. Destroyed events cannot be restored. |
Table: CHECKOUTFILE
Comment | Contains file check out information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchFileID | Yes | NUMERIC(10) | Yes | Foreign key to the BRANCHFILE table. Checked out file. |
UserID | Yes | NUMERIC(10) | Yes | Foreign key to the SCMUSERS table. User who checked out the file. |
FileVersion | No | NUMERIC(10) | No | Checked out file version |
CheckoutTime | No | TIMESTAMP | No | Date/time the file was checked out |
CheckoutComputer | No | VARCHAR(64) | No | Computer the file was checked out to |
DestinationInfo | No | VARCHAR(255) | No | Location the file was checked out to |
Comments | No | VARCHAR(4096) | No | Check out file comments |
CheckoutFlag | No | CHARACTER(1) | No | Check out type (e.g., promote or rebase, rollback promote or rebase, copy file, duplicate changes, or CMIS) and if the check out was exclusive |
RebasePromoteBranchID | No | NUMERIC(10) | No | Foreign key to the BRANCH table. Branch the check out event was rebased or promoted from. |
RebasePromoteBranchVer | No | NUMERIC(10) | No | Rebase or promote file version |
Destroyed | No | NUMERIC(1) | No | Indicates if the checked out file was destroyed. Destroyed files cannot be restored. |
Table: CMISPWC
Comment | Contains CMIS private working copy file information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchFileID | Yes | NUMERIC(10) | Yes | Foreign key to the BRANCHFILE table. File the CMIS private working copy belongs to. |
UserID | Yes | NUMERIC(10) | Yes | Foreign key to the SCMUSERS table. User the CMIS private working copy file belongs to. |
FileBranchedFlag | No | NUMERIC(1) | No | Indicates if the file is branched |
FileRevisionID | No | NUMERIC(10) | No | Foreign key to the FILEREVISION table. File revision for the CMIS private working copy file. |
Table: CODEREVIEW
Comment | Contains information about code reviews |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ReviewID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
Name | No | VARCHAR(255) | No | Code review name |
Notes | No | VARCHAR(1024) | No | Code review notes |
Status | No | NUMERIC(10) | No | Code review status |
DueDate | No | TIMESTAMP | No | Code review due date |
LastNotificationDate | No | TIMESTAMP | No | Last time a notification was sent about an overdue code review |
HasFiles | No | NUMERIC(1) | No | Indicates if code review has files |
Iteration | No | NUMERIC(10) | No | Current review iteration |
Destroyed | No | NUMERIC(1) | No | Indicates if the code review was destroyed. Destroyed reviews cannot be restored. |
Table: CODEREVIEWCOMMENT
Comment | Contains code review comment information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
CommentID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ReviewFileID | No | NUMERIC(10) | No | Parent code review file ID |
UserID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. User who entered the code review comment. |
CommentDate | No | TIMESTAMP | No | Code review comment date |
Comments | No | VARCHAR(4096) | No | Code review comment |
Addressed | No | NUMERIC(1) | No | Indicates if code review comment is addressed |
FileRevisionID | No | NUMERIC(10) | No | Foreign key to the FILEREVISION table |
BranchFileVersion | No | NUMERIC(10) | No | Branch file version the code review comment was added to |
StartLine | No | NUMERIC(10) | No | Selected code review comment text start line |
StartColumn | No | NUMERIC(10) | No | Selected code review comment text start column |
EndLine | No | NUMERIC(10) | No | Selected code review comment text end line |
EndColumn | No | NUMERIC(10) | No | Selected review comment text end column |
AddressedUserID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. User who addressed the code review comment. |
Destroyed | No | NUMERIC(1) | No | Indicates if the code review comment was destroyed. Destroyed comments cannot be restored. |
Table: CODEREVIEWEVENT
Comment | Contains code review event information. |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
EventID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ReviewID | No | NUMERIC(10) | No | Parent code review ID |
EventType | No | NUMERIC(10) | No | Event type - 0: Create code review, 1: Modify code review, 2: Add code review file, 3: Modify code review file, 4: Remove code review file, 5: Add code review comment, 6: Modify code review comment, 7: Start code review, 8: Code review file complete, 9: Code review file overdue, 10: Code review complete approved, 11: Code review complete needs attention |
EventDate | No | TIMESTAMP | No | Code review event date |
UserID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. User ID who performed the code review event. |
UserName | No | TEXT | No | User who performed the event |
Notes | No | VARCHAR(1024) | No | Event notes |
DueDate | No | TIMESTAMP | No | Code review due date |
ReviewFileID | No | NUMERIC(10) | No | Review file ID associated with the event |
Iteration | No | NUMERIC(10) | No | Current review iteration |
Destroyed | No | NUMERIC(1) | No | Indicates if the code review event was destroyed. Destroyed events cannot be restored. |
Table: CODEREVIEWFILE
Comment | Contains code review file information. |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ReviewFileID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ReviewID | No | NUMERIC(10) | No | Parent code review ID |
BranchFileID | No | NUMERIC(10) | No | Foreign key to the BRANCHFILE table. File the code review is for. |
Status | No | NUMERIC(10) | No | Status - 1: Work in progress, 2: Awaiting review, 3: Needs attention, 4: Approved |
Destroyed | No | NUMERIC(1) | No | Indicates if the code review file was destroyed. Destroyed files cannot be restored. |
Table: CODEREVIEWFILEUSER
Comment | Contains code review file user information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ReviewFileID | Yes | NUMERIC(10) | Yes | Parent code review file ID |
UserID | Yes | NUMERIC(10) | Yes | Foreign key to the SCMUSERS table |
LastReviewedVersion | No | NUMERIC(10) | No | Latest file version the user reviewed |
HasReviewed | No | NUMERIC(1) | No | Indicates if the user reviewed the file |
LastCompletedVersion | No | NUMERIC(10) | No | Latest file version the user marked completed |
Destroyed | No | NUMERIC(1) | No | Indicates if the code review file user was destroyed. Destroyed users cannot be restored. |
Table: CODEREVIEWFILEVERSION
Comment | Contains code review file version information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ReviewFileID | Yes | NUMERIC(10) | Yes | Parent code review file ID |
Version | Yes | NUMERIC(10) | Yes | File version in the code review |
Destroyed | No | NUMERIC(1) | No | Indicates if the code review file version was destroyed. Destroyed versions cannot be restored. |
Table: CODEREVIEWUSER
Comment | Contains code review user information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ReviewID | Yes | NUMERIC(10) | Yes | Parent code review ID |
UserID | Yes | NUMERIC(10) | Yes | Foreign key to the SCMUSERS table |
RoleID | No | NUMERIC(10) | No | Role ID - 1: Author, 2: Reviewer |
Destroyed | No | NUMERIC(1) | No | Indicates if the code review user was destroyed. Destroyed users cannot be restored. |
Table: DEFECTACTION
Comment | Contains Helix ALM issue event information, such as fix |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
DefectActionID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
DefectRecordID | No | NUMERIC(10) | No | Attached item record ID |
DefectNumber | No | NUMERIC(10) | No | Attached item number |
TTDbConfigID | No | NUMERIC(10) | No | Foreign key to the TTPRODBCONF table. Helix ALM connection to use. |
TTEventRecordID | No | NUMERIC(10) | No | Helix ALM event record ID |
ParentMultiUserEventID | No | NUMERIC(10) | No | Record ID if the event was generated in response to a multiuser event |
EventDefinitionID | No | NUMERIC(10) | No | Helix ALM event definition ID |
EnteredEventDateTime | No | TIMESTAMP | No | Date/time the event occurred |
EventNote | No | VARCHAR(4096) | No | Helix ALM event note |
EventAddOrder | No | NUMERIC(2) | No | Order the events were added |
EventTimeSpent | No | DOUBLE PRECISION | No | Time spent on the event |
EventResultingStateID | No | NUMERIC(10) | No | Resulting Helix ALM state |
EventReferenceCounter | No | NUMERIC(10) | No | Event reference counter |
EventReleaseVersion | No | VARCHAR(32) | No | Helix ALM release notes version |
EventGeneratedBy | No | NUMERIC(5) | No | Event generator type (e.g., user or auto-assignment) |
EventCreatorID | No | NUMERIC(10) | No | ID of the auto-assignment or escalation rule that generated the event |
EventWorkflowOverride | No | NUMERIC(1) | No | Indicates if the event was entered from a workflow override |
TTOverideWFUserID | No | NUMERIC(10) | No | User who performed the workflow override |
EventDefAssignEffect | No | NUMERIC(5) | No | Event definition settings when event was added |
Destroyed | No | NUMERIC(1) | No | Indicates if the issue event was destroyed. Destroyed events cannot be restored. |
TTUserID | No | NUMERIC(10) | No | Helix ALM user who performed the event |
Table: DEFECTACTIONASSIGNEDUSER
Comment | Contains Helix ALM user assignment information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
DefectActionID | Yes | NUMERIC(10) | Yes | Foreign key to the DEFECTACTION table. Helix ALM action associated with the assigned user. |
TTUserID | Yes | NUMERIC(10) | Yes | Helix ALM user ID |
Table: DEFECTEVENTCUSTOMVALUE
Comment | Contains Helix ALM issue event custom values |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
DefectActionID | Yes | NUMERIC(10) | Yes | Foreign key to the DEFECTACTION table. Helix ALM event associated with the custom field value. |
TTCustomFieldID | Yes | NUMERIC(10) | Yes | Helix ALM custom field |
TTCustomValueRecordID | No | NUMERIC(10) | No | Helix ALM custom field value |
CValue | No | VARCHAR(255) | No | Custom field value to set |
Destroyed | No | NUMERIC(1) | No | Indicates if the event custom value was destroyed. Destroyed values cannot be restored. |
Table: EVENT
Comment | Contains a list of events performed in Surround SCM |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
EventID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
BranchID | No | NUMERIC(10) | No | Foreign key to the BRANCH table. Branch where the event was performed. |
BranchRepoID | No | NUMERIC(10) | No | Foreign key to the BRANCHREPOSITORY table. Branch repository where the event was performed. |
BranchFileID | No | NUMERIC(10) | No | Foreign key to the BRANCHFILE table. File the event was performed on. |
FileVersion | No | NUMERIC(10) | No | File version the event was performed on. |
EventType | No | NUMERIC(5) | No | Event type - 1: Added to repository, 2: Added to branch, 3: Added from branch, 4: Checked in, 5: Rebased, 6: Rebased with merge, 7: Promoted (deprecated), 8: Labeled, 9: Attached to issue, 10: Deleted, 11: Undeleted, 12: Promoted to branch, 13: Promoted from branch with merge, 14: Promoted from branch without merge, 15: File share created, 16: File share broken, 17: Branch renamed, 18: Branch removed, 19: Branch restored, 20: File renamed, 21: Repo renamed, 22: Branch destroyed, 23: File destroyed, 24: Repo destroyed, 25: Branch type change, 26: Branch owner change, 27: Rollback rebase, 28: Rollback promote, 29: Rollback file, 30: Custom field changed, 31: State changed, 32: Unlabel, 33: Attached to test case, 34: Attached to requirement, 35: Duplicate changes, 36: File moved, 37: Repository moved, 38: Attached to external, 39: Rollback Changes, 40: Repository exported to mainline, 41: File share removed |
EventDate | No | TIMESTAMP | No | Event timestamp |
UserID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. User who performed the event. |
Username | No | TEXT | No | User who performed the event |
ChangelistID | No | NUMERIC(10) | No | Foreign key to the CHANGELIST table if the event was part of a changelist |
AltName1 | No | TEXT | No | Text field that contains additional event data based on event type |
AltName2 | No | TEXT | No | Text field that contains additional event data based on event type |
AltInteger1 | No | NUMERIC(10) | No | Numeric field that contains additional event data based on event type |
AltInteger2 | No | NUMERIC(10) | No | Numeric field that contains additional event data based on event type |
AltInteger3 | No | NUMERIC(10) | No | Numeric field that contains additional event data based on event type |
Comments | No | VARCHAR(4096) | No | Event comments |
AltType | No | NUMERIC(5) | No | EventType for the rolled back changelist action |
Destroyed | No | NUMERIC(1) | No | Indicates if the event was destroyed. Destroyed events cannot be restored. |
Table: EVENTCUSTOMFIELDVALUE
Comment | Contains historical information about file custom field value changes |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
EventID | Yes | NUMERIC(10) | Yes | Foreign key to EVENT table. Event the custom field value was set for. |
CustomFieldID | Yes | NUMERIC(10) | Yes | Foreign key to the SCMCUSTOMFLDS table. Custom field set for the event. |
IsPreviousValue | Yes | NUMERIC(1) | Yes | Indicates if the value is the original value before the event or the value set by the event |
TextValue | No | VARCHAR(255) | No | Text custom field value before the event or set by the event |
Integervalue | No | NUMERIC(10) | No | Integer custom field value before the event or set by the event |
DoubleValue | No | DOUBLE PRECISION | No | Float custom field value before the event or set by the event |
DateTimeValue | No | TIMESTAMP | No | Date/time custom field value before the event or set by the event |
CheckBoxValue | No | NUMERIC(1) | No | Check box custom field value before the event or set by the event |
Destroyed | No | NUMERIC(1) | No | Indicates if the custom field value was destroyed. Destroyed custom field values cannot be restored. |
Table: EXTERNALISSUEATTACHMENT
Comment | Contains information about external issue attachments |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ExternalIssueAttachmentID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ChangelistID | No | NUMERIC(10) | No | Changelist the external issue attachment is associated with |
IsChangelistAttached | No | NUMERIC(1) | No | Indicates if a changelist is attached |
PluginUUID | No | VARCHAR(38) | No | Universally unique identifier for the external issue plug-in |
Connection | No | VARCHAR(256) | No | External issue attachment server connection to use |
IssueId | No | VARCHAR(256) | No | External issue the attachment is associated with |
IssueSummary | No | VARCHAR(1024) | No | External issue description |
IsFix | No | NUMERIC(1) | No | Indicates if the file was attached with a fix event |
Destroyed | No | NUMERIC(1) | No | Indicates if the attachment was destroyed. Destroyed attachments cannot be restored. |
Table: EXTERNALISSUECUSTOMFIELD
Comment | Contains custom field information for external issue attachments |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | No | NUMERIC(10) | Yes | Parent mainline branch ID |
ExternalIssueAttachmentID | No | NUMERIC(10) | Yes | Foreign key to the EXTERNALISSUEATTACHMENT table. External attachment associated with the custom field value changes. |
DisplayValue | No | VARCHAR(256) | No | Custom field name |
DisplayID | No | VARCHAR(256) | No | Custom field ID |
DisplayType | No | NUMERIC(5) | No | External issue custom field type - 0: DropDown, 1: CheckBox, 2: TextField, 3: TextBody, 4: Date, 5: DateTime, 6: HTML |
Value | No | VARCHAR(2048) | No | Custom field value if type is TextField, TextBody, Date, DateTime, or HTML |
ValueId | No | VARCHAR(256) | No | Custom field value if type is DropDown |
Checked | No | NUMERIC(1) | No | Custom field value if type is CheckBox |
Destroyed | No | NUMERIC(1) | No | Indicates if the custom field was destroyed. Destroyed fields cannot be restored. |
Table: EXTERNALISSUEFILEATTACHMENT
Comment | Contains file information for external issue attachments |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ExternalIssueAttachmentID | Yes | NUMERIC(10) | Yes | Foreign key to the EXTERNALISSUEATTACHMENT table. External attachment associated with the external issue custom field value change. |
ChangelistEventID | Yes | NUMERIC(10) | Yes | Foreign key to the CHANGELISTEVENT table. Changelist event the external issue custom field value change belongs to. |
Destroyed | No | NUMERIC(1) | No | Indicates if the attachment was destroyed. Destroyed attachments cannot be restored. |
Table: FILECUSTOMFIELDVALUE
Comment | Contains all file custom field values |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchFileID | Yes | NUMERIC(10) | Yes | Foreign key to the BRANCHFILE table. File the custom field value applies to. |
CustomFieldID | Yes | NUMERIC(10) | Yes | Foreign key to the SCMCUSTOMFLDS table. Custom field the value applies to. |
TextValue | No | VARCHAR(255) | No | Text custom field value |
IntegerValue | No | NUMERIC(10) | No | Integer custom field value |
DoubleValue | No | DOUBLE PRECISION | No | Double custom field value |
DateTimeValue | No | TIMESTAMP | No | Date/time custom field value |
CheckBoxValue | No | NUMERIC(1) | No | Check box custom field value (checked or unchecked) |
Destroyed | No | NUMERIC(1) | No | Indicates if the custom field value was destroyed. Destroyed values cannot be restored. |
Table: FILEREVISION
Comment | Contains the master list of file revisions |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
FileRevisionID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
FileID | No | NUMERIC(10) | Yes | Foreign key to ARCHIVEFILE table. Archive file the revision is associated with. |
Revision | No | VARCHAR(256) | No | Revision number string. Used internally to build a revision tree of file changes. |
ParentRevisionID | No | NUMERIC(10) | No | Foreign key to the FILEREVISION table. Parent revision. |
ArchiveDate | No | TIMESTAMP | No | Date/time the file revision was created |
ModifyDate | No | TIMESTAMP | No | Date/time the archive file was modified |
FileSize | No | BIGINT | No | File size |
FileCRC | No | NUMERIC(10) | No | File CRC. Used for binary, MacBinary, and UTF16 files. |
DeltaCount | No | NUMERIC(10) | No | Number of delta chunks |
DeltaChunkSize | No | NUMERIC(10) | No | Delta chunk size |
DeltaSize | No | BIGINT | No | Delta size |
DeltaCRC | No | NUMERIC(10) | No | Delta CRC |
DeltaEOLType | No | NUMERIC(1) | No | Delta end of line type |
TextCRC | No | NUMERIC(10) | No | File text CRC. Used for ASCII, UTF8, and symlink files. |
NextBranchNum | No | NUMERIC(10) | No | Next number to add to the FILEREVISION.REVISION value if the file is branched |
Username | No | TEXT | No | User who created the revision. Used for keyword expansion. |
Destroyed | No | NUMERIC(1) | No | Indicates if the file revision was destroyed. Destroyed file revisions cannot be restored. |
Table: LABEL
Comment | Contains all label information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
LabelID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
BranchID | No | NUMERIC(10) | No | Foreign key to the BRANCH table. Branch the label applies to. |
IsHidden | No | NUMERIC(1) | No | Indicates if the label is hidden |
LabelName | No | VARCHAR(255) | No | Label name |
LabelDescription | No | VARCHAR(1024) | No | Label description |
OwnerID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. Label owner. |
TimeCreated | No | TIMESTAMP | No | Date/time the label was created |
FileCount | No | NUMERIC(10) | No | Number of files the label is applied to |
Destroyed | No | NUMERIC(1) | No | Indicates if the label was destroyed. Destroyed labels cannot be restored. |
Table: LABELEVENT
Comment | Contains all events related to labels |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
LabelEventID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
LabelID | No | NUMERIC(10) | No | Foreign key to the LABEL table. Label the event is associated with. |
EventType | No | NUMERIC(5) | No | Event type - 0: Create label, 1: Label applied to file, 2: Label removed from file, 3: Label renamed, 4: Label hidden, 5: Label unhidden, 6: Update labeled file version |
UserID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. User who labeled the file. |
EventTime | No | TIMESTAMP | No | Date/time the label event occurred |
FileCount | No | NUMERIC(10) | No | Number of files labeled |
Comments | No | VARCHAR(4096) | No | Comments entered when the files were labeled |
Destroyed | No | NUMERIC(1) | No | Indicates if the label event was destroyed. Destroyed events cannot be restored. |
Table: LABELFILE
Comment | Contains information about labels and files they are applied to |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
LabelID | Yes | NUMERIC(10) | Yes | Foreign key to the LABEL table. File label. |
BranchFileID | Yes | NUMERIC(10) | Yes | Foreign key to the BRANCHFILE table. Labeled file. |
FileVersion | No | NUMERIC(10) | No | File versions associated with the label and file |
LabelEventID | No | NUMERIC(10) | No | Foreign key to the LABELEVENT table. Label event. |
Destroyed | No | NUMERIC(1) | No | Indicates if the label was destroyed. Destroyed labels cannot be restored. |
Table: MAINLINE
Comment | Contains a list of mainline branches stored in the RDBMS database |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
MainlineName | No | VARCHAR(128) | No | Unique mainline name |
MainlineUUID | No | VARCHAR(114) | No | Universally unique mainline identifier |
Disassociated | No | NUMERIC(1) | No | Indicates if the mainline was removed, but not destroyed, from the Surround SCM Server |
MainlineVers | No | VARCHAR(30) | No | Mainline schema version number |
LoadBranch | No | VARCHAR(1024) | No | Comma separated list of branch IDs to load in the server cache when the mainline loads |
NameCaseSensitive | No | NUMERIC(1) | No | Indicates if the mainline allows case-sensitive file and repository names. Default is false. |
Destroyed | No | NUMERIC(1) | No | Indicates if the mainline was destroyed. Destroyed mainlines cannot be used or restored. |
Table: MAINLINEOPTN
Comment | Contains a list of mainline options |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
idMainlineOptn | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
OptValue | No | VARCHAR(255) | No | Mainline option value |
Table: MERGEEVENT
Comment | Contains information about file merges |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
MergeEventID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
BranchFileIDFrom | No | NUMERIC(10) | Yes | Foreign key to the BRANCHFILE table. File the changes originated from. |
LocalVersionStart | No | NUMERIC(10) | Yes | Merge from file version to start searching in |
LocalVersionEnd | No | NUMERIC(10) | Yes | Merge from file version to end searching in |
BranchFileIDTo | No | NUMERIC(10) | Yes | Foreign key to the BRANCHFILE table. File changes are merged to. |
LocalVersion | No | NUMERIC(10) | Yes | Merge to file version |
Destroyed | No | NUMERIC(1) | No | Indicates if the merge was destroyed. Destroyed merges cannot be restored. |
Table: OLDLABEL
Comment | Contains legacy labels found when upgrading a non-RDBMS mainline branch |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
OldLabelID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
LabelName | No | VARCHAR(255) | No | Old label name |
OwnerID | No | NUMERIC(10) | No | Date/time the old label was created |
TimeCreated | No | TIMESTAMP | No | Old label owner |
Upgraded | No | NUMERIC(1) | No | Indicates if the old label was upgraded |
Table: OLDLABELFILE
Comment | Contains legacy labeled file revisions |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
OldLabelID | Yes | NUMERIC(10) | Yes | Foreign key to the OLDLABEL table. Old label applied to the file. |
FileRevisionID | Yes | NUMERIC(10) | Yes | Foreign key to the FILEREVISION table. File revision labeled with the old label. |
UserID | No | NUMERIC(10) | No | User who applied the old label to the file |
EventTime | No | TIMESTAMP | No | Date/time the old label was applied to the file |
Comments | No | VARCHAR(4096) | No | Comments for the old label event |
Table: OWNERLCK
Comment | Contains information about the database version and Surround SCM Server it is associated with |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idOwnerLck | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
OwnerValue | No | VARCHAR(114) | No | Owner value. Either the Surround SCM Server database version or the universally unique identifier for the server the database belongs to. |
Table: RDBMSOPTNS
Comment | Contains RDBMS vendor-specific options used for database connections |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idRdbmsOptns | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
OptDesc | No | VARCHAR(63) | No | Option description |
OptValue | No | VARCHAR(255) | No | Option value |
Table: REPOSITORY
Comment | Contains the master list of repositories |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
RepositoryID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ParentRepoID | No | NUMERIC(10) | No | Foreign key reference to the REPOSITORY table. Parent repository. |
Destroyed | No | NUMERIC(1) | No | Indicates if the repository was destroyed. Destroyed repositories cannot be restored. |
Table: REPOSITORYSECURITY
Comment | Contains information about security group permissions set for the repository and branch |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | No | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchID | No | NUMERIC(10) | Yes | Branch ID the security is set for. Branch ID 4294967294 indicates repository security is set. |
RepoPath | No | VARCHAR(2048) | Yes | Path to the repository that security is set for |
SecurityGroupID | No | NUMERIC(10) | No | Foreign key to the SCMGROUPS table. Parent security group the repository security belongs to |
Permissions | No | NUMERIC(10) | No | Security permissions set for the repository |
Destroyed | No | NUMERIC(1) | No | Indicates if the repository security was destroyed. Destroyed settings cannot be restored. |
Table: REVISIONDELTA
Comment | Contains a list of file delta data |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
FileRevisionID | Yes | NUMERIC(10) | Yes | Foreign key to the FILEREVISION table. Revision the file delta belongs to. |
DeltaIndex | Yes | NUMERIC(10) | Yes | Delta chunk data order number. Deltas are split into smaller pieces for database storage and use this order for reassembly. |
FileDelta | No | IMAGE | No | Binary file delta contents |
Destroyed | No | NUMERIC(1) | No | Indicates if the revision delta was destroyed. Destroyed revision deltas cannot be restored. |
Table: REVISIONTHUMB
Comment | Contains thumbnails generated for images |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
FileRevisionID | Yes | NUMERIC(10) | Yes | Foreign key to the FILEREVISION table. File revision the thumbnail is for. |
OrigX | No | NUMERIC(10) | No | Original image width |
OrigY | No | NUMERIC(10) | No | Original image height |
ThumbX | No | NUMERIC(10) | No | Thumbnail image width |
ThumbY | No | NUMERIC(10) | No | Thumbnail image height |
FileThumb | No | IMAGE | No | Binary file thumbnail contents |
Destroyed | No | NUMERIC(1) | No | Indicates if the revision thumbnail was destroyed. Destroyed thumbnails cannot be restored. |
Table: SCMAUDITLOG
Comment | Audit log of electronically signed events |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
EventID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
BranchFileID | No | NUMERIC(10) | No | Key to the BRANCHFILE table. File the event was performed on. |
FileVersion | No | NUMERIC(10) | No | File version the event was performed on. |
FileRevisionID | No | NUMERIC(10) | No | Key to the FILEREVISION table. Internal Surround SCM version tree of the file. |
EventType | No | NUMERIC(5) | No | Event type - 1: Added to repository, 31: State changed |
EventDate | No | TIMESTAMP | No | Event timestamp |
UserID | No | NUMERIC(10) | No | Key to the SCMUSERS table. User who signed the event. |
UserName | No | TEXT | No | User who signed the event |
FullName | No | VARCHAR(255) | No | Full name of user who signed the event |
Meaning | No | VARCHAR(4096) | No | Reason text collected with electonic signature |
MachineName | No | VARCHAR(255) | No | Machine name where user signed from |
ClientType | No | NUMERIC(10) | No | Client type where user signed from |
VerificationHash | No | VARCHAR(255) | No | Hash used to validate data consistency |
Destroyed | No | NUMERIC(1) | No | Indicates if the event was destroyed. Destroyed events cannot be restored. |
Table: SCMCUSTOMFLDS
Comment | Contains custom field rules used in filters, reports, and triggers |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idCustomField | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
Deleted | No | NUMERIC(1) | No | Indicates if the custom field was deleted |
Name | No | VARCHAR(128) | Yes | Custom field name |
Type | No | NUMERIC(5) | No | Custom field type - 1: Text, 2: Integer, 3: Float, 4: List, 5: SCM user, 6: Date/time, 7: Check box |
DisplayOrder | No | NUMERIC(10) | No | Custom field display order |
FieldCode | No | VARCHAR(128) | No | Custom field code |
DfltNotSet | No | NUMERIC(1) | No | Indicates if the custom field has a default set of values |
Limits | No | TEXT | No | Custom field minimum and maximum value and other value limits |
DfltIntValue | No | NUMERIC(10) | No | Integer custom field default value |
DfltTextValue | No | TEXT | No | Text custom field default value |
DfltDateValue | No | TIMESTAMP | No | Date custom field default value |
DfltBoolValue | No | NUMERIC(1) | No | Check box custom field default value |
DfltDoubleValue | No | DOUBLE PRECISION | No | Float custom field default value |
Table: SCMGROUPS
Comment | Contains security group information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idGroup | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
Name | No | VARCHAR(128) | No | Security group name |
Description | No | VARCHAR(1020) | No | Security group description |
Notes | No | TEXT | No | Security group notes |
SecurityVersion | No | NUMERIC(5) | No | Security version |
Table: SCMSTATES
Comment | Contains workflow state information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idState | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
Deleted | No | NUMERIC(1) | No | Indicates if the state was deleted |
Name | No | VARCHAR(128) | Yes | State name |
Description | No | VARCHAR(1020) | No | State description |
ESigRequired | No | NUMERIC(1) | No | State requires electronic signature |
AutoReset | No | NUMERIC(1) | No | State resets to default on version change |
Table: SCMUSERS
Comment | Contains Surround SCM user information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idUser | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
Username | No | TEXT | No | Surround SCM username |
TTProUsername | No | TEXT | No | Helix ALM username |
TTProPassword | No | TEXT | No | Helix ALM password |
ExternalIssueUsername | No | VARCHAR(255) | No | External issue tracking tool username |
ExternalIssuePassword | No | VARCHAR(2721) | No | External issue tracking tool encrypted password |
Table: SCMWORKFLOWS
Comment | Contains workflow information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idWorkFlow | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
Name | No | VARCHAR(128) | Yes | Workflow name |
Description | No | VARCHAR(1020) | No | Workflow description |
idDefaultState | No | NUMERIC(10) | No | Foreign key to the SCMSTATES table. Default workflow state. |
RollbackOption | No | NUMERIC(1) | No | Indicates if state is rolled back with file rollback |
Table: SCMWRKFLWDFLT
Comment | Contains default workflow information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idDefaultWorkFlow | Yes | NUMERIC(10) | Yes | Foreign key to the SCMWORKFLOWS table. Default workflow for the mainline branch. |
Table: SCMWRKFLWSTATES
Comment | Contains workflow states |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idWorkFlow | Yes | NUMERIC(10) | Yes | Foreign key to the SCMWORKFLOWS table. Workflow that contains the states. |
idState | Yes | NUMERIC(10) | Yes | Foreign key to the SCMSTATES table. Workflow state. |
DisplayOrder | No | NUMERIC(5) | No | Workflow state display order |
Table: SCMWRKFLWTRANS
Comment | Contains workflow transitions |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idWorkFlow | Yes | NUMERIC(10) | Yes | Foreign key to the SCMWORKFLOWS table. Workflow that contains the transitions. |
idStateFrom | Yes | NUMERIC(10) | Yes | Foreign key to the SCMSTATE table. Workflow state to transition from. |
idStateTo | Yes | NUMERIC(10) | Yes | Foreign key to the SCMSTATE table. Workflow state to transition to. |
Enabled | No | NUMERIC(1) | No | Indicates if transition is enabled |
Table: SHELF
Comment | Contains a list of shelves for the mainlines in the RDBMS database |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
ShelfID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
OwnerID | No | NUMERIC(10) | No | Foreign key to the SCMUSERS table. Shelf owner. |
ShelfName | No | VARCHAR(255) | No | Shelf name |
ShelfDescription | No | VARCHAR(1024) | No | Shelf description |
SharingOption | No | NUMERIC(2) | No | Sharing option - 0: Sharing disabled, 1: Share with all, 2: Share with selected |
Destroyed | No | NUMERIC(1) | No | Indicates if the shelf was destroyed. Destroyed shelves cannot be restored. |
Table: SHELFFILE
Comment | Contains file data in shelves |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
ShelfFileID | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ShelfID | Yes | NUMERIC(10) | Yes | Foreign key to the SHELF table. Shelf. |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
BranchID | No | NUMERIC(10) | No | Foreign key to the BRANCH table. Branch the shelf is from. |
FileID | No | NUMERIC(10) | No | Foreign key to the ARCHIVEFILE table. Shelved file archive file ID. |
BranchFileID | No | NUMERIC(10) | No | Foreign key to the BRANCHFILE table. Shelved file branch file ID. |
ParentBranchRepoID | No | NUMERIC(10) | No | Foreign key to the BRANCHREPOSITORY table. Shelved file parent branch repository ID. |
FileVersion | No | NUMERIC(10) | No | Original file version before shelved |
RepositoryPath | No | VARCHAR(1024) | No | Shelved file repository path |
FileName | No | VARCHAR(255) | No | Shelved filename |
RelativePath | No | VARCHAR(1024) | No | Shelved file relative path. Used for new files added to a shelf. |
FileType | No | NUMERIC(2) | No | Archive file type - 0: Unknown, 1: AutoDetect, 2: Text, 3: Binary, 4: MacBinary, 5: UTF8, 6: UTF16, 7: Symlink. |
FileRevisionID | No | NUMERIC(10) | No | Foreign key to the SCMFILTERS table. Shelved file revision ID. |
Destroyed | No | NUMERIC(1) | No | Indicates if the file was destroyed. Destroyed files cannot be restored. |
Table: SHELFSHARING
Comment | Contains information about users shelves are shared with |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
ShelfID | Yes | NUMERIC(10) | Yes | Foreign key to the SHELF table. Shared shelf ID. |
MainlineID | Yes | NUMERIC(10) | Yes | Parent mainline branch ID |
ShelfSharedUserID | Yes | NUMERIC(10) | Yes | Foreign key to the SCMUSERS table. User the shelf is shared with. |
Table: SYNCTRACK
Comment | Contains information used to track the last time changes were made to tables to sync mainlines stored in other RDBMS databases |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
TrackID | Yes | NUMERIC(10) | Yes | List to sync record ID - 1: Workflow, 2: State, 3: User, 4: Security group, 5: Helix ALM connection, 6: Custom field |
SyncTime | No | TIMESTAMP | No | Date/time the list was last synced |
Table: TTPRODBCONF
Comment | Contains Helix ALM connection information |
Columns:
Column name | Primary key | Data type | Not NULL | Comment |
idTTProDbConf | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
ConfigName | No | VARCHAR(128) | No | Helix ALM connection name |
DisplayOrder | No | NUMERIC(5) | No | Helix ALM connection display order |
TTServerIP | No | VARCHAR(512) | No | Helix ALM Server IP address |
TTServerPort | No | NUMERIC(5) | No | Helix ALM Server port number |
TTDbName | No | VARCHAR(128) | No | Helix ALM project name |
TTDbID | No | NUMERIC(10) | No | Helix ALM project ID |
TTProjUUID | No | VARCHAR(38) | No | Helix ALM project universally unique identifier |
TTPublicKey | No | VARCHAR(1024) | No | Helix ALM Server RSA exchange public key |
|