File: create_inventory.sql

package info (click to toggle)
gnue-forms 0.5.11-2
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 3,384 kB
  • ctags: 1,577
  • sloc: python: 12,904; sql: 579; makefile: 28
file content (14 lines) | stat: -rw-r--r-- 493 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
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;