Resolved: SQL: Foreign Key Constraint Part II
I also do not see the foreign key under the foreign key tab. I do not get any error messages. If I look at the INDEXES tab, I can see the constraint. Will appreciate any assistance. Thank you!
SCHEMA also shows that the contraint was registered.
Hi Anita!
Thanks for reaching out.
This is a well-known bug from the Workbench. It will not affect the smooth taking of the courses. Enjoy!
Hope this helps.
Best,
Tsvetelin
Same issue. I also do not see the foreign key under the foreign key tab.
@Tvetelin Tsonkov,
That well-known bug for workbench would be a good thing to mention in the notes in the assignments. I spent a while trying to figure out why this was happening and redoing my work, and then looking in all the other places trying to figure out why it wasn't registering there. And, since this has been an issue for a while I think it would be easy enough to edit the text of the course to help students out.
Hi Asim and Sarah!
Thanks for reaching out and for your feedback!
I have marked your comments and will consider adding a note on the relevant places the next time we are updating the course.
Hope this helps.
Kind regards,
Martin