2 CREATE SEQUENCE salesforecast_id_seq
9 CREATE TABLE salesforecast (
10 salesforecast_id INTEGER NOT NULL DEFAULT nextval(('salesforecast_id_seq'::text)::regclass),
11 salesforecast_itemsite_id integer,
12 salesforecast_period_id integer,
14 salesforecast_qty integer,
16 salesforecast_updated_by integer,
18 CONSTRAINT salesforecast_itemsite_id_fkey FOREIGN KEY (salesforecast_itemsite_id)
19 REFERENCES itemsite (itemsite_id) MATCH SIMPLE,
22 CONSTRAINT salesforecast_period_id_fkey FOREIGN KEY (salesforecast_period_id)
23 REFERENCES period (period_id) MATCH SIMPLE,
25 CONSTRAINT salesforecast_updated_by_fkey FOREIGN KEY (salesforecast_updated_by)
26 REFERENCES person (id),
27 CONSTRAINT salesforecast_id_pkey PRIMARY KEY (salesforecast_id)
30 ALTER TABLE salesforecast ADD COLUMN salesforecast_cust_id integer;
31 ALTER TABLE salesforecast ADD COLUMN salesforecast_is_all_buyers BOOLEAN;
32 ALTER TABLE salesforecast ADD COLUMN salesforecast_sum integer;
33 ALTER TABLE salesforecast ADD COLUMN salesforecast_requests integer;
35 ALTER TABLE salesforecast DROP CONSTRAINT salesforecast_cust_id_fkey;
36 -- ALTER TABLE salesforecast ADD CONSTRAINT salesforecast_cust_id_fkey FOREIGN KEY (salesforecast_cust_id)
37 -- REFERENCES custinfo (cust_id) MATCH SIMPLE;
38 DROP INDEX salesforecast_locsite_idx;
39 CREATE UNIQUE INDEX salesforecast_locsite_idx ON salesforecast USING btree (salesforecast_itemsite_id, salesforecast_period_id,salesforecast_cust_id,salesforecast_is_all_buyers);
41 ALTER TABLE public.salesforecast OWNER TO admin;
42 COMMENT ON TABLE salesforecast IS 'Sale Forecast';