Salesforce Data Model Notation

Описание: Salesforce Data Model Notation
This document provides an overview of Salesforce entity relationship diagram (ERD) notation and conventions to help you clearly interpret the product data models available in the data model gallery.

An ERD, also known as a data model, is a graphical representation of an information system. It shows the relationships among people, objects, places, concepts, and events in that system. It is a logical model that conveys the functional structure of data. In Salesforce ERDs, entities typically map to an object in the Salesforce database.
Entities are represented in the diagrams as boxes with rounded corners. Each entity box typically provides two labels (where applicable):

The logical name of the entity (e.g. "Salesforce Entity" in the example shown here). This may correspond to the singular label of the represented Salesforce object, but not always.
The "physical" API Name or Developer Name of the object in your Salesforce organization (e.g. "API Name" in the example). For managed package objects, the API name listed in the diagram typically does not include the managed package namespace ("vlocity_ins**", for example) unless the Salesforce or Industry cloud uses multiple managed packages. The end of the API name for managed package objects denotes the type of custom object used: "**c" for regular custom objects and custom settings, "**mdt" for custom metadata, "**x" for external objects.
Entity boxes may also list one or more attributes that are representative of the attributes of that entity. An attribute is preceded by either a "#" or a "•" character:

A "#" indicates an attribute that is part of the logical unique key of the entity. In the example diagram, "User Key Attribute" is considered the user primary key of the entity.
A "•" indicates a non-key attribute.