Database Redesign
To drop a column that is used as a foreign key, first:

drop the primary key.
drop the table containing the foreign key.
drop the foreign key constraint.
All of these

ANSWER DOWNLOAD EXAMIANS APP