create table inventory
(
  part_number		varchar(25)   PRIMARY KEY,
  description 		varchar(100)  NOT NULL,
  actual_qty		float4 NOT NULL DEFAULT 0.0,
  reserved_qty		float4 NOT NULL DEFAULT 0.0,
  nonusable_qty		float4 NOT NULL DEFAULT 0.0,
  available_qty		float4 NOT NULL DEFAULT 0.0,
  reorder_qty		float4 NOT NULL DEFAULT 0.0,
  reorder_point		float4 NOT NULL DEFAULT 0.0,
  qty_unit		int4 REFERENCES unit_description
);

grant select,insert,update,delete on inventory to group inventory;
