added the foreign key constraint for the promotion table