Relation Table

From truxwiki.com
Revision as of 15:12, 21 May 2020 by Sam (talk | contribs) (Created page with "This table stores the relationships between things in Truxton. <syntaxhighlight lang="SQL"> CREATE TABLE "Relation" ( "A_ID" uuid NOT NULL, "B_ID" uuid NOT NULL,...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This table stores the relationships between things in Truxton.

CREATE TABLE "Relation" (
    "A_ID" uuid NOT NULL,
    "B_ID" uuid NOT NULL,
    "A_ObjectTypeID" smallint NOT NULL,
    "B_ObjectTypeID" smallint NOT NULL,
    "RelationTypeID" integer NOT NULL,
    "SourceID" uuid NOT NULL,
    "SourceObjectTypeID" smallint NOT NULL
);