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

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

ANSWER DOWNLOAD EXAMIANS APP