Table: Tagged_Item
Associates Tags to an item.
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
row_KEYintNOT NULLWhich row in that table indicated by [table_information_KEY].
table_information_KEYintNOT NULLWhich table is the row indicated by [row_KEY] in.
tag_KEYintNOT NULLWhich tag is associated.
tagged_item_sortintNOT NULLThe sort order of the tags on a particular item.
Primary key
NameColumnsDescription
PK_Tagged_Item$row_KEY$table_information_KEY$tag_KEYrow_KEY, table_information_KEY, tag_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Tagged_Item$table_information_KEYtable_information_KEYIndex supports foreign key FK_Tagged_Item__Table_Information__table_information_KEY
IX_Tagged_Item$tag_KEYtag_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tagged_Item__Table_Information__table_information_KEYtable_information_KEYTable_Information
FK_Tagged_Item__Tag__tag_KEYtag_KEYTagon delete cascade;

Schema diagram