ST_PROJECTS

This table provides the list of projects.

Column

Field

Type

Length

Primary

Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

Project ID

3

CreatedTime

datetime

8

N

Creation time

4

CreatedUserID

varchar

254

N

Creation user

5

Name

varchar

762

N

Name

6

Description

varchar

762

N

Description

7

Compaction

int

4

N

8

Encryption

varchar

254

N

9

Mail

int

4

N

10

DefaultViewID

int

4

N

Default view ID

11

ProjectType

varchar

254

N

Project Type

12

ConfigSource1

varchar

762

N

13

ConfigSource2

varchar

762

N

14

KWFileExt

varchar

254

N

Keywords File Extensions

15

UseKeywords

int

4

N

Use Keywords

16

ForceCheckinReason

int

4

N

Force Checkin Reason

17

RequireLockForCheckin

int

4

N

Require Lock For Checkin

18

MarkUnlockedFilesReadOnly

int

4

N

Mark Unlocked Files Read Only

19

ProcessRequired

int

4

N

Process Required

20

ProcessSelectCR

int

4

N

Permit selection of Change Request as Process Item

21

ProcessShowCROpen

int

4

N

Restict Change Request status to Open for Process Item

22

ProcessShowCRInProgress

int

4

N

Restict Change Request status to In Progress for Process Item

23

ProcessSelectTask

int

4

N

Permit selection of Task as Process Item

24

ProcessShowTaskReady

int

4

N

Restict Task status to Ready for Process Item

25

ProcessShowTaskInProgress

int

4

N

Restict Task status to In Progress for Process Item

26

DisplayAltCREditor

int

4

N

Use alternate property editor for Change Requests

27

AltCREditorPath

varchar

762

N

Alternate property editor for Change Requests

28

DisplayAltFileEditor

int

4

N

Use alternate property editor for Files

29

AltFileEditorPath

varchar

762

N

Alternate property editor for Files

30

DisplayAltReqEditor

int

4

N

Use alternate property editor for Requirements

31

AltReqEditorPath

varchar

762

N

Alternate property editor for Requirements

32

DisplayAltTaskEditor

int

4

N

Use alternate property editor for Tasks

33

AltTaskEditorPath

varchar

762

N

Alternate property editor for Tasks

34

DisplayAltTopicEditor

int

4

N

Use alternate property editor for Topics

35

AltTopicEditorPath

varchar

762

N

Alternate property editor for Topics

36

ProcessSelectRequirement

int

4

N

Permit selection of Requirement as Process Item

37

ProcessShowReqApproved

int

4

N

Restrict Requirement status to Approved for Process Item

38

ProcessLinks

varchar

254

N

Process Links info

39

DefaultTypes

text

16

N

Default types for project

40

GUID

varchar

192

N

41

State

Varchar

254

N

Project status

42

UseCheckinCP

int

4

N

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_PROJECTS

ServerID

ST_OBJECTACLS

ServerID

2

ST_PROJECTS

ID

ST_OBJECTACLS

ObjectID

1

ST_SERVER

ServerID

ST_PROJECTS

ServerID

1

ST_PROJECTS

ServerID

ST_VIEWS

ServerID

2

ST_PROJECTS

ID

ST_VIEWS

ProjectID