Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE CLIENT(code INT AUTO_INCREMENT,
- nom VARCHAR(50),
- prenom VARCHAR(50),
- adresse VARCHAR(50),
- ville VARCHAR(50),
- pays VARCHAR(50),
- PRIMARY KEY(code));
- CREATE TABLE ModeEnvoie(code INT AUTO_INCREMENT,
- libelle VARCHAR(50),
- tarif VARCHAR(50),
- PRIMARY KEY(code));
- CREATE TABLE Pays(code INT AUTO_INCREMENT,
- nom VARCHAR(50),
- tarif int,
- PRIMARY KEY(code));
- CREATE TABLE Employes(code INT AUTO_INCREMENT,
- nom VARCHAR(50),
- prenom VARCHAR(50),
- PRIMARY KEY(code));
- CREATE TABLE TypeEmballage(code INT AUTO_INCREMENT,
- libelle VARCHAR(50),
- tarif int,
- PRIMARY KEY(code));
- CREATE TABLE Ville(code INT AUTO_INCREMENT,
- nom VARCHAR(50),
- codePays int,
- PRIMARY KEY(code),
- CONSTRAINT FK_codePays FOREIGN KEY (codePays) REFERENCES Pays(code));
- CREATE TABLE Vol(numero VARCHAR(50),
- codeVilleDepart int,
- codeVilleArrivee int,
- CONSTRAINT FK_codeVilleDepart FOREIGN KEY (codeVilleDepart) REFERENCES Pays(code),
- CONSTRAINT FK_codeVilleArrivee FOREIGN KEY (codeVilleArrivee) REFERENCES Pays(code),
- PRIMARY KEY(numero));
- CREATE TABLE produit(numero VARCHAR(50),
- destinataire VARCHAR(50),
- dateEnregistrement VARCHAR(50),
- codeTypeEmballage int,
- codeModeEnvoie int,
- codeClient int,
- codeVille int,
- codeEmployes int,
- CONSTRAINT FK_codeTypeEmballage FOREIGN KEY (codeTypeEmballage) REFERENCES TypeEmballage(code),
- CONSTRAINT FK_codeModeEnvoie FOREIGN KEY (codeModeEnvoie) REFERENCES ModeEnvoie(code),
- CONSTRAINT FK_codeClient FOREIGN KEY (codeClient) REFERENCES Client(code),
- CONSTRAINT FK_codeVille FOREIGN KEY (codeVille) REFERENCES Ville(code),
- CONSTRAINT FK_codeEmployes FOREIGN KEY (codeEmployes) REFERENCES Employes(code),
- PRIMARY KEY(numero));
- CREATE TABLE Livraison(numero VARCHAR(50),
- dateRdv Date,
- datePassage Date,
- nomRéceptionneur VARCHAR(50),
- etat VARCHAR(50),
- codeVilleDepart int,
- codeVilleArrivee int,
- CONSTRAINT FK_codeVilleDepart FOREIGN KEY (codeVilleDepart) REFERENCES Pays(code),
- CONSTRAINT FK_codeVilleArrivee FOREIGN KEY (codeVilleArrivee) REFERENCES Pays(code),
- PRIMARY KEY(numero));
- CREATE TABLE charger(dateChargement date,
- CODEVOL int,
- CODEEMPLOYES int,
- NUMEROPRODUITS int,
- PRIMARY KEY (CODEVOL, CODEEMPLOYES, NUMEROPRODUITS),
- CONSTRAINT FK_CODEVOL FOREIGN KEY (CODEVOL) REFERENCES vol(code),
- CONSTRAINT FK_CODEEMPLOYES FOREIGN KEY (CODEEMPLOYES) REFERENCES employes(code),
- CONSTRAINT FK_NUMEROPRODUITS FOREIGN KEY (NUMEROPRODUITS) REFERENCES produits(numero));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement