task table and statuses

CREATE TABLE task
    (
      id integer NOT NULL,
      invoice_id integer,
      contact_id integer,
      department_id integer,
      project_id integer,
      contract_id integer,
      type_id integer,
      priority_id integer,
      user_id integer,
      status_id integer,
      revision_approval_id integer,
      updated_by_id integer,
      created_by_id integer,
      title character varying(300) DEFAULT NULL::character varying,
      description text,
      due timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
      off_hold timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
      off_hold_description text,
      points integer,
      projected_minutes integer,
      quoted_minutes integer,
      revised_quoted_minutes integer,
      revised_rate numeric(10,2) DEFAULT NULL::numeric,
      rate numeric(10,2) DEFAULT NULL::numeric,
      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,
      on_hold boolean,
      CONSTRAINT task_pkey PRIMARY KEY (id ),
      CONSTRAINT fk_527edb25166d1f9c FOREIGN KEY (project_id)
          REFERENCES project (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb252576e0fd FOREIGN KEY (contract_id)
          REFERENCES contract (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb252989f1fd FOREIGN KEY (invoice_id)
          REFERENCES invoice (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb25497b19f9 FOREIGN KEY (priority_id)
          REFERENCES priority (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb256bf700bd FOREIGN KEY (status_id)
          REFERENCES task_status (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb25896dbbde FOREIGN KEY (updated_by_id)
          REFERENCES fos_user (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb25a76ed395 FOREIGN KEY (user_id)
          REFERENCES fos_user (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb25ae80f5df FOREIGN KEY (department_id)
          REFERENCES department (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb25b03a8386 FOREIGN KEY (created_by_id)
          REFERENCES fos_user (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb25bd2b6666 FOREIGN KEY (revision_approval_id)
          REFERENCES contact (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb25c54c8c93 FOREIGN KEY (type_id)
          REFERENCES task_type (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_527edb25e7a1254a FOREIGN KEY (contact_id)
          REFERENCES contact (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION
    )
    WITH (
      OIDS=FALSE
    );
    ALTER TABLE task
      OWNER TO sd4;
    COMMENT ON COLUMN task.search IS '(DC2Type:tsvector)';


    -- Index: idx_527edb25166d1f9c

    -- DROP INDEX idx_527edb25166d1f9c;

    CREATE INDEX idx_527edb25166d1f9c
      ON task
      USING btree
      (project_id );

    -- Index: idx_527edb252576e0fd

    -- DROP INDEX idx_527edb252576e0fd;

    CREATE INDEX idx_527edb252576e0fd
      ON task
      USING btree
      (contract_id );

    -- Index: idx_527edb2527ba8e29

    -- DROP INDEX idx_527edb2527ba8e29;

    CREATE INDEX idx_527edb2527ba8e29
      ON task
      USING btree
      (points );

    -- Index: idx_527edb252989f1fd

    -- DROP INDEX idx_527edb252989f1fd;

    CREATE INDEX idx_527edb252989f1fd
      ON task
      USING btree
      (invoice_id );

    -- Index: idx_527edb252989f1fda76ed3956bf700bd497b19f9

    -- DROP INDEX idx_527edb252989f1fda76ed3956bf700bd497b19f9;

    CREATE INDEX idx_527edb252989f1fda76ed3956bf700bd497b19f9
      ON task
      USING btree
      (invoice_id , user_id , status_id , priority_id );

    -- Index: idx_527edb252b36786b

    -- DROP INDEX idx_527edb252b36786b;

    CREATE INDEX idx_527edb252b36786b
      ON task
      USING btree
      (title COLLATE pg_catalog."default" );

    -- Index: idx_527edb25386ae797

    -- DROP INDEX idx_527edb25386ae797;

    CREATE INDEX idx_527edb25386ae797
      ON task
      USING btree
      (projected_minutes );

    -- Index: idx_527edb25497b19f9

    -- DROP INDEX idx_527edb25497b19f9;

    CREATE INDEX idx_527edb25497b19f9
      ON task
      USING btree
      (priority_id );

    -- Index: idx_527edb256bf700bd

    -- DROP INDEX idx_527edb256bf700bd;

    CREATE INDEX idx_527edb256bf700bd
      ON task
      USING btree
      (status_id );

    -- Index: idx_527edb25896dbbde

    -- DROP INDEX idx_527edb25896dbbde;

    CREATE INDEX idx_527edb25896dbbde
      ON task
      USING btree
      (updated_by_id );

    -- Index: idx_527edb25927d5d40

    -- DROP INDEX idx_527edb25927d5d40;

    CREATE INDEX idx_527edb25927d5d40
      ON task
      USING btree
      (quoted_minutes );

    -- Index: idx_527edb25a76ed395

    -- DROP INDEX idx_527edb25a76ed395;

    CREATE INDEX idx_527edb25a76ed395
      ON task
      USING btree
      (user_id );

    -- Index: idx_527edb25ae80f5df

    -- DROP INDEX idx_527edb25ae80f5df;

    CREATE INDEX idx_527edb25ae80f5df
      ON task
      USING btree
      (department_id );

    -- Index: idx_527edb25b03a8386

    -- DROP INDEX idx_527edb25b03a8386;

    CREATE INDEX idx_527edb25b03a8386
      ON task
      USING btree
      (created_by_id );

    -- Index: idx_527edb25b23db7b8

    -- DROP INDEX idx_527edb25b23db7b8;

    CREATE INDEX idx_527edb25b23db7b8
      ON task
      USING btree
      (created );

    -- Index: idx_527edb25b56f211c

    -- DROP INDEX idx_527edb25b56f211c;

    CREATE INDEX idx_527edb25b56f211c
      ON task
      USING btree
      (revised_rate );

    -- Index: idx_527edb25bd2b6666

    -- DROP INDEX idx_527edb25bd2b6666;

    CREATE INDEX idx_527edb25bd2b6666
      ON task
      USING btree
      (revision_approval_id );

    -- Index: idx_527edb25c54c8c93

    -- DROP INDEX idx_527edb25c54c8c93;

    CREATE INDEX idx_527edb25c54c8c93
      ON task
      USING btree
      (type_id );

    -- Index: idx_527edb25c69b96f7

    -- DROP INDEX idx_527edb25c69b96f7;

    CREATE INDEX idx_527edb25c69b96f7
      ON task
      USING btree
      (updated );

    -- Index: idx_527edb25deef72e7

    -- DROP INDEX idx_527edb25deef72e7;

    CREATE INDEX idx_527edb25deef72e7
      ON task
      USING btree
      (off_hold );

    -- Index: idx_527edb25df0fa28a

    -- DROP INDEX idx_527edb25df0fa28a;

    CREATE INDEX idx_527edb25df0fa28a
      ON task
      USING btree
      (due );

    -- Index: idx_527edb25df0fa28a27ba8e292b36786bb23db7b8

    -- DROP INDEX idx_527edb25df0fa28a27ba8e292b36786bb23db7b8;

    CREATE INDEX idx_527edb25df0fa28a27ba8e292b36786bb23db7b8
      ON task
      USING btree
      (due , points , title COLLATE pg_catalog."default" , created );

    -- Index: idx_527edb25dfec3f39

    -- DROP INDEX idx_527edb25dfec3f39;

    CREATE INDEX idx_527edb25dfec3f39
      ON task
      USING btree
      (rate );

    -- Index: idx_527edb25e7a1254a

    -- DROP INDEX idx_527edb25e7a1254a;

    CREATE INDEX idx_527edb25e7a1254a
      ON task
      USING btree
      (contact_id );

    -- Index: idx_527edb25eb3b4e33

    -- DROP INDEX idx_527edb25eb3b4e33;

    CREATE INDEX idx_527edb25eb3b4e33
      ON task
      USING btree
      (deleted );