1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
CREATE TABLE Vehicule (IDVehicule int AUTO_INCREMENT NOT NULL, ImmatriculationVehicule VARCHAR(20),
NumCleVehicule INTEGER, ModeleVehicule VARCHAR(30),
CarburantVehicule VARCHAR(20),
Co2 INTEGER, FiltreAPolene VARCHAR(3),
DateMiseCirculation DATE,
ProchainCT DATE,
DerniereRevision DATE,
DateReleveKm DATE,
Kilometre INTEGER,
ProchaineRevision INTEGER,
DateAjoutVehicule DATE,
DateModifVehicule DATE,
DateSuppVehicule DATE,
DispoVehicule VARCHAR(3),
IDService INT NOT NULL,
IDLieu INT NOT NULL,
PRIMARY KEY (IDVehicule) ) ENGINE=InnoDB;
CREATE TABLE Service (IDService int AUTO_INCREMENT NOT NULL,
Service VARCHAR(50),
DispoService VARCHAR(3),
PRIMARY KEY (IDService) ) ENGINE=InnoDB;
ALTER TABLE Vehicule ADD CONSTRAINT FK_Vehicule_IDService FOREIGN KEY (IDService) REFERENCES Service (IDService); |
Partager