CREATE SEQUENCE public.stock_sto_id_seq; CREATE TABLE public.Stock ( Sto_id INTEGER NOT NULL DEFAULT nextval('public.stock_sto_id_seq'), Sto_quantity INTEGER NOT NULL DEFAULT 0, Pro_id INTEGER NOT NULL, War_id INTEGER NOT NULL, CONSTRAINT stock_pk PRIMARY KEY (Sto_id) ); COMMENT ON TABLE public.Stock IS 'Inventory of products.'; ALTER SEQUENCE public.stock_sto_id_seq OWNED BY public.Stock.Sto_id; ALTER TABLE public.Stock ADD CONSTRAINT stock_product_fk FOREIGN KEY (Pro_id) REFERENCES public.Product (Pro_id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE; ALTER TABLE public.Stock ADD CONSTRAINT stock_warehouse_fk FOREIGN KEY (War_id) REFERENCES public.Warehouse (War_id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE;