The logical model (or table model) is a relational model of SQL tables.
Since the SQL Designer module supports four variations of SQL grammar (SQL92, ORACLE11G, MYSQL, SQLServer 2008 and Firebird), there are therefore four types of logical model, one per type of grammar supported.
The SQL Designer module provides a set of commands used to create a model of SQL tables in preparation for the generation of SQL script files.
Command | Available on | Result |
---|---|---|
![]() ![]() ![]() ![]() ![]() | UML package | Creates the root of the SQL table model. |
![]() |
![]() | Creates a table. |
![]() |
![]() | Creates a primary key for a table. |
![]() |
![]() | Creates an attribute for a table. |
![]() |
![]() | Creates a foreign key by specifying a primary key of another table. |
![]() |
![]() | Creates an attribute which is the primary key of a table and the foreign key of another. |
![]() |
![]() | Creates a foreign key directed to another table. |
![]() |
![]() | Creates a foreign key directed to another table. However, this attribute is also the primary key of the table. |