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 |