title: ERROR 1005 (HY000) | Can't create table
body: <pre><code>create table finishedMaterials(
  FinishedMaterialID VARCHAR(4) NOT NULL,
  FinishedMaterialType VARCHAR(10) NOT NULL,
  FinishedMaterialWeight INT(5) NOT NULL,
  FinishedMaterialUnits INT(5) NOT NULL,
  CONSTRAINT PRIMARY KEY (FinishedMaterialID))ENGINE=INNODB;
  
  create table vehicles(
  VehicleID VARCHAR(4) NOT NULL,
  VehicleNumber VARCHAR(8),
  VehicleType VARCHAR(10) NOT NULL,
  VehicleCondition VARCHAR(10) NOT NULL,
  VehicleRemarks VARCHAR(100),
  CONSTRAINT PRIMARY KEY (VehicleID))ENGINE=INNODB;
  
  create table transport(
  TransportID VARCHAR(4) NOT NULL,
  VehicleID VARCHAR(4) NOT NULL,
  FinishedMaterialID VARCHAR(4) NOT NULL,
  FinishedMaterialUnits INT(5) NOT NULL,
  FinishedMaterialWeight INT(5) NOT NULL,
  CONSTRAINT PRIMARY KEY (TransportID),
  CONSTRAINT FOREIGN KEY (VehicleID) REFERENCES vehicles(VehicleID),
  CONSTRAINT FOREIGN KEY (FinishedMaterialID) REFERENCES finishedMaterials(FinishedMaterialID),
  CONSTRAINT FOREIGN KEY (FinishedMaterialUnits) REFERENCES finishedMaterials(FinishedMaterialUnits),
  CONSTRAINT FOREIGN KEY (FinishedMaterialWeight) REFERENCES finishedMaterials(FinishedMaterialWeight))ENGINE=INNODB;
  </code></pre>
  
  <hr>
  
  <p>• What's wrong in this code? What's causing this error? Please help. All the other tables, including the top 2 of this code works perfectly, except for the last one.</p>