[sql] toto
Viewer
- CREATE TABLE pays (
- code CHAR (2) NOT NULL PRIMARY KEY ,
- nom VARCHAR (50) NOT NULL );
- CREATE TABLE ville (
- id INTEGER NOT NULL PRIMARY KEY ,
- nom VARCHAR (50) NOT NULL,
- codePays CHAR (2) NOT NULL REFERENCES pays );
- CREATE TABLE voyage (
- id INTEGER NOT NULL PRIMARY KEY,
- nom CHARACTER VARYING(30),
- typeVoyage CHARACTER CHAR (2) NOT NULL,
- prix DECIMAL NOT NULL );
- CREATE TABLE etape (
- idVoyage INTEGER NOT NULL REFERENCES voyage,
- idVille INTEGER NOT NULL REFERENCES ville,
- numOrdre INTEGER NOT NULL,
- duree INTEGER NOT NULL,
- CONSTRAINT cle_etape PRIMARY KEY (IdVoyage, numOrdre) );
- CREATE TABLE client (
- id INTEGER NOT NULL PRIMARY KEY,
- nom CHARACTER VARYING(30),
- prenom CHARACTER VARYING(30),
- adresse CHARACTER VARYING(30),
- email CHARACTER VARYING(30),
- pays CHAR (2) NOT NULL REFERENCES pays );
- CREATE TABLE reservation (
- id INTEGER NOT NULL PRIMARY KEY,
- nomVoyageur CHARACTER VARYING(30),
- prenomVoyageur CHARACTER VARYING(30),
- idVoyage INTEGER REFERENCES voyage,
- dateDepart DATE NOT NULL,
- dateReservation DATE NOT NULL,
- idClient INTEGER REFERENCES client);
- CREATE TABLE depart (
- idVoyage INTEGER NOT NULL REFERENCES Voyage,
- dateDepart DATE NOT NULL,
- capacite INTEGER NOT NULL,
- CONSTRAINT cle_depart PRIMARY KEY (IdVoyage, DateDepart) );
Editor
You can edit this paste and save as new: