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 |
|
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 |
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 |