invoice table and indexes

CREATE TABLE invoice
    (
      id integer NOT NULL,
      company_id integer,
      fee_type_id integer,
      user_id integer,
      opportunity_id integer,
      group_by_id integer,
      status_id integer,
      updated_by_id integer,
      created_by_id integer,
      title character varying(60) DEFAULT NULL::character varying,
      show_on_portal boolean,
      taxable boolean,
      description text,
      revision_req text,
      bill_note text,
      bill 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,
      invoiced timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
      invoiced_by_id integer,
      rate numeric(10,2) DEFAULT NULL::numeric,
      estimated_minutes integer,
      department_id integer,
      CONSTRAINT invoice_pkey PRIMARY KEY (id ),
      CONSTRAINT fk_9065174426fa54cf FOREIGN KEY (fee_type_id)
          REFERENCES invoice_fee_type (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_90651744318da063 FOREIGN KEY (invoiced_by_id)
          REFERENCES fos_user (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_906517446bf700bd FOREIGN KEY (status_id)
          REFERENCES invoice_status (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_90651744896dbbde FOREIGN KEY (updated_by_id)
          REFERENCES fos_user (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_90651744979b1ad6 FOREIGN KEY (company_id)
          REFERENCES company (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_906517449a34590f FOREIGN KEY (opportunity_id)
          REFERENCES opportunity (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_90651744a76ed395 FOREIGN KEY (user_id)
          REFERENCES fos_user (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_90651744ae80f5df FOREIGN KEY (department_id)
          REFERENCES department (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_90651744b03a8386 FOREIGN KEY (created_by_id)
          REFERENCES fos_user (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT fk_90651744facb0b63 FOREIGN KEY (group_by_id)
          REFERENCES invoice_group_by (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION
    )
    WITH (
      OIDS=FALSE
    );
    ALTER TABLE invoice
      OWNER TO sd4;
    COMMENT ON COLUMN invoice.search IS '(DC2Type:tsvector)';


    -- Index: idx_9065174426fa54cf

    -- DROP INDEX idx_9065174426fa54cf;

    CREATE INDEX idx_9065174426fa54cf
      ON invoice
      USING btree
      (fee_type_id );

    -- Index: idx_906517442b36786b

    -- DROP INDEX idx_906517442b36786b;

    CREATE INDEX idx_906517442b36786b
      ON invoice
      USING btree
      (title COLLATE pg_catalog."default" );

    -- Index: idx_90651744318da063

    -- DROP INDEX idx_90651744318da063;

    CREATE INDEX idx_90651744318da063
      ON invoice
      USING btree
      (invoiced_by_id );

    -- Index: idx_906517446bf700bd

    -- DROP INDEX idx_906517446bf700bd;

    CREATE INDEX idx_906517446bf700bd
      ON invoice
      USING btree
      (status_id );

    -- Index: idx_906517447a2119e3

    -- DROP INDEX idx_906517447a2119e3;

    CREATE INDEX idx_906517447a2119e3
      ON invoice
      USING btree
      (bill );

    -- Index: idx_90651744896dbbde

    -- DROP INDEX idx_90651744896dbbde;

    CREATE INDEX idx_90651744896dbbde
      ON invoice
      USING btree
      (updated_by_id );

    -- Index: idx_90651744979b1ad6

    -- DROP INDEX idx_90651744979b1ad6;

    CREATE INDEX idx_90651744979b1ad6
      ON invoice
      USING btree
      (company_id );

    -- Index: idx_906517449a34590f

    -- DROP INDEX idx_906517449a34590f;

    CREATE INDEX idx_906517449a34590f
      ON invoice
      USING btree
      (opportunity_id );

    -- Index: idx_90651744a76ed395

    -- DROP INDEX idx_90651744a76ed395;

    CREATE INDEX idx_90651744a76ed395
      ON invoice
      USING btree
      (user_id );

    -- Index: idx_90651744ae80f5df

    -- DROP INDEX idx_90651744ae80f5df;

    CREATE INDEX idx_90651744ae80f5df
      ON invoice
      USING btree
      (department_id );

    -- Index: idx_90651744b03a8386

    -- DROP INDEX idx_90651744b03a8386;

    CREATE INDEX idx_90651744b03a8386
      ON invoice
      USING btree
      (created_by_id );

    -- Index: idx_90651744b23db7b8

    -- DROP INDEX idx_90651744b23db7b8;

    CREATE INDEX idx_90651744b23db7b8
      ON invoice
      USING btree
      (created );

    -- Index: idx_90651744c69b96f7

    -- DROP INDEX idx_90651744c69b96f7;

    CREATE INDEX idx_90651744c69b96f7
      ON invoice
      USING btree
      (updated );

    -- Index: idx_90651744eb3b4e33

    -- DROP INDEX idx_90651744eb3b4e33;

    CREATE INDEX idx_90651744eb3b4e33
      ON invoice
      USING btree
      (deleted );

    -- Index: idx_90651744facb0b63

    -- DROP INDEX idx_90651744facb0b63;

    CREATE INDEX idx_90651744facb0b63
      ON invoice
      USING btree
      (group_by_id );