Share this page
ALM Project Database Reference
td.ENVIRONMENTS Table
Description
Testing environments.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ENV_ID | The record ID. | int | 4 | |||
| ENV_NAME | The name of the item. | varchar | 255 |  | |||
| ENV_DESCRIPTION | A free text description of this item. | varchar | 16 | | |||
| ENV_OS | The operating system. | varchar | 70 | | |||
| ENV_BROWSER | The web brower. | varchar | 70 | | |||
| ENV_HAS_ATTACHMENTS | Y if this item has attachments. | varchar | 1 | | |||
| ENV_LOGICAL_NAME | A name, unique in the scope of this table, that refers to this record. | varchar | 64 | ||||
| ENV_USER_01 | User-defined field. | varchar | 40 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| ENVIRONMENTS_PK | | | |
| ENVIRONMENTS_UNIQUE_L_NAME | |
Triggers
| Trigger | Description |
|---|---|
| AUTR_345769792_ENVIRONMENTS |
Objects that depend on td.ENVIRONMENTS
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | AUTR_345769792_ENVIRONMENTS | Trigger | 1 | |
| AUTR_363696399_TESTCYCL | Trigger | 2 | |
| AUTR64594118_CYCLE | Trigger | 2 | |
| AUTR66132_BUG | Trigger | 2 | |
 | td.BUG | Table | Information about defects. | 1 |
| td.CYCLE | Table | Test sets. | 1 |
| MVTR_BUG | Trigger | 2 | |
| td.TESTCYCL | Table | Instances of design tests in test sets. | 1 |
 | td.V_TESTSET_REQ_COVER | View | 2 |
Objects that td.ENVIRONMENTS depends on
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| td.AUDIT_LOG | Table | Events on which history is recorded. | 1 |
| td.AUDIT_PROPERTIES | Table | Details of the changes recorded in the AUDIT_LOG table. | 1 |
See Also
Related Objects
