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