I am managing mysql 5.6 with phpMyadmin 2.8.1 which are hosted by IPower (web hosting company).
I have created 2 tables and have set them up as InnoDB.
The tables created names are: users and patient_id.
In the patient_id table I have added a column to be used as the foreign key that will be related to the "id" column in the users table.
I have indexed this column in the patient_id table.
When I go into the relationship view of the table and try to setup the relationship , I get "No Index found for the column" even though I have indexed it already!
I have attached screenshots of the database structure and the error message.
Any help will be greatly appreciated! Thanks