|
Quality Center Database |
|
|
Quality Center Database |
Details of individual requirements and the structure of the requirements tree.
The tree structure is stored in two ways. First, each record holds a pointer to the parent in RQ_FATHER_ID. Within the children of each parent, the order is set with RQ_ORDER_ID. Thus, a self-join between REQ parent and REQ child ordered by child.RQ_FATHER_ID, child.RQ_ORDER_ID can be used to recreate the tree.
The second way the tree is stored is in RQ_REQ_PATH. The highest level nodes (RQ_FATHER_ID = -1) are ordered from AAA to ZZZ. Each child node down the tree inherits the parent path, and within the parent node, the requirements are ordered AAA to ZZZ where the current level numeration is concatenated to the inherited path. For example, the child requirements of the first node (AAA) have paths of AAAAAA, AAAAAB, AAAAAC, and so on.
Use of a self-join is easy to program when recreating the entire tree or a sub-tree. The path can be used when looking for the children of a given node since the child paths are the parent path plus three more characters.
To identify the tests and test steps that cover the requirements, see the REQ_COVER Table.
Multiple values for fields are maintained in the REQ_MULTIVALUE Table.
For table relationships, see the Requirements Module Overview.
Many of the integer values are ENUMs. For possible values, see the API reference.
| Column Name | Description | Datatype | Length | Allow Nulls |
|
|---|---|---|---|---|---|
 |
