Share this page
ALM Project Database Reference
td.LINK Table
Description
Associations between defects and other entities.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | LN_LINK_ID | The record ID. | int | 4 | |||
| LN_BUG_ID | The defect to which the entity is linked: BUG.BG_BUG_ID. | int | 4 |  | |||
| LN_ENTITY_TYPE | The table name of the entity linked to the defect. If LN_ENTITY_TYPE is BUG, then the link is between two defects. | varchar | 30 | | |||
| LN_ENTITY_ID | The record ID of the entity in the table specified by LN_ENTITY_TYPE. | int | 4 | | |||
| LN_CREATED_BY | The link author. | varchar | 60 | | |||
| LN_CREATION_DATE | The date the link was created, based on the database-server clock. | datetime | 4 | | |||
| LN_LINK_TYPE | A value of the Link Type custom list. | varchar | 60 | | |||
| LN_LINK_COMMENT | The link description. | varchar | 255 | | |||
| LN_VTS | The version time stamp. | varchar | 20 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| INX_LINK_ENTITY_TYPE_ID | | ||
| LN_CREATION_DATE_IDX | |||
| LN_PRIMARYKEY | | | |
| LN_VTS_IDX |
See Also
Related Objects
