Data model visualization

[knstvk]

[knstvk]

After reviewing the initial implementation, we have decided to rework the feature as follows:

• The DataTools add-on provides a master-detail view that shows the list of entities and their attributes using data grids. (p1)
• The entities data grid includes the columns: entity name, table name. (p1)
• The attributes data grid includes the columns: attribute name, Java type, column name, DB type, nullable?, mandatory? (p1)
• Reference attributes contain a link to the referenced entity. The link opens the same view filtered by the referenced entity in a separate browser tab. (p2)
• The view allows users to filter data grids by entity, table, attribute, column names. There is a single search field. The user can enter multiple search terms separated by comma, e.g. cust,order,prod. Search is performed through all names for all terms and results are merged using OR. (p1)
• Entities currently shown in the view can be exported to a diagram. The diagram is opened in a separate browser tab using a public PlantUML diagram server. An application property lets developers to specify a self-hosted PlantUML server. (p1)
  • There is an alternative diagram renderer, e.g. Mermaid. (p2)