-- Table: "ActivityHashTag"

-- DROP TABLE "ActivityHashTag";

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

-- Index: "IX_ActivityHashTag_sphereId_activityId"

-- DROP INDEX "IX_ActivityHashTag_sphereId_activityId";

CREATE INDEX "IX_ActivityHashTag_sphereId_activityId"
  ON "ActivityHashTag"
  USING btree
  ("sphereId", "activityId");