2 key fields
I noticed that you made them both primary keys. I don't think that'll work. Because your PK's are in the other 2 tables.
If you remove both primary keys, click on the relation view icon just above the index area and use the "link to" and link them to your PK's in the other tables you'll have just index keys on your 2 table items.
I think you need to make the tables innoDB as well, but not sure about that.