ST_CHANGEPACKAGES

This table provides the list of change packages.

Column Field Type Length Primary Description
1 ServerID int 4 Y Server ID
2 ID int 4 Y Object ID
3 CreatedTime datetime 8 N Created Time
4 CreatedUserID varchar 254 N Created User
5 ModifiedTime datetime 8 N Modified Time
6 ModifiedUserID varchar 254 N Modified User
7 RevisionNumber int 4 N Revision Number
8 RevisionFlags int 4 N Revision Flags
9 StComment text 16 N Comment
10 Name varchar 762 N Name
11 Description text 16 N Description
12 SessionType varchar 254 N Type of Session
13 Responsibility varchar 254 N Responsible User
14 SourceViewID int 4 N View of Source
15 TargetViewID int 4 N View of Target
16 State varchar 254 N State of Change Package
17 CommitTime datetime 8 N Commit Time for Change Package
18 CommitUserID varchar 254 N Commit user
19 TransactionID int 4 N Transaction ID
20 CommittedInBuild varchar 254 N Committed Build
21 PreCommitViewLabel varchar 254 N Pre commit view label
22 PreCommitRevisionLabel varchar 254 N Pre commit revision label
23 PostCommitViewLabel varchar 254 N Post commit view label
24 PostCommitRevisionLabel varchar 254 N Post commit revision label
25 AttachmentCount int 4 N Attachment Count
26 AttachmentNames text 16 N Attachment Names

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field
1 ST_CHANGEPACKAGES ServerID ST_CHANGEPACKAGECHANGES ServerID
2 ST_CHANGEPACKAGES ID ST_CHANGEPACKAGECHANGES  
1 ST_CHANGEPACKAGES ServerID ST_CHANGEPACKAGEHISTORY ServerID
2 ST_CHANGEPACKAGES ID ST_CHANGEPACKAGEHISTORY ID
1 ST_CHANGEPACKAGES ServerID ST_OBJECTACLS ServerID
2 STCHANGEPACKAGES ID STOBJECTACLS ObjectID