Data Models Diagrams

WHY USE DATA MODELS DIAGRAMS?

They provide a graphical representation of database entities and their relationships.

These diagrams are typically used for:

  • Database design: organize, analyze or review relational databases
  • Database troubleshooting: analyze existing data structures to find and resolve problems in logic or deployment.

HOW TO GENERATE A DATA MODELS DIAGRAM?

1. Check the minimum requirements

  • If your VE project reads code from a database, it should include tables and views.
  • If your VE project reads code from files, it should include DDL statements to create tables, views, triggers, foreign keys, etc.

2. Generate the Data Model

  • In the treeview, double-click on the table icon to open the list the tables.
  • Select some tables: 
    • Use the [Ctrl key] to select several tables
    • If needed, use the search field above the treeview to find them.
  • Go to [Diagrams] in the ribbon menu. Click on "Data Model"

generate data model diagrams

 

  • A new diagram is generated in the treeview:

generate data model diagrams developed and compact

3. Display in Full Screen

  • You can detach the Diagram and display it full screen
  • You can also adjust the zoom factor to visualize a certain part of the Diagram.

create data model diagrams

4. Expand & Collapse entities

  • Each entity can be expanded (full details) or collapsed (name only), by clicking on the triangle before its name:

data model diagram collapse objects

  • You can expand/collapse all entities at the same time with these buttons:

data model diagrams

5. Visualize the code of each entity

  • If you select an entity in the diagram, its code shows up in the source code view:

generate data model diagrams using visual expert

Edit a diagram

   Read this article to edit and save a diagram

Share, Export, Print a diagram

   Read this article to share, export, and print a diagram