|
Quality Center Database |
|
|
Quality Center Database |
Test sets.
The test set tree is maintained in the CYCL_FOLD Table.
Test sets are linked to tests in the TESTCYCL Table.
Test sets are linked to test runs with RUN.RN_CYCLE_ID.
Multiple values for fields are maintained in the CYCLE_MULTIVALUE Table.
For table relationships, see the Test Lab Module Overview.
| Column Name | Description | Datatype | Length | Allow Nulls |
|
|---|---|---|---|---|---|
 |
CY_CYCLE_ID | The ID of the test set record. | Integer | 4 | |
| CY_CYCLE | The test set name assigned by the creator of the test set. | VarChar | 255 | 
|
|
| CY_OPEN_DATE | The date the test set was opened. | DBTimeStamp | 4 |
|
|
| CY_CLOSE_DATE | The date the test set was closed. | DBTimeStamp | 4 |
|
|
| CY_STATUS | The current status of the test set: Open or Closed. | VarChar | 70 |
|
|
| CY_DESCRIPTION | The information entered in the Execution Flow tab in the user interface. Includes execution dependencies (conditions) and comments. | LongVarChar | 16 |
|
|
| CY_CYCLE_VER_STAMP | The revision number of this record. Increments each time the record is updated. | Integer | 4 |
|
|
| CY_COMMENT | A description of the test set. | LongVarChar | 16 |
|
|
| CY_ATTACHMENT | Indicates whether the test set has any attachments: Y or N. | VarChar | 1 |
|
|
| CY_EXEC_EVENT_HANDLE | The actions to be executed in response
to various test set execution events. This field is in a
proprietary format. |
LongVarChar | 16 |
|
|
| CY_MAIL_SETTINGS | The mailing actions in response to various test set execution events. This field is in a proprietary format. | LongVarChar | 16 |
|
|
| CY_USER_01 | User-defined field. | VarChar | 40 |
|
|
| CY_USER_02 | User-defined field. | VarChar | 40 |
|
|
| CY_USER_03 | User-defined field. | VarChar | 40 |
|
|
| CY_USER_04 | User-defined field. | VarChar | 40 |
|
|
| CY_USER_05 | User-defined field. | VarChar | 40 |
|
|
| CY_USER_06 | User-defined field. | VarChar | 40 |
|
|
| CY_VTS | The version time stamp. Indicates the time this record was updated according to the database server clock. | VarChar | 20 |
|
|
| CY_OS_CONFIG | For backward compatibility. Field may be removed in future version. | VarChar | 40 |
|
|
| CY_FOLDER_ID | The CYCL_FOLD.CF_ITEM_ID of the folder containing the test set. | Integer | 4 |
|
|
| CY_CYCLE_CONFIG | For backward compatibility. Field may be removed in future version. | LongVarChar | 16 |
|
|
| CY_REQUEST_ID | For backward compatibility. Field may be removed in future version. | Integer | 4 |
|
|
| CY_TEXT_SYNC | For internal use. Do not change data. | VarChar | 1 |
|
|
| CY_ASSIGN_RCYC | The RELEASE_CYCLES.RCYC_ID of the release cycle with which the test set is associated. | Integer | 4 |
|
| Index | Primary | Unique |
|---|---|---|
| CY_FOLDER_IDX |
|
|
| CY_FOLDER_NAME_IDX |
|
|
| CY_PRIMARYKEY |
|
|
| Trigger | Description |
|---|---|
| AUTR64594118_CYCLE |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |