Tag Table

These are the tags that can be used in Truxton. This reference table maps tag globally unique identifiers to human-friendly text.

SQL

CREATE TABLE "Tag" (
    "ID" uuid NOT NULL,
    "Name" text DEFAULT ''::text NOT NULL,
    "Description" text DEFAULT ''::text NOT NULL,
    "CategoryID" uuid NOT NULL
);

Columns

ID

The globally unique identifier of the tag.

Name

The human-friendly name of this tag.

Description

An explanation of this tag.

CategoryID

The identifier of the category this tag belongs to. It corresponds to the ID column of the [TagCategory] table. Useful when tagging is being restricted to a controlled taxonomy.