Difference between revisions of "Tag Table"
Jump to navigation
Jump to search
(Created page with "These are the tags that can be used in Truxton. <source lang="SQL"> CREATE TABLE "Tag" ( "ID" uuid NOT NULL, "Name" text DEFAULT ''::text NOT NULL, "Description"...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
These are the tags that can be used in Truxton. | These are the tags that can be used in Truxton. | ||
| + | This reference table maps tag globally unique identifiers to human-friendly text. | ||
| + | =SQL= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "Tag" ( | CREATE TABLE "Tag" ( | ||
| Line 9: | Line 11: | ||
); | ); | ||
</source> | </source> | ||
| + | |||
| + | =Columns= | ||
| + | ==<code>ID</code>== | ||
| + | The globally unique identifier of the tag. | ||
| + | |||
| + | ==<code>Name</code>== | ||
| + | The human-friendly name of this tag. | ||
| + | |||
| + | ==<code>Description</code>== | ||
| + | An explanation of this tag. | ||
| + | |||
| + | ==<code>CategoryID</code>== | ||
| + | The identifier of the category this tag belongs to. | ||
| + | It corresponds to the <code>ID</code> column of the <code>[TagCategory]</code> table. | ||
| + | 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.