RQ_REQ_ID | The record ID. | Integer | 4 | |
| RQ_FATHER_ID | The ID of the requirement for which
this requirement is a sub-requirement. Top level requirements have
a father ID of |
Integer | 4 | 
|
|
| RQ_ORDER_ID | The order in which the requirement appears in the user interface among other requirements at the same level of the requirements hierarchy. | Integer | 4 |
|
|
| RQ_ISTEMPLATE | For backward compatibility. Field may be removed in future version. | Integer | 4 |
|
|
| RQ_REQ_COMMENT | The requirement comment. | LongVarChar | 16 |
|
|
| RQ_REQ_REVIEWED | Indicates whether or not the user
responsible for the project has reviewed the requirement. The values are from the Review Status custom list. Typical values are: Changed, Not Reviewed, Reviewed. |
VarChar | 70 |
|
|
| RQ_REQ_PATH | The requirement path in the requirements hierarchy. See explanation in the Remarks. | VarChar | 255 | ||
| RQ_REQ_STATUS | The aggregated status of previous runs
of tests in the requirement coverage. Indicates whether any test
that covers the requirement fails.
The values are from the Status custom list. Typical values are: No Run, Failed, Passed, Not Completed, N/A. In addition to the values from the list, the Not Covered value can be assigned. |
VarChar | 70 |
|
|
| RQ_REQ_PRIORITY | The requirement priority level. The values are from the Priority custom list. Typical values are: 1-Low, 2-Medium, 3-High, 4-Very High, 5-Urgent. |
VarChar | 70 |
|
|
| RQ_REQ_TYPE | Obsolete. In previous versions, the
requirement type. The values are from the Requirement Type custom
list. Typical values are: Change, Functional, Guideline, Quality, Standard, System. |
VarChar | 70 |
|
|
| RQ_REQ_PRODUCT | The product for which the requirement is designed. | VarChar | 70 |
|
|
| RQ_REQ_NAME | The name assigned to the requirement by the tester who designed the requirement. | VarChar | 255 |
|
|
| RQ_REQ_AUTHOR | The user name of the person who designed the requirement. | VarChar | 70 |
|
|
| RQ_RBT_IGNORE_IN_ANALYSIS | A value of Y indicates that this requirement is not included in risk-based quality management analysis regardless of filter and other settings. | VarChar | 1 |
|
|
| RQ_RBT_BSNS_IMPACT | Business Criticality value calculated by Quality Center. A value of enum TD_RBT_BI_LEVELS. | VarChar | 1 |
|
|
| RQ_RBT_CUSTOM_BSNS_IMPACT | Business Criticality value set
by a user.
A value of enum TD_RBT_BI_LEVELS. |
VarChar | 1 |
|
|
| RQ_RBT_USE_CUSTOM_BSNS_IMPACT | If true, RQ_RBT_CUSTOM_BSNS_IMPACT is
used.
If false, RQ_RBT_BSNS_IMPACT is used. |
VarChar | 1 |
|
|
| RQ_RBT_EFFECTIVE_BSNS_IMPACT | The Business Impact value used by the risk-based quality management analysis algorithm to analyze the Testing Level and testing time of this requirement. The value depends on the RQ_RBT_USE_CUSTOM_BSNS_IMPACT setting. | VarChar | 1 |
|
|
| RQ_RBT_FAIL_PROB | The Failure Probability value
calculated by Quality Center.
A value of enum TD_RBT_FP_LEVELS. |
VarChar | 1 |
|
|
| RQ_RBT_CUSTOM_FAIL_PROB | The Failure Probability value set
by a user.
A value of enum TD_RBT_FP_LEVELS. |
VarChar | 1 |
|
|
| RQ_RBT_USE_CUSTOM_FAIL_PROB | If true, RQ_CUSTOM_FAIL_PROB is used.
If false, RQ_FAIL_PROB is used. |
VarChar | 1 |
|
|
| RQ_RBT_EFFECTIVE_FAIL_PROB | The Failure Probability value used by the risk-based quality management analysis algorithm. The value depends on the RQ_RBT_USE_CUSTOM_FAIL_PROB setting. | VarChar | 1 |
|
|
| RQ_RBT_TESTING_LEVEL | Testing Level set by the risk-based quality management analysis. A value of enum TD_RBT_TESTING_LEVELS. | VarChar | 70 |
|
|
| RQ_RBT_CUSTOM_TESTING_LEVEL | Testing Level value set by a user. A value of enum TD_RBT_TESTING_LEVELS. | VarChar | 70 |
|
|
| RQ_RBT_TESTING_HOURS | The testing time that was estimated for this requirement by the risk-based quality management analysis. | Integer | 4 |
|
|
| RQ_RBT_CUSTOM_TESTING_HOURS | Testing time value set by a user. | Integer | 4 |
|
|
| RQ_RBT_USE_CUSTOM_TL_AND_TE | Indicates whether to use custom or calculated Testing Level and testing time for risk-based quality management calculations. | VarChar | 1 |
|
|
| RQ_RBT_RND_ESTIM_EFFORT_HOURS | Estimated development time. | Integer | 4 |
|
|
| RQ_RBT_ASSESSMENT_DATA | The values assigned to the
risk-based quality management assessment criteria.
It is recommended to edit this value in the Quality Center user interface, and not to write directly to the database. |
LongVarChar | 16 |
|
|
| RQ_RBT_ANALYSIS_PARENT_REQ_ID | The RQ_REQ_ID of the requirement on which was performed the last analysis that was used to calculate the RQ_TESTING_LEVEL and RQ_TESTING_HOURS fields of this requirement. | Integer | 4 |
|
|
| RQ_RBT_ANALYSIS_SETUP_DATA | The settings used to perform the last
risk-based quality management analysis of the sub-tree of this
requirement, including the filter, the policy, and the allocated
time.
It is recommended to edit this value in the Quality Center user interface, and not to write directly to the database. |
LongVarChar | 16 |
|
|
| RQ_RBT_ANALYSIS_RESULT_DATA | The aggregated results of the latest
risk-based quality management analysis.
It is recommended to edit this value in the Quality Center user interface, and not to write directly to the database. |
LongVarChar | 16 |
|
|
| RQ_RBT_LAST_ANALYSIS_DATE | The date and time of the last analysis. | DBTimeStamp | 4 |
|
|
| RQ_USER_01 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_02 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_03 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_04 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_05 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_06 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_07 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_08 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_09 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_10 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_11 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_12 | User-defined field. | VarChar | 40 |
|
|
| RQ_REQ_VER_STAMP | The revision number of this requirement. Increments each time the record is updated. | Integer | 4 |
|
|
| RQ_ATTACHMENT | A value of Y indicates that the requirement has at least one attachment. | VarChar | 1 |
|
|
| RQ_REQ_DATE | The date the requirement was created according to the database server clock. | DBTimeStamp | 4 |
|
|
| RQ_REQ_TIME | The time the requirement was created according to the database server clock. | VarChar | 10 |
|
|
| RQ_NO_OF_SONS | The number of requirements that have this requirement as a parent requirement, that is, have their RQ_FATHER_ID field set to this requirement’s ID. | Integer | 4 |
|
|
| RQ_IS_FOLDER | Used by the ReqPro synchronizer. | VarChar | 1 |
|
|
| RQ_VTS | The time stamp of the last time the record was updated according to the database server clock. | VarChar | 20 |
|
|
| RQ_USER_13 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_14 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_15 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_16 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_17 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_18 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_19 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_20 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_21 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_22 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_23 | User-defined field. | VarChar | 40 |
|
|
| RQ_USER_24 | User-defined field. | VarChar | 40 |
|
|
| RQ_REQUEST_ID | The ITG request ID. Used internally for ITG-QC integration. | Integer | 4 |
|
|
| RQ_TEXT_SYNC | For internal use. Do not change data. | VarChar | 1 |
|
|
| RQ_REQUEST_SERVER | The URL of the ITG server. Used internally for ITG-QC integration. | VarChar | 120 |
|
|
| RQ_REQUEST_TYPE | ITG request type. Used internally for ITG-QC integration. | VarChar | 120 |
|
|
| RQ_REQUEST_STATUS | ITG request status. Used internally for ITG-QC integration. | VarChar | 40 |
|
|
| RQ_REQUEST_UPDATES | ITG request updates information. Used internally for ITG-QC integration. | VarChar | 120 |
|
|
| RQ_REQUEST_ASSIGN_TO | The user to whom the requirement is assigned. | VarChar | 120 |
|
|
| RQ_REQUEST_NOTE | The notes added to the request in ITG. | LongVarChar | 16 |
|
|
| RQ_TYPE_ID | The REQ_TYPE.TPR_TYPE_ID.
A value of 0 indicates that the requirement type is not defined. |
Integer | 4 | ||
| RQ_TARGET_RCYC | For internal use. Do not write to this field. | Integer | 4 |
|
|
| RQ_TARGET_REL | For internal use. Do not write to this field. | Integer | 4 |
|
|
| RQ_DEV_COMMENTS | Comments about the requirement. | LongVarChar | 16 |
|
|
| RQ_HAS_RICH_CONTENT | Requirement has rich-text content.
This property is used only in Quality Center 9.2. Its use will be discontinued in later versions. |
VarChar | 1 |
|
| Index | Primary | Unique |
|---|---|---|
| RQ_FATHER_NAME_LWR_IDX |
|
|
| RQ_PRIMARYKEY |
|
|
| RQ_REQ_PATH_IDX |
|
|
| RQ_REQ_STATUS_IDX |
|
|
| RQ_TYPE_ID_IDX |
|
|
| Trigger | Description |
|---|---|
| AUTR81022_REQ |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |