In the database structure depicted in the diagram that follows
key2 make up the composite primary key of
table4, but in
table3 I'm able to set up a foreign key constraint that makes a reference to
Why does MySQL allow this? Does the above database structure make no sense at all?