task step table

CREATE TABLE task_step
(
  id integer NOT NULL,
  user_id integer,
  updated_by_id integer,
  created_by_id integer,
  description text NOT NULL,
  completed timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  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_step_pkey PRIMARY KEY (id ),
  CONSTRAINT fk_300a6a47896dbbde FOREIGN KEY (updated_by_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_300a6a478db60186 FOREIGN KEY (task_id)
      REFERENCES task (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_300a6a47a76ed395 FOREIGN KEY (user_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_300a6a47b03a8386 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_step
  OWNER TO sd4;
COMMENT ON COLUMN task_step.search IS '(DC2Type:tsvector)';


-- Index: idx_300a6a473af85c6e

-- DROP INDEX idx_300a6a473af85c6e;

CREATE INDEX idx_300a6a473af85c6e
  ON task_step
  USING btree
  (completed );

-- Index: idx_300a6a47896dbbde

-- DROP INDEX idx_300a6a47896dbbde;

CREATE INDEX idx_300a6a47896dbbde
  ON task_step
  USING btree
  (updated_by_id );

-- Index: idx_300a6a478db60186

-- DROP INDEX idx_300a6a478db60186;

CREATE INDEX idx_300a6a478db60186
  ON task_step
  USING btree
  (task_id );

-- Index: idx_300a6a47a76ed395

-- DROP INDEX idx_300a6a47a76ed395;

CREATE INDEX idx_300a6a47a76ed395
  ON task_step
  USING btree
  (user_id );

-- Index: idx_300a6a47b03a8386

-- DROP INDEX idx_300a6a47b03a8386;

CREATE INDEX idx_300a6a47b03a8386
  ON task_step
  USING btree
  (created_by_id );

-- Index: idx_300a6a47b23db7b8

-- DROP INDEX idx_300a6a47b23db7b8;

CREATE INDEX idx_300a6a47b23db7b8
  ON task_step
  USING btree
  (created );

-- Index: idx_300a6a47c69b96f7

-- DROP INDEX idx_300a6a47c69b96f7;

CREATE INDEX idx_300a6a47c69b96f7
  ON task_step
  USING btree
  (updated );

-- Index: idx_300a6a47eb3b4e33

-- DROP INDEX idx_300a6a47eb3b4e33;

CREATE INDEX idx_300a6a47eb3b4e33
  ON task_step
  USING btree
  (deleted );