SQL Foreign Key issue preventing setup:upgrade from completing

I am running into an issue when trying to run setup:upgrade, to where it fails with saying;

SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID’; check that column/key exists, query was: ALTER TABLE review DROP FOREIGN KEY REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID

I don’t have any reviews, so my review table is empty (and never been touched), and as far as I know, default with what it has inside it;

I am not even exactly sure what could’ve changed in the system to even have it looking/trying to mess with that section (in trying to drop its foreign key all of a sudden).

Any ideas what could be the issue here?

Or is there a simple way to fix it — by creating a makeshift foreign key just to appease its request perhaps?

UPDATE:

I have also since, tried to manually remove said foreign key by going into the database and doing;

ALTER TABLE review DROP FOREIGN KEY REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID;

However it comes with the same information of;

#1091 – Can’t DROP ‘REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID’; check that column/key exists