Multiple foreign keys in same table

Question

Can I reference 3 foreign keys in MYSQL? because in INNODB, only one foreign key constraint appears in the relational view.

Answer 1

Yes you can do,

EXAMPLE:

CREATE TABLE table
(
user_id int,
track_id int,
primary key (user_id, track_id),
foreign key (user_id) references table1(table1Column),
foreign key(track_id) references table2(table2Column)
)

Composite Primary Key;

FOREIGN KEY ('column1','column2','column3') 
REFERENCES table1('column1','column2','column3') ;