Project Data Tables Database > td Schema : td.STEP_PARAMS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
SP_ID | The record ID. | int | 4 | ||||
SP_ENTITY | The name of the table containing the entity for which the parameter value was created. For example, DESSTEPS, TESTCYCL, TEST_CONFIGS, or RUN. | varchar | 40 | ||||
SP_OWNER_ID | The record ID in the table specified by SP_ENTITY. | int | 4 | ||||
SP_KEY | Obsolete. Replaced by SP_OWNER_ID. Retained in schema for backwards compatibility. Was: The string representation of the record ID of the instance to which the parameter belongs in the table specified by SP_ENTITY . | varchar | 40 | ||||
SP_TEST_PARAM_ID | The TEST_PARAMS.TP_ID of the parameter. | int | 4 | ||||
SP_PARAM_NAME | Obsolete. Retained in schema for backwards compatibility. Was: The parameter name. | varchar | 255 | ||||
SP_PARAM_VALUE | Obsolete. Replaced by SP_PARAM_ACTUAL_VALUE. Retained in schema for backwards compatibility. Was: The parameter value. | varchar | 255 | ||||
SP_PARAM_ACTUAL_VALUE | The parameter value. The value can be any string | varchar | 16 | ||||
SP_ORIGIN_TEST | The TEST.TS_TEST_ID of the design test from which the step is derived. If no design test exists, -1. | int | 4 | ||||
SP_VALUE_FROM_ENTITY | Obsolete. Retained in schema for backwards compatibility. | varchar | 40 | ||||
SP_VALUE_FROM_KEY | Obsolete. Retained in schema for backwards compatibility. | varchar | 50 | ||||
SP_REF_COUNT | Obsolete. This information is is the TEST_PARAMS Table. Retained in schema for backwards compatibility. Was: The number of steps in which this parameter is used. Applies only to Test entities. | int | 4 | ||||
SP_ASSIGNED_BY | Obsolete. Retained in schema for backwards compatibility. | varchar | 40 | ||||
SP_ASSIGN_DATE | Obsolete. Retained in schema for backwards compatibility. | datetime | 4 | ||||
SP_ASSIGN_TIME | Obsolete. Retained in schema for backwards compatibility. | varchar | 12 | ||||
SP_VC_USER_NAME | The user who checked out the item under version control. If the item is not checked out, this field is blank. | varchar | 60 |
Index | Description | Primary | Unique |
---|---|---|---|
STEP_PARAMS_IX1 | |||
STEP_PARAMS_IX2 | |||
STEP_PARAMS_PK |