Open the application and choose the ‘Data Designer’ menu
Click the icon ‘Create Diagram Designer’ to open the modal window.
Give some name and click on the ‘Create ER-Diagram’ button
Create Data Diagram success. Click on the icon ‘Start design diagram’ to open the ER Diagram
Once the user opens the project he will see the design space.
Inside the Diagram Designer project, you can find a Side Menu
In the Side Menu there are the following options:
Search box - to search and filter elements from your side menu Table - to view the Entities/ tables in your data model. Link - to view the relationships or links in your data model.
ONEWEB now provides a Designer tool to design the data model for your application. Users can design the model from scratch by creating the entities, columns, and adding relationships or they can import an existing schema from your database into the Data Designer.
This Data Design is the starting point for using the other Database Designer Tools as well.
How to use Search The Search field is used to search and filter the tables on the side menu.
Hide Tables The hide/show icon on the tables is to hide or show a table from the design panel.
Toolbar Menus Data Designer provides a list of controls on the toolbar at the top.
Icon
Control
Action
Save
To Save the changes on the Data Designer. When undo the auto save changes the undo s can go back to the last save using this Save button.
Version
To stamp a version in the ER Diagram. Once you create different versions user can use the compare Schema tool inside the Database tools to compare the changes across versions.
Select
To select the elements on the diagram panel for editing.
Move
To scroll the designer panel to move along the panel.
Collapse
To collapse the tables. There are three levels of collapse, 1. Level that shows the full structure (This is the default level). 2. Collapse to show only table name and keys. 3. Collapse to show only table name. The level of current collapse is also shown in the toolbar.
Magnify
To open the magnifying glass feature at the mouse point on the panel to magnify any portion of the diagram.
Grid
To toggle the grid layout on the design panel. User also has option to set the grid dimensions.
Entity
Select entity and click on the design panel to add a new Entity to the ER Diagram. On the right hand side the properties panel will open to configure the entity and columns.
Relation
To configure the relationship between entities by adding links.
Group
To create new group to group a set of entities.
Label
To add a new Label to the ER Diagram.
Note
To add new sticky notes to the Diagram panel.
Zoom
Zoom in
To magnify the Diagram panel
Zoom %
Displays current zoom level
Zoom out
To zoom out the Diagram panel
Transfer Controls
Transfer
To transfer the ER Diagram in and out of the Design panel. Data Designer provides multiple options for transfer both in and also out.
POS Engine
To change the default Database Engine to be used for transfer
Connection
To configure connection and also to open existing connection. The icon also shows the status of current connection.
Exit
To exit from current Diagram panel.
Transfer Controls The transfer control provides the following options. The transfer From Database is enabled only if there is an active connection.
Under Import, there are two options currently provided by the Data Designer - From XML and From Database. User can import to Data Designer from an XML file which is ideally an export from another Data Designer. Or the user has to follow the template to create the XML for import.
Users can use the import from database option if there is an active connection. If the user chooses the Import from the database and if there are manually created entities then again there are two types of import - Merge and Replace. Users can choose to merge or replace the data from the database.
Data Designer also provides the option to export to PDF, or image files. Users can also use it to generate SQL statements (DDLs) or an XML file.
When generate as SQL statements user might need to map the columns from ER Diagram to specific data types in the database. For this, the Data Designer provides the Column Type mapping feature
Users can preset the data types for different database engines. POS Engine setting
Data Designer provides an option to choose the database engine type and version to be used as the default engine for generating SQL.
Users can connect to a particular database connection from the connection control. It has also the option to configure a new Connection. Please go through the Connection configuration in SQL Builder to learn about how to configure a new connection. Entity Properties Window When a user selects a particular entity for edit, the Entity Properties window will open.
ONEWEB provides utility to compare two versions of the schema. The utility is available under the Tools section in the Database Tools menu.
Inside the compare schema utility, the user can choose to create a new comparison by selecting the source and target ER Diagram and versions.
When execute the system will open the comparison analysis screen.
In the Data Designer, the user can design a data model or ER Diagram from scratch or import it from an existing system. To create a new entity user has to choose the Entity icon from the toolbar menu and click and drag on the diagram panel where you want to place the entity.
The new entity will be created there and the Entity Properties window will open on the right-hand side where you can configure your entity properties.
Feature : Entity (General)
Name : To name the table.
Comment : To add details to the table.
Color : To change the color of the table card.
Feature : Entity > (Columns)
Name : To generate column names.
Type : To define the column type.
N (Not null) : To set the column value as not null.
PK (Primary Key) : To define columns as the primary key.
Length : To set the length of the column.
Precision : To set the precision for the number after the decimal.
Default Value : To specify the default value of the column.
Auto Increment : To assign a column to be incremented automatically every time the data is inserted
Delete : To delete columns.
Feature : Entity > (Indexes & Unique key constraints)
Users can use this section to specify the unique constraints or index keys for the table. It will not show on the design diagram , but will be generated during the DDL generation process.
Feature: Entity > (Node Problem)
Errors : To show errors.
Warning : To show a warning.
Feature: Entity (Preview SQL (DDL))
To generate the DDL for the table
Feature: Entity (Delete)
To delete the entity or table
Locate The location icon is to locate a particular table on the design panel.The links also have the locate icon.
Connection Control
Icon To add a column.
Icon To expand the column detail section.
