Automatic creation of entity diagrams (modeling and relationship)
141
Views
4
Comments
New
Database

Today it is possible to manually create an entity diagram, however it would be interesting for some entity diagrams to be created automatically, to facilitate understanding the relationships.


For example, in large projects where there are many entities and we need to delete information, it can become a big problem when we have entities with a "protected" relationship rule.


Because we try to delete and it gives an error, so we do the mapping on the entities' mother and try to create a query to delete.


Perhaps it would be interesting to automatically create entity diagrams for this type of relationship, so when you need to delete some data, just go to the diagram and understand the relationship.

Hi Lucas,

You already can see the type of relationship in the entity diagrams, deleted and projected relationships are colored differently.

If you drag one entity on a entity diagram, then right click it then you have two options for OutSystems to add related entities:

  • Show all entities referenced by <entityname>
  • Show all entities that refer <entityname>

Regards,

Daniel

Hi @Daniel Kuhlmann , I hope you are well :)


I know, I can manually create the diagram and visualize the relationships and also the rules of that relationship.


But the title of the idea is 'AUTOMATIC CREATION of entity diagrams", that is, I know that today it is possible to do it MANUALLY, but thinking about a junior or sometimes even a full-timer who doesn't have much experience with tables, that's why I suggested automatic creation of diagrams when relationships have a "protected" rule.


Regards,

Lucas Soares

My point, is that creating an entity diagram is not a fully manual tasks, two options exist for OutSystems to automatically at dependent entities.

My experience is there are multiple entity diagrams made most of the time with subset of entities, especially in large applications. That would only work in the way I describe and not by automatically generating them.

@Lucas Soares  In case you are interested in checking it out.  Our free Orbit Suite Data Manager Forge Application has both of these automatic features you suggested above. With the added bonus that you can also see and manage the data. Its fully dynamic and it helps a lot when you have a large portfolio of applications in a large factory.

https://www.outsystems.com/forge/component-overview/13176/orbit-suite-data-manager


https://grovepath.com/OrbitSuiteDataManagerInDepthPrimaryOverview.pdf