Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

What is integrity, revlink and revcardinality in ACC when we create links in schema?

Avatar

Level 2

Hi team,

What is the meaning of integrity, revlink and revcardinality in the links while creating schema. Do we need to specify those while creating the links and what are the cases in which we need to specify those? Kindly clarify this. and please provide an example. 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Kumar_27 ,

While creating the link, the following attributes are mandatory to define: label, name, target, and type. 

Other attributes you can add depends on your link definitions/structure and few attributes are added automatically.

Example,

revCardinality:

This is Optional. If you want to create a one to one link between 2 schema, you need to define  revCardinality="single" . If you haven't addet revCardinality, it will consider those 2 schema has 1 to Many relationship.

 

Integrity:

This defines, If you delete a record from schema-1, then what action to be made on schema-2 record, which is linked with schema-1.

Lets say you have 2 schema, country and recipient. If you delete a record (Country-A) from country schema, what should happen to the recipient records linked with Country-A? This can be defined using integrity. Possible values are as below:

  • define: it is possible to delete the source occurrence if it is no longer referenced by a target occurrence,
  • normal: deleting the source occurrence initializes the keys of the link to the target occurrence (default mode), this type of integrity initializes all foreign keys,
  • own: deleting the source occurrence leads to the deletion of the target occurrence,
  • owncopy: the same as own (in case of deletion) or duplicates the occurrences (in case of duplication),
  • neutral: does nothing.

 

revLink:

To give a name of reverse link from the target schema (deduced automatically by default)

 

For more information, you can refer this documentation

 

ParthaSarathy S

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @Kumar_27 ,

While creating the link, the following attributes are mandatory to define: label, name, target, and type. 

Other attributes you can add depends on your link definitions/structure and few attributes are added automatically.

Example,

revCardinality:

This is Optional. If you want to create a one to one link between 2 schema, you need to define  revCardinality="single" . If you haven't addet revCardinality, it will consider those 2 schema has 1 to Many relationship.

 

Integrity:

This defines, If you delete a record from schema-1, then what action to be made on schema-2 record, which is linked with schema-1.

Lets say you have 2 schema, country and recipient. If you delete a record (Country-A) from country schema, what should happen to the recipient records linked with Country-A? This can be defined using integrity. Possible values are as below:

  • define: it is possible to delete the source occurrence if it is no longer referenced by a target occurrence,
  • normal: deleting the source occurrence initializes the keys of the link to the target occurrence (default mode), this type of integrity initializes all foreign keys,
  • own: deleting the source occurrence leads to the deletion of the target occurrence,
  • owncopy: the same as own (in case of deletion) or duplicates the occurrences (in case of duplication),
  • neutral: does nothing.

 

revLink:

To give a name of reverse link from the target schema (deduced automatically by default)

 

For more information, you can refer this documentation

 

ParthaSarathy S