ST_AUDITS

This table describes the list of audits.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ID	int	4	Y	Audit ID
3	ParentFolderID	int	4	N	ItemID of parent folder
4	ViewID	int	4	N	ID of view
5	ProjectID	int	4	N	ID of project
6	EventID	varchar	254	N	Event
7	CreatedTime	datetime	8	N	Time for audit
8	UserID	varchar	254	N	User
9	ClassID	int	4	N
10	ClassName	varchar	254	N	Class name of audited item
11	ObjectID	int	4	N	Object ID of audited item
12	Info	varchar	254	N
13	RevisionTime	datetime	8	N
14	ClassID2	int	4	N
15	Class_Name_2	text	16	N
16	ObjectID2	int	4	N
17	Info2	varchar	254	N
18	RevisionTime2	datetime	8	N
19	ClassID3	int	4	N
20	Class_Name_3	text	16	N
21	ObjectID3	int	4	N
22	Info3	varchar	254	N
23	RevisionTime3	datetime	8	N

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_VIEWMEMBER	ServerID	ST_AUDITS	ServerID
2	STVIEWMEMBER	ItemID	ST_AUDITS	ParentFolderID