Highlighted

Understanding schema symbols

Avatar

Avatar

chetan4664

Avatar

chetan4664

chetan4664

18-09-2018

Hi

We have a bunch of tables. When I check the recipient (it can be for any other table as well) - I am not able to understand the difference between tables linked and marked in blue sold circle vs tables linked and marked in open or empty blue circle. Ex: Difference between Additional Data and Country.

Ex: Is there a convention which Adobe Campaign is following here as both Country and Additional Data tables are indicated differently. Please help.

1573931_pastedImage_0.png

Replies

Highlighted

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

19-09-2018

Hi chetan4664,

It represents cardinality.

Solid Circle means 1 to 1 where the target exists.

Country on the other hands is 1 to 1 relation but Country field can be empty.

Regards,
vipul

Highlighted

Avatar

Avatar

chetan4664

Avatar

chetan4664

chetan4664

20-09-2018

Many Thanks for the prompt reply

Highlighted

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

20-09-2018

in addition to Vipul,

Solid Circle means 1 to 1 where the target exists.

Country on the other hands is 1 to 1 relation with external join attribute set to true.

Regards,
vipul