Difference between revisions of "Tag Table"
Jump to navigation
Jump to search
| Line 25: | Line 25: | ||
The identifier of the category this tag belongs to. | The identifier of the category this tag belongs to. | ||
It corresponds to the <code>ID</code> column of the <code>[TagCategory]</code> table. | It corresponds to the <code>ID</code> column of the <code>[TagCategory]</code> table. | ||
| − | Useful when tagging is being restricted to a controlled taxonomy. | + | Useful when tagging is being restricted to a [https://en.wikipedia.org/wiki/Controlled_vocabulary controlled taxonomy]. |
Latest revision as of 06:03, 27 January 2024
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.
