Yeah, that sounds best. Course deletion has always been kinda dodgy as a feature. 
I still don’t get why the foreign key constraint would have allowed it in the first place, but I’m guessing it should resolve your issue when trying to recreate the constraint.
Edit:
Er… actually, shouldn’t it be the reference in course_overviews_courseoverviewtab that gets deleted?