Table with multiple foreign keys?
Posted: Mon Sep 28, 2009 7:26 pm
I have four MySQL tables: A, B, C and Z.
Tables A, B and C each has a foreign key into a record in Z.
What is the best way to include foreign keys in Z to point back into A, B, and C? Naturally, each record in Z only belongs to one record (in either A, B, or C).
Thanks!
Tables A, B and C each has a foreign key into a record in Z.
What is the best way to include foreign keys in Z to point back into A, B, and C? Naturally, each record in Z only belongs to one record (in either A, B, or C).
Thanks!