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
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
tag_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Key that represents a tag.
descriptionnvarchar (250)NOT NULLThe tag text.
Primary key
NameColumnsDescription
PK_Tag$tag_KEYtag_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Tag$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tagged_Item__Tag__tag_KEYtag_KEYTagged_Itemon delete cascade;

Schema diagram