Advertisement
Guest User

Untitled

a guest
Jan 17th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. CREATE SEQUENCE "vueReservationExterne_idReservationExterne_seq"
  2. INCREMENT 1
  3. MINVALUE 1
  4. MAXVALUE 9223372036854775807
  5. START 1
  6. CACHE 1;
  7.  
  8. CREATE TABLE "vueReservationExterne"
  9. (
  10. "idReservationExterne" integer NOT NULL DEFAULT nextval('"vueReservationExterne_idReservationExterne_seq"'::regclass),
  11. "idUtilisateur" integer NOT NULL,
  12. "idSeance" integer NOT NULL,
  13. CONSTRAINT "vueReservationExterne_pkey" PRIMARY KEY ("idReservationExterne"),
  14. CONSTRAINT vuereservationhist_idseance_foreign FOREIGN KEY ("idSeance")
  15. REFERENCES "vueSeance" ("idSeance") MATCH SIMPLE
  16. ON UPDATE NO ACTION ON DELETE CASCADE
  17. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement