ST_FILEHISTORY

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