three must conditions for setting forign key

In order to set up a foreign key relationship between two MySQL tables, three conditions must be met:

1. Both tables must be of the InnoDB table type.
2. The fields used in the foreign key relationship must be indexed.
3. The fields used in the foreign key relationship must be similar in data type.