warning: file_get_contents( [function.file-get-contents]: failed to open stream: HTTP request failed! in /var/www/ : eval()'d code on line 4.


Structure Editor

Analyze, model and design the structure of your database thanks to a high-level graphic interface.

Design and model the architecture of your database with ease using the 4D Structure Editor.


Structure Editor


Just one click
With just one mouse click and the Properties inspector, you can add tables, fields, relations, and change settings on the fly.

Always-on validation
Our new SQL syntax check dynamically validates tables and fields as you work, so you always know that your structure is SQL-compatible.

Easy on the eyes
The Structure Editor has a number of tools to help you organise your application code for better readability,. For example, the cardinality of relations are displayed clearly (0<minimum > 1, 1<maximum > n) to avoid any confusion when reading.

Some of our other editing tools include:

• Zoom: In the blink of an eye, you can see your complete structure or drill down to focus on a specific element.

• Alignment: You can optimise the location and the size of tables for better visual clarity.

• Field Sort: You have multiple options for sorting field order.

• Color coding for tables, fields, and indexes.


Application analysis
There are a number of features available within the structure editor to help you during application analysis. For example, when you're working on a complex structure, you can choose to hide parts in order to focus on the remaining elements without distraction.

Clear organization
Using group management, you can organise a database structure by feature. This makes it easy to hide tables that don’t belong to the feature that you want to analise.



More resources