company table and indexes

CREATE TABLE company
    (
      id integer NOT NULL,
      name character varying(100) DEFAULT NULL::character varying,
      bill_note text,
      customer_code character varying(15) DEFAULT NULL::character varying,
      search tsvector, -- (DC2Type:tsvector)
      bad_standing boolean,
      bad_standing_reason text,
      CONSTRAINT company_pkey PRIMARY KEY (id )
    )
    WITH (
      OIDS=FALSE
    );
    ALTER TABLE company
      OWNER TO sd4;
    COMMENT ON COLUMN company.search IS '(DC2Type:tsvector)';


    -- Index: idx_4fbf094f238494ef

    -- DROP INDEX idx_4fbf094f238494ef;

    CREATE INDEX idx_4fbf094f238494ef
      ON company
      USING btree
      (customer_code COLLATE pg_catalog."default" );

    -- Index: idx_4fbf094f5e237e06

    -- DROP INDEX idx_4fbf094f5e237e06;

    CREATE INDEX idx_4fbf094f5e237e06
      ON company
      USING btree
      (name COLLATE pg_catalog."default" );