Posted via ActualForum NNTP Server 1.5

CREATE TABLE "map"
(
    "tmstmp"    TMSTMP NOT NULL,
    "id"        ID NOT NULL,
    "class_id"  ID NOT NULL,
    "node_id"   ID DEFAULT NULL,
  CONSTRAINT "map__pk" PRIMARY KEY ("id"),
  CONSTRAINT "map__uq" UNIQUE ("node_id", "class_id"),
  CONSTRAINT "map__fk__node_id" FOREIGN KEY ("node_id")
    REFERENCES "map_uuid" ("map_id") ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT "map__fk__class_id" FOREIGN KEY ("class_id")
    REFERENCES "classes" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
);

CREATE TABLE "map_seq"
(
    "tmstmp"  TMSTMP NOT NULL,
    "seq_id"  ID NOT NULL,
    "map_id"  ID NOT NULL,
    "order"   SMALLINT NOT NULL,
  CONSTRAINT "map_seq__pk" PRIMARY KEY ("seq_id"),
  CONSTRAINT "map_seq__uq" UNIQUE ("map_id", "order"),
  CONSTRAINT "map_seq__fk__map" FOREIGN KEY ("map_id")
    REFERENCES "map" ("id") ON UPDATE CASCADE ON DELETE CASCADE
);