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
|