task file table

CREATE TABLE task_file
(
  id integer NOT NULL,
  task_id integer,
  user_id integer,
  updated_by_id integer,
  created_by_id integer,
  path text NOT NULL,
  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,
  CONSTRAINT task_file_pkey PRIMARY KEY (id ),
  CONSTRAINT fk_ff2ca26b896dbbde FOREIGN KEY (updated_by_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_ff2ca26b8db60186 FOREIGN KEY (task_id)
      REFERENCES task (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_ff2ca26ba76ed395 FOREIGN KEY (user_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_ff2ca26bb03a8386 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_file
  OWNER TO sd4;

-- Index: idx_ff2ca26b896dbbde

-- DROP INDEX idx_ff2ca26b896dbbde;

CREATE INDEX idx_ff2ca26b896dbbde
  ON task_file
  USING btree
  (updated_by_id );

-- Index: idx_ff2ca26b8db60186

-- DROP INDEX idx_ff2ca26b8db60186;

CREATE INDEX idx_ff2ca26b8db60186
  ON task_file
  USING btree
  (task_id );

-- Index: idx_ff2ca26ba76ed395

-- DROP INDEX idx_ff2ca26ba76ed395;

CREATE INDEX idx_ff2ca26ba76ed395
  ON task_file
  USING btree
  (user_id );

-- Index: idx_ff2ca26bb03a8386

-- DROP INDEX idx_ff2ca26bb03a8386;

CREATE INDEX idx_ff2ca26bb03a8386
  ON task_file
  USING btree
  (created_by_id );

-- Index: idx_ff2ca26bb23db7b8

-- DROP INDEX idx_ff2ca26bb23db7b8;

CREATE INDEX idx_ff2ca26bb23db7b8
  ON task_file
  USING btree
  (created );

-- Index: idx_ff2ca26bb548b0f

-- DROP INDEX idx_ff2ca26bb548b0f;

CREATE INDEX idx_ff2ca26bb548b0f
  ON task_file
  USING btree
  (path COLLATE pg_catalog."default" );

-- Index: idx_ff2ca26bc69b96f7

-- DROP INDEX idx_ff2ca26bc69b96f7;

CREATE INDEX idx_ff2ca26bc69b96f7
  ON task_file
  USING btree
  (updated );

-- Index: idx_ff2ca26beb3b4e33

-- DROP INDEX idx_ff2ca26beb3b4e33;

CREATE INDEX idx_ff2ca26beb3b4e33
  ON task_file
  USING btree
  (deleted );