\p CREATE TABLE Stock CREATE CACHED TABLE "Stock" ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL , lieu INTEGER NOT NULL , produit INTEGER NOT NULL , quantité DECIMAL(100,3) DEFAULT 1.000 NOT NULL , CONSTRAINT "Stock_PK" PRIMARY KEY(ID) ); ALTER TABLE "Stock" ADD CONSTRAINT "Stock_lieu_FK" FOREIGN KEY(lieu) REFERENCES "Lieu"(ID) ON UPDATE CASCADE; ALTER TABLE "Stock" ADD CONSTRAINT "Stock_produit_FK" FOREIGN KEY(produit) REFERENCES "Produit"(ID) ON UPDATE CASCADE;