CREATE TABLE "disk_brand_specs" (
	"id" INTEGER NOT NULL UNIQUE GENERATED BY DEFAULT AS IDENTITY,
	"partNumber" VARCHAR(50),
	"mipPartNumber" VARCHAR(50),
	"product" VARCHAR(255),
	"serie" VARCHAR(255),
	"tier" VARCHAR(50),
	"quantity" INTEGER,
  "description" TEXT,
  "type" VARCHAR(255),
	"position" VARCHAR(100),
  "minThikness" VARCHAR(100),
  "lugNuts" VARCHAR(50),
  "ogDiameter" VARCHAR(100),
  "maxDiameter" VARCHAR(100),
  "materials" VARCHAR(100),
  "piDiameter" VARCHAR(100),
  "height" VARCHAR(100),
	"includesHardware" VARCHAR(255),
	"imageProduct" VARCHAR(255),
	"vehicleAttrs" TEXT,
	"imageProductDimentions" VARCHAR(255),
	"technicalSheet" VARCHAR(255),
	"fk_idVehicleModelYear" INTEGER,
	"fk_idDiskBrand" INTEGER,
	"years" VARCHAR(255),
	"yearsRange" VARCHAR(255),
	PRIMARY KEY("id")
);

ALTER TABLE "disk_brand_specs"
ADD FOREIGN KEY("fk_idVehicleModelYear") REFERENCES "vehicle_model_year"("id")
ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE "disk_brand_specs"
ADD FOREIGN KEY("fk_idDiskBrand") REFERENCES "disk_brands"("id")
ON UPDATE CASCADE ON DELETE CASCADE;