ST_FOLDERS

This table provides the folders.

Column Field Type Length Primary Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

ObjectID

3

CreatedTime

datetime

8

N

ObjectID of the root object

4

CreatedUserID

varchar

254

N

Creation time

5

ModifiedTime

datetime

8

N

Creation user

6

ModifiedUserID

varchar

254

N

Time last modified

7

RevisionNumber

int

4

N

Number of revisions since branching

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

 

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_FOLDERS

ServerID

ST_FOLDERHISTORY

ServerID

2

ST_FOLDERS

ID

ST_FOLDERHISTORY

ID

1

ST_FOLDERS

ServerID

ST_LINKS

ServerID

2

ST_FOLDERS

ID

ST_LINKS

ParentObjectID

1

ST_FOLDERS

ServerID

ST_LINKS

ServerID

2

ST_FOLDERS

ID

ST_LINKS

ChildObjectID

1

ST_FOLDERS

ServerID

ST_OBJECTACLS

ServerID

2

STFOLDERS

ID

STOBJECTACLS

ObjectID