invoice status table

CREATE TABLE invoice_status
(
  id integer NOT NULL,
  updated_by_id integer,
  created_by_id integer,
  title character varying(100) NOT NULL,
  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,
  CONSTRAINT invoice_status_pkey PRIMARY KEY (id ),
  CONSTRAINT fk_c036f84f896dbbde FOREIGN KEY (updated_by_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_c036f84fb03a8386 FOREIGN KEY (created_by_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE invoice_status
  OWNER TO sd4;
COMMENT ON COLUMN invoice_status.search IS '(DC2Type:tsvector)';


-- Index: idx_c036f84f2b36786b

-- DROP INDEX idx_c036f84f2b36786b;

CREATE INDEX idx_c036f84f2b36786b
  ON invoice_status
  USING btree
  (title COLLATE pg_catalog."default" );

-- Index: idx_c036f84f896dbbde

-- DROP INDEX idx_c036f84f896dbbde;

CREATE INDEX idx_c036f84f896dbbde
  ON invoice_status
  USING btree
  (updated_by_id );

-- Index: idx_c036f84fb03a8386

-- DROP INDEX idx_c036f84fb03a8386;

CREATE INDEX idx_c036f84fb03a8386
  ON invoice_status
  USING btree
  (created_by_id );

-- Index: idx_c036f84fb23db7b8

-- DROP INDEX idx_c036f84fb23db7b8;

CREATE INDEX idx_c036f84fb23db7b8
  ON invoice_status
  USING btree
  (created );

-- Index: idx_c036f84fc69b96f7

-- DROP INDEX idx_c036f84fc69b96f7;

CREATE INDEX idx_c036f84fc69b96f7
  ON invoice_status
  USING btree
  (updated );

-- Index: idx_c036f84feb3b4e33

-- DROP INDEX idx_c036f84feb3b4e33;

CREATE INDEX idx_c036f84feb3b4e33
  ON invoice_status
  USING btree
  (deleted );