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