CREATE TABLE product_uom
(
  id serial NOT NULL,
  create_uid integer,
  create_date timestamp without time zone,
  write_date timestamp without time zone,
  write_uid integer,
  uom_type character varying NOT NULL, -- UoM Type
  category_id integer NOT NULL, -- UoM Category
  name character varying(64) NOT NULL, -- Name
  rounding numeric NOT NULL, -- Rounding Precision
  factor numeric NOT NULL, -- Ratio
  active boolean, -- Active
  CONSTRAINT product_uom_pkey PRIMARY KEY (id),
  CONSTRAINT product_uom_category_id_fkey FOREIGN KEY (category_id)
      REFERENCES product_uom_categ (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE,
  CONSTRAINT product_uom_create_uid_fkey FOREIGN KEY (create_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT product_uom_write_uid_fkey FOREIGN KEY (write_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT product_uom_factor_gt_zero CHECK (factor <> 0::numeric)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE product_uom
  OWNER TO openerp;
GRANT ALL ON TABLE product_uom TO openerp;
GRANT SELECT ON TABLE product_uom TO lectura;
GRANT SELECT ON TABLE product_uom TO esb_msp;
GRANT SELECT ON TABLE product_uom TO consulta;
GRANT ALL ON TABLE product_uom TO inven_lectu;
GRANT SELECT ON TABLE product_uom TO "wladimir.quijije";
GRANT SELECT ON TABLE product_uom TO "diego.molina";
GRANT SELECT ON TABLE product_uom TO "fausto.suarez";
COMMENT ON TABLE product_uom
  IS 'Product Unit of Measure';
COMMENT ON COLUMN product_uom.uom_type IS 'UoM Type';
COMMENT ON COLUMN product_uom.category_id IS 'UoM Category';
COMMENT ON COLUMN product_uom.name IS 'Name';
COMMENT ON COLUMN product_uom.rounding IS 'Rounding Precision';
COMMENT ON COLUMN product_uom.factor IS 'Ratio';
COMMENT ON COLUMN product_uom.active IS 'Active';


-- Index: sgi_factor

-- DROP INDEX sgi_factor;

CREATE INDEX sgi_factor
  ON product_uom
  USING btree
  (factor);