ST_TRACEHISTORY
This table contains the trace history - one record for each 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 |
RootObjectID |
int |
4 |
N |
Root object ID |
11 |
ParentObjectID |
int |
4 |
N |
Parent object ID |
12 |
ParentRevision |
int |
4 |
N |
Parent revision |
13 |
PathRevision |
int |
4 |
N |
Path Revision |
14 |
ViewID |
int |
4 |
N |
View ID |
15 |
DotNotation |
varchar |
254 |
N |
Dot Notation |
16 |
Description |
text |
16 |
N |
Description |
17 |
Type |
varchar |
254 |
N |
Type of Trace |
18 |
AttachmentCount |
int |
4 |
N |
Attachment Count |
19 |
AttachmentNames |
text |
16 |
N |
Attachment Names |
20 |
SourceItemID |
int |
4 |
N |
Item ID of source item |
21 |
SourceItemType |
varchar |
254 |
N |
Source type |
22 |
SourceVersion |
varchar |
254 |
N |
Source version |
23 |
Source |
varchar |
254 |
N |
Source descriptor |
24 |
TargetExternalID |
varchar |
254 |
N |
Target ID |
25 |
TargetItemType |
varchar |
254 |
N |
Target Type |
26 |
TargetVersion |
varchar |
254 |
N |
Target version |
27 |
Target |
varchar |
254 |
N |
Target descriptor |
Table Joins
Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
---|---|---|---|---|
1 |
ST_TRACES |
ServerID |
ST_TRACEHISTORY |
ServerID |
2 |
ST_TRACES |
ID |
ST_TRACEHISTORY |
ID |
1 |
ST_TRACEHISTORY |
ServerID |
ST_VIEWMEMBER |
ServerID |
2 |
ST_TRACEHISTORY |
ID |
ST_VIEWMEMBER |
ID |
3 |
STTRACEHISTORY |
RevisionNumber |
STVIEWMEMBER |
RevisionNumber |