The references are done with 'Associate to UML' option. The Option Class Scope is used to define whether the field is a sequence or not ' ' -> 'Implementation': Creates a unique index grouped with another ones marked with this option and one index to each individual field '-' -> 'Privated': Creates an individual index and another one grouped with all others marked with this option. The table fields are inserted as attributes. The class name is always the table name. You gotta save the diagram in XML format. This first version supports only classes (tables) and associations (references). In order to use the class the right way is needed to foolow some conventions during the diagram creation. This first version supports only PostgreSQL. As Dia files are saved in XML format, is possible to read these files and create a DataBase structure easily. The dia2sql.php class is a tool that convert this UML diagram into SQL.

However, as the most of programs, DIA generates only the diagram, It doesn't export SQL instructions. It can be used to draw many sort of diagrams, including UML diagrams. This way, I decided to write a php class to read a DIA diagram and generate the correspondent SQL instructions to create DataBase.ĭIA () is a gtk+ program to create diagrams.

There are few programs on Linux to convert UML diagrams into SQL instructions.

Dia uml tool