it would remain disabled and can be enabled only by dropping the foreign key constraint and