ST_FILEHISTORY

This table provides the file history changes - one record for every revision.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ID	int	4	Y	ObjectID
3	RevisionNumber	int	4	Y	Number of revisions since branching
4	CreatedTime	datetime	8	N	Creation time
5	CreatedUserID	varchar	254	N	Creation user
6	ModifiedTime	datetime	8	N	Time last modified
7	ModifiedUserID	varchar	254	N	User who last modified
8	RevisionFlags	int	4	N	Revision Flags
9	StComment	text	16	N	Comment
10	RootObjectID	int	4	N	ObjectID of the root object
11	ParentObjectID	int	4	N	Object ID of item from which this item is branched from
12	ParentRevision	int	4	N
13	PathRevision	int	4	N	Revision of branching (0 means no branching)
14	ViewID	int	4	N	View ID
15	DotNotation	varchar	254	N	Dot notation
16	Name	varchar	762	N	File name
17	Description	varchar	762	N	Description
18	VaultVersion	int	4	N	Vault Branch Version
19	ContentVersion	int	4	N	Content Revision
20	Modified	datetime	8	N	Time stamp of file
21	FileSize	int	4	N	File size
22	EOL	int	4	N	EOL character
23	Type	varchar	254	N
24	ArchivePath	varchar	762	N
25	ProjectID	int	4	N
26	PVCSRev	varchar	192	N
27	Charset	varchar	254	N	File Type (Binary, ASCII, or Unicode)
28	StorageType	varchar	254	N	Storage Type (Full Versions or Delta)
29	Compression	varchar	254	N	Compression Level
30	Executable	int	4	N
31	HiveID	int	4	N
32	ArchiveFormat	varchar	254	N
33	KeywordFlag	varchar	254	N
34	Extension	varchar	254	N	Extension of the file

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_FILES	ServerID	ST_FILEHISTORY	ServerID
2	ST_FILES	ID	ST_FILEHISTORY	ID
1	ST_FILEHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_FILEHISTORY	ID	ST_VIEWMEMBER	ID
3	STFILEHISTORY	RevisionNumber	STVIEWMEMBER	RevisionNumber