-- Table: "ActivityCuratedPost"

-- DROP TABLE "ActivityCuratedPost";

CREATE TABLE "ActivityCuratedPost"
(
  "activityId" bigint NOT NULL,
  "pageTemplateName" text,
  "pageTemplateId" bigint,
  "tagId" bigint,
  "sphereId" bigint,
  "modifiedDate" timestamp without time zone,
  "createdDate" timestamp without time zone,
  CONSTRAINT "ActivityCuratedPost_pkey" PRIMARY KEY ("activityId"),
  CONSTRAINT "FK_ActivityCuratedPost_Activity_activityId" FOREIGN KEY ("activityId")
      REFERENCES "Activity" ("activityId") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "ActivityCuratedPost"
  OWNER TO postgres;

-- Index: "IX_ActivityCuratedPost_activityId"

-- DROP INDEX "IX_ActivityCuratedPost_activityId";

CREATE INDEX "IX_ActivityCuratedPost_activityId"
  ON "ActivityCuratedPost"
  USING btree
  ("activityId");