[RESOLVED] foreign key question

[182x]

Hey guys,

Is it true that the foreign key must be an integer and the primary key of another table?

I always thought that it just had to be a unique value from another table of any type.

[NogDog]

There is no such restriction in MySQL.
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

[182x]

NogDog wrote:

There is no such restriction in MySQL.
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

Thank you again 🙂