| Project Data Tables Database > td Schema : td.LINK Table | 
| 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 | ![]()  | 
| Index | Description | Primary | Unique | 
|---|---|---|---|
| INX_LINK_ENTITY_TYPE_ID | ![]()  | ||
| LN_CREATION_DATE_IDX | |||
| LN_PRIMARYKEY | ![]()  | ![]()  | |
| LN_VTS_IDX |