title: How do I fix this error 3734: Failed to add the foreign key constraint on MySQL WorkBench?
body: <p>I am working on MySQL WorkBench and I keep getting error code 3734: Failed to add the foreign key constraint. What does this error mean and can I fix this error? I keep getting the error with the villa reservation table.</p>
  <pre><code>     create table Reservation
  (
  ReservationID char(5) primary key,
  ReservationDate date,
  CustomerID char(5),
  foreign key (CustomerID) references Customer (CustomerID)
  );
  
  create table Villa
  (
  VillaID char(5) primary key,
  VillaName varchar(40),
  VillaCostPerDay int(3), 
  VillaTypeID char(5),
  foreign key (VillaTypeID) references VillaType (VillaTypeID)
  );
  
  ``create table VillaReservation
      (
      VillaReservationID char(5),
      VillaID char(5),
      DateFrom datetime,
      DateTo datetime,
      primary key (VillaReservationID, VillaID),
      foreign key (VillaReservationID) references Reservation(VillaReservationID),
      foreign key (VillaID) references Villa(VillaID)
      );
  </code></pre>