Relation Table

This table stores the relationships between things in Truxton. This is how the graph of Truxton objects is stored.

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
);