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