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 |