Table: Link_Group
This table stores information about groups of links to external documents.
Columns
NameTypeConstraintsDescription
link_group_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
table_information_KEYintNOT NULLDefines the type of Practice information that this group aggregates links for
row_KEYintNOT NULLThe primary key to the Practice item that this group aggregates links for.
descriptionnvarchar (260)NOT NULLThe user-configurable name of this group
sortintNOT NULLThe order in which this group will be displayed
update__staff_KEYintNOT NULL
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Link_Group$link_group_KEYlink_group_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Link_Group$row_KEY$table_information_KEY$descriptionrow_KEY, table_information_KEY, descriptionEach description of a link group for a particular Practice item must be unique.
Indexes
NameColumnsDescription
IX_Link_Group$table_information_KEYtable_information_KEYIndex supports foreign key FK_Link_Group__Table_Information__table_information_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Link_Group__Table_Information__table_information_KEYtable_information_KEYTable_Information
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Link__Link_Group__link_group_KEYlink_group_KEYLink

Schema diagram