Table: Tagged_Item
Associates Tags to an item.
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
row_KEY | int | NOT NULL | Which row in that table indicated by [table_information_KEY].
table_information_KEY | int | NOT NULL | Which table is the row indicated by [row_KEY] in.
tag_KEY | int | NOT NULL | Which tag is associated.
tagged_item_sort | int | NOT NULL | The sort order of the tags on a particular item.

Primary key
Name | Columns | Description
PK_Tagged_Item$row_KEY$table_information_KEY$tag_KEY | row_KEY, table_information_KEY, tag_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Tagged_Item$table_information_KEY | table_information_KEY | Index supports foreign key FK_Tagged_Item__Table_Information__table_information_KEY
IX_Tagged_Item$tag_KEY | tag_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tagged_Item__Table_Information__table_information_KEY | table_information_KEY | Table_Information |
FK_Tagged_Item__Tag__tag_KEY | tag_KEY | Tag | on delete cascade;