Go to Scriptcase store
  1. Home
  2. scriptcase connections
  3. database tools
  4. Diagrama ER

Diagrama ER

The ER Diagram is an option in the Database menu used to view the tables of a connection and their links. It provides a graphical representation of the database structure, making it easier to analyze and understand the existing relationships.

This feature presents an overview of the database structure, making it easier to identify tables, their fields, and the relationships between them.

Select connection

The list of project connections will be displayed when accessing the ER Diagram if the project has more than one connection created.

Select the connection to view the ER Diagram corresponding to the database being used.

Screen with the list of existing project connections for viewing the ER diagram

Viewing the ER diagram

When accessing the ER Diagram option, Scriptcase displays the tables of the selected connection in a visual format.

Each table is displayed in a block containing the table name and its respective fields. The links between the blocks indicate the relationships identified between the database tables through foreign keys.

ER diagram view. The tables are organized in blocks, with the related fields positioned below. Each link between tables is represented by a line in different colors.

Displayed information

In the diagram, you can view:

  • the table names;
  • the fields of each table;
  • the visual identification of field types;
  • the existing links between the tables;
  • the general organization of the database structure.

How it works

The diagram is generated based on the information available in the selected connection.

Tables are displayed as individual blocks, and the lines between them represent the links identified in the database structure.

In some tables, the Display option may be shown, allowing you to view additional information or expand the table presentation in the diagram.

In Scriptcase, this feature is intended for viewing. This means it allows you to consult the table structure and its links, but it is not used to create, edit, or remove tables and relationships directly through the diagram.

Notes

The links displayed in the diagram depend on the information identified in the database structure.

If any table, field, or link is not displayed correctly, check whether the connection is updated. If necessary, use the Clear Cache option in the Database menu to update the information used by Scriptcase.