If you're trying to integrate other software with L2L, you might wonder how the tables are joined together to form relationships. Mapping these relationships between tables is also referred to as ERD - Entity Relationship Diagram. Entity-Relationship models describe interrelated points of interest in a specific domain of knowledge. Basic ERD models are composed of entity types and specify what relationships can exist between entities.
You can always tell how the tables are joined by looking for the "ForeignKey" fields. In the following example, the `dispatch` ForeignKey field on the Dispatch Technician record can be joined to the `id` field in the Dispatches API. Please see the illustration below.
The same applies for the the other record areas as well. Just look for the ForeignKey property, find the Record Area that matches the ForeignKey property, and you can join to that Record Area using the `id` field.
Please sign in to leave a comment.