This table lists the change package history - one record for every revision.
Column |
Field |
Type |
Length |
Primary |
Description |
---|---|---|---|---|---|
1 |
ServerID |
int |
4 |
Y |
Server ID |
2 |
ID |
int |
4 |
Y |
Object ID |
3 |
RevisionNumber |
int |
4 |
Y |
Revision Number |
4 |
CreatedTime |
datetime |
8 |
N |
Created Time |
5 |
CreatedUserID |
varchar |
254 |
N |
Created User |
6 |
ModifiedTime |
datetime |
8 |
N |
Modified Time |
7 |
ModifiedUserID |
varchar |
254 |
N |
Modified User |
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 |
Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
---|---|---|---|---|
1 |
ST_CHANGEPACKAGES |
ServerID |
ST_CHANGEPACKAGEHISTORY |
ServerID |
2 |
ST_CHANGEPACKAGES |
ID |
ST_CHANGEPACKAGEHISTORY |
ID |
1 |
ST_CHANGEPACKAGEHIST |
ServerID |
ST_VIEWMEMBER |
ServerID |
2 |
ST_CHANGEPACKAGEHISTORY | ID | ST_VIEWMEMBER | ID |
3 | ST_CHANGEPACKAGEHIST |
RevisionNumber |
ST_VIEWMEMBER | RevisionNumber |