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