Tag Table - Revision history

Sam: /* CategoryID */

2024-01-27T10:03:01Z

CategoryID

Sam at 10:01, 27 January 2024

2024-01-27T10:01:17Z

Sam at 10:00, 27 January 2024

2024-01-27T10:00:54Z

Sam: Created page with "These are the tags that can be used in Truxton. CREATE TABLE "Tag" ( "ID" uuid NOT NULL, "Name" text DEFAULT ''::text NOT NULL, "Description"..."

2023-03-01T22:29:29Z

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"..."

New page

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" text DEFAULT ''::text NOT NULL,
"CategoryID" uuid NOT NULL
);
</source>

@@ Line 25: / Line 25: @@
 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 controlled taxonomy.
+Useful when tagging is being restricted to a [https://en.wikipedia.org/wiki/Controlled_vocabulary controlled taxonomy].

@@ Line 16: / Line 16: @@
 The globally unique identifier of the tag.
-==<code></code>==
+==<code>Name</code>==
-COMMENT ON COLUMN "Tag"."Name" IS 'The human-friendly name of this tag.
+The human-friendly name of this tag.
 ==<code>Description</code>==

@@ Line 1: / Line 1: @@
 These are the tags that can be used in Truxton.
 <source lang="SQL">
 CREATE TABLE "Tag" (
@@ Line 9: / Line 11: @@
 );
 </source>