search

AdobeDocs / experience-platform.en

MIT License
6 stars 103 forks source link

ER diagram and related text needs to be corrected #300

Open kfoster-dx opened 5 months ago

kfoster-dx commented 5 months ago

Issue in ./help/xdm/schema/best-practices.md

The ER diagram and related text for Subscriptions and Addresses are incorrect.

You cannot configure a look up class/relationship for a Subscription for a specific person. So the fields status, startDate, and endData are misleading in this example. The Subscription box can only contain fields that generically describe each Subscription. The crows feet on the line should be reversed, with a solid line coming out of Subscriptions and a crows feet entering Customers.

You cannot have a reference class/schema Hotels that has its own reference class/schema for Addresses. Addresses should be merged into Hotels and the box eliminated from the diagram.

Last but not least, the industry standard for ER diagrams is to use singular nouns in diagrams, not plural. This can be easily confirmed with a Google search for "singular or plural er diagrams". (Tables and Datasets are normally named as plural nouns, not singular.)

vfalon commented 5 months ago

Thank you for submitting this issue. We will review the documentation and make the necessary updates as quickly as possible. Tracking internally in PLAT-178622.