CREATE TABLE "StationSite" ( "id" int PRIMARY KEY, "site_type" int ); CREATE TABLE "Intervention" ( "id" int PRIMARY KEY, "intervention_date" datetime, "station_id" int, FOREIGN KEY("station_id") REFERENCES "StationSite" ("id") ); CREATE TABLE "IntervStation" ( "id" int, "intervention_id" int, "station_state" varchar(255), FOREIGN KEY("intervention_id") REFERENCES "Intervention" ("id"), FOREIGN KEY("station_state") REFERENCES "station" ("state") );