ST_TRACES

This table contains the list of traces.

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	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_OBJECTACLS	ServerID
2	ST_TRACES	ID	ST_OBJECTACLS	ObjectID
1	ST_TRACES	ServerID	ST_TRACEHISTORY	ServerID
2	STTRACES	ID	STTRACEHISTORY	ID