sql/init/Panier.sql

   1 \p CREATE TABLE Panier
   2 CREATE CACHED TABLE "Panier"
   3   ( ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL
   4   , date DATE DEFAULT CURRENT_DATE NOT NULL
   5   , client INTEGER NOT NULL
   6   , facture INTEGER
   7   , CONSTRAINT "PK_Panier" PRIMARY KEY(ID)
   8   , CONSTRAINT "FK_Panier_facture"
   9       FOREIGN KEY(facture)
  10       REFERENCES "Facture"(ID)
  11       ON UPDATE CASCADE
  12   , CONSTRAINT "FK_Panier_client"
  13       FOREIGN KEY(client)
  14       REFERENCES "Client"(ID)
  15       ON UPDATE CASCADE
  16   );