\p CREATE TABLE Vente
CREATE CACHED TABLE "Vente"
  ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL
  , produit INTEGER NOT NULL
  , quantité DECIMAL(100,3) DEFAULT 1.000 NOT NULL
  , panier INTEGER NOT NULL
  , CONSTRAINT "Vente_PK" PRIMARY KEY(ID)
  );
ALTER TABLE "Vente"
  ADD CONSTRAINT "FK_Vente_produit" FOREIGN KEY(produit) REFERENCES "Produit"(ID)
  ON UPDATE CASCADE;
ALTER TABLE "Vente"
  ADD CONSTRAINT "FK_Vente_panier" FOREIGN KEY(panier) REFERENCES "Panier"(ID)
  ON UPDATE CASCADE;
