Table: Tag
A tag is a non-hierarchical keyword or term assigned to a piece of information. This kind of metadata helps describe an item and allows it to be found again by browsing or searching. Tags are generally chosen informally and personally by the item's creator or by its viewer.
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
tag_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Key that represents a tag.
description | nvarchar (250) | NOT NULL | The tag text.

Primary key
Name | Columns | Description
PK_Tag$tag_KEY | tag_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Tag$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tagged_Item__Tag__tag_KEY | tag_KEY | Tagged_Item | on delete cascade;