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