\p CREATE TABLE Client
CREATE CACHED TABLE "Client"
  ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL
  , nom VARCHAR(100) NOT NULL
  , lieu INTEGER NOT NULL
  , tél VARCHAR(100)
  , mél VARCHAR(100)
  , CONSTRAINT "PK_Client" PRIMARY KEY(ID)
  );
ALTER TABLE "Client"
  ADD CONSTRAINT "FK_Client_lieu" FOREIGN KEY(lieu) REFERENCES "Lieu"(ID)
  ON UPDATE CASCADE;