Plans

Parsing DDL Script with this module is in progress (0.35.1 ?). With this release you can import some scripts from :

• MySQL / MariaDB
• SQL Server

2 kind of model can be imported :

• Physical (Other words : Logique ? Relationnal ?)
• Conception

Example

Here is a example, extract of Sakila CREATE TABLE film ( film_id bigint NOT NULL, title varchar(255) NOT NULL, description text, release_year year(4) DEFAULT NULL, language_id tinyint(3) unsigned NOT NULL, original_language_id tinyint(3) unsigned DEFAULT NULL, last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (film_id), CONSTRAINT fk_film_language FOREIGN KEY (language_id) REFERENCES language (language_id) ON UPDATE CASCADE, CONSTRAINT fk_film_language_original FOREIGN KEY (original_language_id) REFERENCES language (language_id) ON UPDATE CASCADE ); CREATE TABLE language ( language_id tinyint(3) unsigned NOT NULL AUTO_INCREMENT, name char(20) NOT NULL, last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (language_id) );

Choose File / Import Sources...

Note that you might have to choose "UTF-8" as encoding.

You have to choose the database : Mysql/MariaDB or Sql Server.
For this example, choose Mysql/MariaDB.

Result with Physical model :

A FK become an association and each attribute of FK is in the table. Stereotype <<Table>>, <<PK>> and <<FK>> are created in the project.

Result with Conception model : A FK can become :

• An association
• A generalization

About FK

The name of the association end is :

• The name of the column in the base if there only one
• Otherwise, the name of the FK

This page was last modified by $Author: elbedd $ on $Date: 2013-05-28 23:00:00 +0100 (tue., 28 may 2013) $.