You can plan databases with this program. By drawing ER-diagrams the program generates the SQL-statements and relations (tables) about the database.
There are three sheets on the program. The first sheet is the drawing area and this open always first. The second sheet is the SQL. There are creating SQL-statements bases on ER-drawing. The third sheet is the relations and there are creating relations (tables) bases on the SQL-file.
Select File and then New from the menu. Then you have to choose the configuration file (.erkka) from the list opens in the window. After that you can begin the drawing.
Notice: If you now select File and Open instead of New the program supposes that there is some drawing-element in the file. The program ask for the drawing-element.
Select File and then Open from the menu. Then you have to choose the configuration file (.erkka) from the list opens in the window. After that the drawing opens and you can edit it. If you have an old drawing open close the program the drawing by asking if you want to save it.
Select File and Close from the menu. The program ask if you want to save the drawing.
You can save the drawing (.erkka)
You can print the drawing.
Yuo can export the drawing as .png.
Exit the program.
You can undo and redo as many times you want, but texts you can not undo or redo. It works only with drawing, also adding objects, removing them, moving them, and so on.
Does not work.
Does not work.
Does not work.
You can delete an object and its information.
Select all objects active.
The cursor is placed to the name-field of the selected object.
You can change the sheet by selecting another sheet from this menu. The present sheet is marked with a point.
Hide all spots in the lines in the drawing.
Notice: For example at printing.
You can change the color for the background, the line, the infopanel or the selected objects.
The selected object becames active.
There are manual and about.
Select an object by pressing the button at the top of the window. Then you click above the drawing area and the selected object is appearing to this. By clicking many times when an object is selected you can add many similar objects.
Notice:When you want to release an actived button you have to press Arrow button. Then you can select active attributes inside the entity also.
Attribute is an property for an entity or a relation. It can join to an entity or to a relation also. All the fields, which can define for attribute, are defined in the configurationfile. One attribute of an entity have to be primarykey.
Notice:Attributes can be inside or outside the entity.
Relation can be between two or more entities. It reflects the relation between two entities. The relation must have cardinalities, which you can define for the lines.
An entity is a thing or an action which can be regocnize.
The line must have cardinality. Cardinality have to be defined to relations, in this case to two lines. Its value can be empty, 1 or M. These three character are defined in the ER-configurationfile too. The true cardinality is one-to-one(1-to-1), one-to-many(1-to-M) or many-to-many(M-to-M). The lines which have an attribute as another target must be empty and the lines which have a relation as another target must be 1 or M.
When there are objects in the drawing area you can choose one object active by pressing it with mouse. The information panel about this object open on the left side of the window. The selected object is situated in a red box. If you are working with the entity which can include attributes the information panel about this entity open on the left side of the window. And by clicking an attribute you can select them instead of the entity.
You can choose many objects by pressing the Control button and at the same time clicking the objects. All objects which are selected are surrounded by a red box. The information panel does not open.
When an object is selected active the information about it is on the information panel on the left side of the window. Clicking with mouse above the text area you can add for example the name for the object. In some fields there is combobox or checkbox in whice you can choose the alternative. All the fields are defined in the configurationfile. By pressing F2 you can get the cursor at the textfield.
Notice! Advance only normal characters, not for example ä,ö or å
If you want to delete an object you select them active and press Delete button or select Delete from the menu.
Notice:If the cursor is in a textfield in the Informationpanel you can delete only the text not an object. By clicking Arrow button at the top of the window you can get the cursor out of the textfield.
By pressing mouse and keeping it down you can move a selected object. If you are moving many objects at the same time you have to press Control button too.
By selecting Line object and clicking on the drawing area first an object and then another object you can connect the two objects with a line. A line always has a cardinality. If you are connecting an attribute to an entity the cardinality is empty (or 1). And if you are connecting an entity and a relation is cardinality 1 or M.
By pressing this button none of objects is selected.
Save as (.sql), Print, Exit.
Cut, Copy, Paste, Select All. All these actions are in use in the SQL-view.
You can change the sheet by selecting another sheet from this menu. The present sheet is marked with a point.
If you have changed ER-picture and changes not appear to the SQL-view press F5-button.
SQL-statements can be edit and saved as text. By editing these SQL- statements you can affect Relation-view. The changes do not affect ER- diagram.
Check you have not ä or ö in the ER-diagram and the cardinalities are defined.
CREATE TABLE
is missingCheck you have defined the primarykey for all the entities.
There are three chance to choose: Export, Print and Exit. The relations you can export to png.
You can change the sheet by selecting another sheet from this menu. The present sheet is marked with a point.
If you have done changes and them not appear to the Relaions-view press F5-button.
If there is no primarykey in the relations-view there are no lines between relations. You have to define primarykeys at the drawing-view for all of the entities.
Relations are arranged casually and you have to arrange them yourself.