This table provides the list of change requests.
Column |
Field |
Type |
Length |
Primary |
Description |
---|---|---|---|---|---|
1 |
ServerID |
int |
4 |
Y |
Server ID |
2 |
ID |
int |
4 |
Y |
ObjectID |
3 |
CreatedTime |
datetime |
8 |
N |
Creation time |
4 |
CreatedUserID |
varchar |
254 |
N |
Creation user |
5 |
ModifiedTime |
datetime |
8 |
N |
Time last modified |
6 |
ModifiedUserID |
varchar |
254 |
N |
User who 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 |
ChangeNumber |
int |
4 |
N |
Change Request Number |
17 |
Synopsis |
text |
16 |
N |
Synopsis |
18 |
Type |
varchar |
254 |
N |
Type |
19 |
Status |
varchar |
254 |
N |
Status |
20 |
Severity |
varchar |
254 |
N |
Severity |
21 |
Platform |
varchar |
254 |
N |
Platform |
22 |
Category |
varchar |
192 |
N |
Category |
23 |
Component |
varchar |
192 |
N |
Component |
24 |
ExternalReference |
varchar |
192 |
N |
External Reference |
25 |
AddressedIn |
varchar |
254 |
N |
Addressed In |
26 |
AddressedBy |
varchar |
254 |
N |
Addressed By |
27 |
LastBuildTested |
varchar |
254 |
N |
Last Build Tested |
28 |
Responsibility |
varchar |
254 |
N |
Responsibility |
29 |
Priority |
varchar |
254 |
N |
Priority |
30 |
Description |
text |
16 |
N |
Description |
31 |
TestCommand |
varchar |
762 |
N |
|
32 |
WorkAround |
text |
16 |
N |
Work Around |
33 |
Fix |
text |
16 |
N |
Fix |
34 |
ClosedOn |
datetime |
8 |
N |
Time closed |
35 |
AttachmentCount |
int |
4 |
N |
Attachment Count |
36 |
AttachmentNames |
text |
16 |
N |
Names of all attachments |
37 |
ResolvedOn |
datetime |
8 |
N |
Time resolved |
38 |
VerifiedOn |
datetime |
8 |
N |
Time verified |
39 |
AddressedInView |
int |
4 |
N |
|
40 |
EnteredOn |
datetime |
8 |
N |
Time when CR entered |
41 |
EnteredBy |
varchar |
254 |
N |
User who entered CR |
42 |
Usr_StarFlowStatus |
varchar |
254 |
N |
Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
---|---|---|---|---|
1 |
ST_CRS |
ServerID |
ST_CRHISTORY |
ServerID |
2 |
ST_CRS |
ID |
ST_CRHISTORY |
ID |
1 |
ST_CRS |
ServerID |
ST_LINKS |
ServerID |
2 |
ST_CRS |
ID |
ST_LINKS |
ParentObjectID |
1 |
ST_CRS |
ServerID |
ST_LINKS |
ServerID |
2 |
ST_CRS |
ID |
ST_LINKS |
ChildObjectID |
1 |
ST_CRS |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_CRS |
ID |
ST_OBJECTACLS |
ObjectID |