using composite key made up of email and mobile columns

[rohitv20697926]

Hi, As part of my campaign data import I always kept email field as unique. But now the Business requirement is to have a combination of email and mobile to be unique. I want to know how this change would affect my prior campaign workflows? what are the cons?Amy_Wong​Woojin​Debbie​clawson​mghalpin​Jochem van Dieten​Adobe Campaign​Marilynlee17​

[Garima_Gakhar]

Hi rohitv20697926​

Any sort of changes to the structure of a Database Schema would impact data retrospectively as well.

So if the primary key is being modified to a combination of multiple fields, the prior Workflows referencing that Schema would look for that composite key (unique) combination as well.