CREATE TABLE elif_continent (
	numContinent INTEGER,
	nomContinent VARCHAR(30),
	PRIMARY KEY (numContinent)
);

CREATE TABLE elif_pays (
	numPays INTEGER,
	nomPays VARCHAR(50),
	capitale VARCHAR(50),
	superficieKm INTEGER,
	numContinent INTEGER,
	PRIMARY KEY (numPays),
	FOREIGN KEY (numContinent) REFERENCES elif_continent(numContinent)
);

CREATE TABLE elif_frontalier (
	numPays1 INTEGER,
	numPays2 INTEGER,
	PRIMARY KEY (numPays1, numPays2),
	FOREIGN KEY (numPays1) REFERENCES elif_pays(numPays),
	FOREIGN KEY (numPays2) REFERENCES elif_pays(numPays)
);

CREATE TABLE prof_fleuve (
	numFleuve INTEGER,
	nomFleuve VARCHAR(50),
	PRIMARY KEY (numFleuve)
);

CREATE TABLE elif_traversee (
	numFleuve INTEGER,
	numPays INTEGER,
	distance INTEGER,
	PRIMARY KEY (numFleuve, numPays),
	FOREIGN KEY (numFleuve) REFERENCES elif_fleuve(numFleuve),
	FOREIGN KEY (numPays) REFERENCES elif_pays(numPays)
);

