Question

Identifying Entity Relationships in Databases

0

I'm curious—can we retrieve specific data using a microflow or Java action to clearly identify if the relationships between entities in a database are one-to-one, one-to-many, or many-to-many? Any insights or examples would be appreciated!

asked 2024-10-23

Sai Kumar Bevara

1 answers

Micha Friede · Accepted Answer · 2024-10-23

Maybe not exactly what you are looking for, but it could help you..

If you download the Model Reflection Modulefrom the marketplace, you will be be able to convert your model into readable data. If you look at the screenshot of the domain model below, you can see that the MXObjectReference entity contains the information about the ReferenceType (Reference, Reference Set) and Association Owner (Default, Both) which will allow you to tell what the association between entities (associated objects in MxObjectType) are exactly.