CREATE TABLE manufacturers
(
  manufacturer_id integer NOT NULL DEFAULT nextval('inventory_manufacturers_manufacturer_id_seq'::regclass),
  manufacturer_uuid uuid NOT NULL DEFAULT uuid_generate_v4(),
  supplier_id integer NOT NULL DEFAULT 0,
  name character varying(32),
  title character varying(32),
  display_sale_price smallest NOT NULL DEFAULT 0
  discount_rate smallest NOT NULL DEFAULT 0
  is_active smallest NOT NULL DEFAULT 0
  timestamp_created timestamp with time zone NOT NULL DEFAULT now(),
  timestamp_modified timestamp with time zone NOT NULL DEFAULT now()
)
WITH (
  OIDS=FALSE
);