-- Table: "ActivitySurvey"

-- DROP TABLE "ActivitySurvey";

CREATE TABLE "ActivitySurvey"
(
  "activityId" bigint NOT NULL,
  "createdDate" timestamp without time zone,
  "modifiedDate" timestamp without time zone,
  "sphereId" bigint,
  "activitySurveyId" bigserial NOT NULL,
  "surveyId" bigint,
  CONSTRAINT "ActivitySurvey_pkey" PRIMARY KEY ("activitySurveyId"),
  CONSTRAINT "FK_ActivitySurvey_Activity_activityId" FOREIGN KEY ("activityId")
      REFERENCES "Activity" ("activityId") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "ActivitySurvey"
  OWNER TO postgres;

-- Index: "IX_ActivitySurvey_sphereId_activityId"

-- DROP INDEX "IX_ActivitySurvey_sphereId_activityId";

CREATE INDEX "IX_ActivitySurvey_sphereId_activityId"
  ON "ActivitySurvey"
  USING btree
  ("sphereId", "activityId");