This tutorial will help you start modeling RDS diagrams in GenMyModel. Most of actions in GenMyModel can be done using keyboard shortcuts.


Note : GenMyModel is a modeling tool (with intelligence algorithms behind), not just a drawing tool. It means that any diagram can generate its code, which can then be used by developers.

 

Create a new RDS project from the GenMyModel dashboard.



Once it's done, press the Open in Editor button to open the GenMyModel work environment.




Toolbar Keyboard Shortcuts
RDS Diagram Example - Room Reservation


Info : Press Shift + ? to show the complete keyboard shortcuts map at anytime


Create Table


Way 1 - Drag&Drop


  • Click on the Table tool on the toolbar and click in the work area.
  • OR 
  • Drag the Table tool from the toolbar and drop in the work area.


Tip : To create multiple elements faster, after selecting a tool, hold Ctrl key and click on the work area as much as necessary


Way 2 - Keyboard shortcut


Press T key and click on the work area.


Rename Table


Double-click on the table name to change it.


Create Column


Way 1 - Contextual toolbar

  • Select the table element
  • Use Add a new column from the contextual toolbar


Way 2 - Toolbar

  • Select a Column tool from the toolbar and click on the desired table
  • OR
  • Drag the Column tool from the toolbar and drop it on the desired table



Way 3 - Keyboard shortcut


Press C key and click on the work area.


Modifying Column Name, Type and Size


Way 1 - Double-click on a Name, Type or Size part to modify them.


Way 2 - Select the column, then change the desired properties in the Properties side panel (bottom left).


Create Reference Relationship


Way 1 - Toolbar


Click on the Reference tool from the toolbar, then select the table or column element and select another column to join it.



Way 2 - Keyboard shortcut


Press R key, select the table / column element, then select another column to join it.


Move relationships


To move a relationship, point your mouse cursor on one of the crossing points and drag it to the desired location.



Create Group


Way 1 - Drag&Drop


  • Select the Group tool from the toolbar and click on the work area or another group
  • OR
  • Drag the Group tool from the toolbar and drop it in the work area or in another group


Way 2 - Keyboard shortcut


Press G key > click on the workspace / group.


Create Type


Built-in column types : BIGINT / BINARY / BOOLEAN / CHARACTER / DATE / DECIMAL / DOUBLE / FLOAT / INTEGER / INTERVAL / NUMERIC / REAL / SMALLINT / TIME / TIMESTAMP / VARBINARY / VARCHAR / XML


Info : If the list of built-in column types is not sufficient, you can still create your own types (see below)


Way 1 - Drag&Drop


Drag&Drop the Type tool from the toolbar to the workspace / group OR select the Type tool > click on the workspace / group.

Double-click on it to rename.


Way 2 - Keyboard shortcut


Press Y key > click on the workspace / group > double-click on it to rename.


Way 3 - Drop-Down menu


Double-click on the column type part and start directly typing the needed name OR select Create a Type at the end of the drop-down menu.


To delete the type created this way, right-click on it in the Project side panel (top left).


Created Type Properties


To change different properties of your own type, select it and change them in the Properties side panel (bottom left).


Add Index


Add Index to the Table


Select the concerned table > press Add Index in the Properties side panel (bottom left).


Add Column to the Index


When index is created, you can then add column to this index by pressing on Add Column to Index.


After that, click on the drop-down menu to select the column.

Online Code Generator


1 - Click on Generators side panel

2 - Select the needed generator OR your own from My Generators folder

3 - Click on Run button

4 - Click finally on Download your archive