Diagramming

( Pro Edition )

The Diagramming Tool in Database Workbench Pro supports modeling in all 3 stages of a database design:

The Conceptual Data Model sketches entities and relationships between them. It's the first step and quite abstract.

If you start adding entity attributes and relationship details, you're moving towards the Logical Data Model. You'll fully define entities with attributes and their data types, completing the structure of the database.

When you convert the LDM to a PDM (or create the PDM manually), you'll start worrying about keys, how relationships affect the data and so on, this is the physical database system specific implementation of the logical model.

In practice, Database Workbench does not distinguish between a conceptual and logical model, as a conceptual model is "just" a logical model without entity attributes.

The CDM and LDM are database system agnostic, you can convert such a model into a PDM specific for any of the supported database systems in Database Workbench.

For both of these types of models, many of the Diagram Editor features are the same and there's a set of common objects available in both models.

For more information on how to use specific features in the Diagram Editor, see Using the Diagram Editor.