Table: Link
This table stores information about links to external documents.
Columns
NameTypeConstraintsDescription
link_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key of this table
link_group_KEYintNOT NULLParent group of this link
descriptionnvarchar (260)NOT NULLUser-configurable name of this link
sortintNOT NULLA value indicating what order to sort items in
link_type_KEYintNOT NULLType of link this is
targetnvarchar (2048)NOT NULLThe 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.
commentnvarchar (-1)NOT NULLOptional reason why this link was created
create_machine_namenvarchar (50)NOT NULLMachine name of the machine on which this link was created
create__staff_KEYintNOT NULLKey of Staff who created this row.
update__staff_KEYintNOT NULL
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Link$link_KEYlink_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Link$link_group_KEY$descriptionlink_group_KEY, descriptionEach link in a particular link group must have an unique description.
Indexes
NameColumnsDescription
IX_Link$link_type_KEYlink_type_KEYIndex supports foreign key FK_Link__Link_Type__link_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Link__Link_Group__link_group_KEYlink_group_KEYLink_Group
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Interaction_Link__Link__link_KEYlink_KEYInteraction_Link

Schema diagram