CREATE TABLE Avion
(immat CHAR(6), typeAvion CHAR(15), nbhVol DECIMAL(10,2),
	proprio CHAR(4) NOT NULL, 
	CONSTRAINT pk_Avion PRIMARY KEY(immat),
	INDEX (proprio),
	CONSTRAINT fk_Avion_comp_Compag FOREIGN KEY(proprio) REFERENCES Compagnie(comp));