Primary key in extended schema | Community
Skip to main content
M
Manpreet1
Level 2
May 26, 2022
Solved

Primary key in extended schema

  • May 26, 2022
  • 1 reply
  • 1137 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by costa_n11

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-reference/elements-attributes/db-index.html?lang=en

 

Hope this helps,

Thanks

Denis

1 reply

C
Adobe Employee
costa_n11Adobe EmployeeAccepted solution
Adobe Employee
May 26, 2022

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-reference/elements-attributes/db-index.html?lang=en

 

Hope this helps,

Thanks

Denis

    M
    Manpreet1Author
    Level 2
    May 27, 2022

    Thanks Denis. 

    Terms & ConditionsAccessibility statement

    Loading footer...