task comment table

CREATE TABLE task_comment
(
  id integer NOT NULL,
  updated_by_id integer,
  created_by_id integer,
  comment text NOT NULL,
  search tsvector, -- (DC2Type:tsvector)
  updated timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  created timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  deleted timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  task_id integer,
  CONSTRAINT task_comment_pkey PRIMARY KEY (id ),
  CONSTRAINT fk_8b957886896dbbde FOREIGN KEY (updated_by_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_8b9578868db60186 FOREIGN KEY (task_id)
      REFERENCES task (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_8b957886b03a8386 FOREIGN KEY (created_by_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE task_comment
  OWNER TO sd4;
COMMENT ON COLUMN task_comment.search IS '(DC2Type:tsvector)';


-- Index: idx_8b957886896dbbde

-- DROP INDEX idx_8b957886896dbbde;

CREATE INDEX idx_8b957886896dbbde
  ON task_comment
  USING btree
  (updated_by_id );

-- Index: idx_8b9578868db60186

-- DROP INDEX idx_8b9578868db60186;

CREATE INDEX idx_8b9578868db60186
  ON task_comment
  USING btree
  (task_id );

-- Index: idx_8b9578869474526c

-- DROP INDEX idx_8b9578869474526c;

CREATE INDEX idx_8b9578869474526c
  ON task_comment
  USING btree
  (comment COLLATE pg_catalog."default" );

-- Index: idx_8b957886b03a8386

-- DROP INDEX idx_8b957886b03a8386;

CREATE INDEX idx_8b957886b03a8386
  ON task_comment
  USING btree
  (created_by_id );

-- Index: idx_8b957886b23db7b8

-- DROP INDEX idx_8b957886b23db7b8;

CREATE INDEX idx_8b957886b23db7b8
  ON task_comment
  USING btree
  (created );

-- Index: idx_8b957886c69b96f7

-- DROP INDEX idx_8b957886c69b96f7;

CREATE INDEX idx_8b957886c69b96f7
  ON task_comment
  USING btree
  (updated );

-- Index: idx_8b957886eb3b4e33

-- DROP INDEX idx_8b957886eb3b4e33;

CREATE INDEX idx_8b957886eb3b4e33
  ON task_comment
  USING btree
  (deleted );