Expand my Community achievements bar.

SOLVED

Primary key in extended schema

Avatar

Level 2

Hi all,

I have a question. I extended recipient schema and created a primary key in extended one. Now, as I have two primary keys, one which I defined and one which resides in recipient schema. How should I modify this? Or is there a need to modify. Can someone explain it to me?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi @Manpreet1 

You can't do that, especially on Recipient as you will break ALL the links that exist around the recipient entity. You can have ONLY 1 Primary Key. Define your 2nd key as a unique index instead of a primary key. it will achieve the same result and you won't break the standard data schema.


See this page to find out how to create an index in your recipient schema extension

 

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...

 

Hope this helps,

Thanks

Denis

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

Hi @Manpreet1 

You can't do that, especially on Recipient as you will break ALL the links that exist around the recipient entity. You can have ONLY 1 Primary Key. Define your 2nd key as a unique index instead of a primary key. it will achieve the same result and you won't break the standard data schema.


See this page to find out how to create an index in your recipient schema extension

 

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...

 

Hope this helps,

Thanks

Denis