ST_VIEWMEMBERHISTORY
This table lists the view member history including deleted and moved items.
Column | Field | Type | Length | Primary | Description |
---|---|---|---|---|---|
1 |
ServerID |
int |
4 |
Y |
Server ID |
2 |
ViewID |
int |
4 |
N |
View ID |
3 |
ItemID |
int |
4 |
Y |
Item ID |
4 |
ItemRevisionNumber |
int |
4 |
Y |
|
5 |
CreatedTime |
datetime |
8 |
N |
Created Time |
6 |
CreatedUserID |
varchar |
254 |
N |
Created User |
7 |
ModifiedTime |
datetime |
8 |
N |
Modified Time |
8 |
ModifiedUserID |
varchar |
254 |
N |
Modified User |
9 |
DeletedTime |
datetime |
8 |
N |
Deleted Time |
10 |
DeletedUserID |
varchar |
254 |
N |
Deleted User |
11 |
EndModifiedTime |
datetime |
8 |
N |
End time for revision |
12 |
ParentFolderID |
int |
4 |
N |
Item ID of Parent Folder |
13 |
ProjectID |
int |
4 |
N |
Project ID |
14 |
ClassID |
int |
4 |
N |
Class ID of Item type |
15 |
TypeName |
varchar |
254 |
N |
Name of item type |
16 |
ID |
int |
4 |
N |
Object ID |
17 |
ConfigType |
int |
4 |
N |
Configuration type |
18 |
ConfigData |
datetime |
8 |
N |
Table Joins
Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
---|---|---|---|---|
1 |
ST_VIEWMEMBER |
ServerID |
ST_VIEWMEMBERHISTORY |
ServerID |
2 |
STVIEWMEMBER |
ItemID |
STVIEWMEMBERHISTORY |
ItemID |