PythonPostgresLab/SQL/plpgsql/create_stock_table.sql

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;