This table provides the folder history - 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 |
ObjectID of the root object |
|
5 |
CreatedUserID |
varchar |
254 |
N |
Creation time |
|
6 |
ModifiedTime |
datetime |
8 |
N |
Creation user |
|
7 |
ModifiedUserID |
varchar |
254 |
N |
Time 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 |
Folder name |
|
17 |
Description |
varchar |
762 |
N |
Description |
|
18 |
WorkingFolder |
varchar |
762 |
N |
Working Folder |
|
19 |
ExcludeFlags |
varchar |
254 |
N |
Files to be Excluded |
|
20 |
ExcludeSpec |
varchar |
762 |
N |
Exclude Spec |
|
21 |
CreateProjectID |
int |
4 |
N |