CREATE TABLE "vehicle_model_year" (
	"id" INTEGER NOT NULL UNIQUE GENERATED BY DEFAULT AS IDENTITY,
	"model" VARCHAR(100),
	"fk_idVehicleBrand" INTEGER,
	"fk_idVehicleType" INTEGER,
	PRIMARY KEY("id")
);


ALTER TABLE "vehicle_model_year"
ADD FOREIGN KEY("fk_idVehicleBrand") REFERENCES "vehicle_brands"("id")
ON UPDATE NO ACTION ON DELETE NO ACTION;

ALTER TABLE "vehicle_model_year"
ADD FOREIGN KEY("fk_idVehicleType") REFERENCES "vehicle_type"("id")
ON UPDATE NO ACTION ON DELETE NO ACTION;