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   , facturable BOOLEAN DEFAULT FALSE NOT NULL
   7   , facture INTEGER
   8   , CONSTRAINT "PK_Panier" PRIMARY KEY(ID)
   9   , CONSTRAINT "FK_Panier_facture"
  10       FOREIGN KEY(facture)
  11       REFERENCES "Facture"(ID)
  12       ON UPDATE CASCADE
  13   , CONSTRAINT "FK_Panier_client"
  14       FOREIGN KEY(client)
  15       REFERENCES "Client"(ID)
  16       ON UPDATE CASCADE
  17   );