-- Table: "ActivityShareArticle"

-- DROP TABLE "ActivityShareArticle";

CREATE TABLE "ActivityShareArticle"
(
  "activityId" bigint NOT NULL,
  "sphereId" bigint,
  "modifiedDate" timestamp without time zone,
  "createdDate" timestamp without time zone,
  "articleId" uuid NOT NULL,
  CONSTRAINT "ActivityShareArticle_pkey" PRIMARY KEY ("activityId"),
  CONSTRAINT "FK_ActivityShareArticle_Activity_activityId" FOREIGN KEY ("activityId")
      REFERENCES "Activity" ("activityId") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "FK_ActivityShareArticle_Article_articleId" FOREIGN KEY ("articleId")
      REFERENCES "Article" ("articleId") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "ActivityShareArticle"
  OWNER TO postgres;

-- Index: "IX_ActivityShareArticle_articleId"

-- DROP INDEX "IX_ActivityShareArticle_articleId";

CREATE INDEX "IX_ActivityShareArticle_articleId"
  ON "ActivityShareArticle"
  USING btree
  ("articleId");