Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!

Understanding schema symbols

Avatar

Level 2

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

3 Replies

Avatar

Employee

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

Avatar

Level 10

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