| Project Data Tables Database > td Schema : td.ENVIRONMENTS Table |
| 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 | ![]() |
| Index | Description | Primary | Unique |
|---|---|---|---|
| ENVIRONMENTS_PK | ![]() | ![]() | |
| ENVIRONMENTS_UNIQUE_L_NAME | ![]() |
| Trigger | Description |
|---|---|
| AUTR_345769792_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 |
| 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 |