Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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

Avatar

Level 2

Thanks Denis.