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; |