Modelio SQL Designer User Guide –
¶
Introduction
¶
Introducing SQL Designer
Installing SQL Designer
SQL databases supported
Modeling a database
¶
Conceptual Model
¶
Creating an SQL conceptual model
SQL Designer properties
Creating a persistent class
Creating an identifier
Creating a property
Creating an association
Inheritance relationships
Logical Model
¶
Creating an SQL logical model
Creating a table
Creating a field
Creating a primary key
Creating a foreign key
From the conceptual model to the logical model
¶
Transforming a conceptual model into a logical model
Transforming a logical model into a conceptual model
Mapping rules for associations
Mapping rules for types
Mapping rules for inheritance relationships
Generating and reversing SQL scripts
¶
Generating SQL script files
Reversing SQL script files
Integration with the Hibernate Designer module
¶
Integration with the Hibernate Designer module
The data model: a common model
Ensuring the persistence of a Java data model
Developing a new application that includes a database
Modernizing an existing application that includes a database
Other features: SQL/Hibernate wizards