Table: Link
This table stores information about links to external documents.
Columns
Name | Type | Constraints | Description
link_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key of this table
link_group_KEY | int | NOT NULL | Parent group of this link
description | nvarchar (260) | NOT NULL | User-configurable name of this link
sort | int | NOT NULL | A value indicating what order to sort items in
link_type_KEY | int | NOT NULL | Type of link this is
target | nvarchar (2048) | NOT NULL | The information used to resolve the link. Depending on the link_type_KEY, this column can store a file system location, an URI, a GoFileRoom document ID, a FileCabinet item ID, etc.
comment | nvarchar (-1) | NOT NULL | Optional reason why this link was created
create_machine_name | nvarchar (50) | NOT NULL | Machine name of the machine on which this link was created
create__staff_KEY | int | NOT NULL | Key of Staff who created this row.
create_date | datetime | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |

Primary key
Name | Columns | Description
PK_Link$link_KEY | link_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Link__link_group_KEY__description | link_group_KEY, description | Each link in a particular link group must have an unique description.
Indexes
Name | Columns | Description
IX_Link$link_type_KEY | link_type_KEY | Index supports foreign key FK_Link__Link_Type__link_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Link__Link_Group__link_group_KEY | link_group_KEY | Link_Group |
FK_Link__Link_Type__link_type_KEY | link_type_KEY | Link_Type |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Interaction_Link__Link__link_KEY | link_KEY | Interaction_Link |