ALTER TABLE "vendor_candidates" ALTER COLUMN "contact_email" DROP NOT NULL;