CREATE TABLE pilots (

id integer NOT NULL,

name text NOT NULL

);

ALTER TABLE pilots ADD CONSTRAINT pilot_pkey PRIMARY KEY (id);

CREATE TABLE jets (

id integer NOT NULL,

pilot_id integer NOT NULL,

age integer NOT NULL,

name text NOT NULL,

color text NOT NULL

);

ALTER TABLE jets ADD CONSTRAINT jet_pkey PRIMARY KEY (id);

ALTER TABLE jets ADD CONSTRAINT jet_pilots_fkey FOREIGN KEY (pilot_id) REFERENCES pilots(id);

CREATE TABLE languages (

id integer NOT NULL,

language text NOT NULL

);

ALTER TABLE languages ADD CONSTRAINT language_pkey PRIMARY KEY (id);

CREATE TABLE pilot_languages (

pilot_id integer NOT NULL,

language_id integer NOT NULL

);

ALTER TABLE pilot_languages ADD CONSTRAINT pilot_language_pkey PRIMARY KEY (pilot_id, language_id);

ALTER TABLE pilot_languages ADD CONSTRAINT pilot_language_pilots_fkey FOREIGN KEY (pilot_id) REFERENCES pilots(id);

ALTER TABLE pilot_languages ADD CONSTRAINT pilot_language_languages_fkey FOREIGN KEY (language_id) REFERENCES languages(id);