Problem with index -mysql workbench

The ratio PRIMARYis equal fk_student_single_user1., therefore I must remove one of them.

The problem is that I cannot delete or rename PRIMARYto workbench, the program does not allow, and if I delete fk_student_single_user1, I will also delete foreign key. The only way is to remove PRIMARYin phpmyadmin.

But I think that there is some problem in my eer model, it is supposed to export without errors. I deleted my previous column id because two foreign keys can be the main key of the table.

How can i solve this?

enter image description here

+3
source share
1 answer

, fkey , sql (alter table...), .

SQL , ( ) .

MySQL , ( http://sql-info.de/mysql/gotchas.html).

, , . , GUI.

+1

All Articles