Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

cubrid-manager-erd-editor


CUBRID Manager have supported ERD feature from CUBRID Manager2014.01. You can edit/view schema information expediently by it. 

1. Open ERD editor

1.1

Select the database node in the navigation tree, click "ERD Editor" on the context menu or click Pro tools–>ERD Editor on the toolbar to open ERD editor.

Open ERD editor

Figure-1: Open ERD edtor from context menu.

 

Open ERD editor

Figure-2: Open ERD edtor by toolbar.

 

1.2

If you want to open an ERD Editor which isnot based on any database. You could select a database folder/host node/logout database node(or donot select any node on the navigator tree), then click "ERD Editor" on the context menu or click Pro tools–>ERD Editor on the toolbar. Then the ERD editor is not based on any database, you could drag any table from any database or import tables from any files.

2. Create new table

Click New Table button on the toolbar of ERD editor to create a new table. Then you can edit the table by the context menu. 

Create table

Figure-3: Create table

3. Drag existed tables to ERD editor

Select the tables in the navigation tree, then drag the tables to ERD editor. 

NOTE: Only user tables which belong to the same database can drag into the ERD editor. But if the ERD doesnot belong to any database, you could drag tables from any database node.

4. Edit table

Double click table or right click the table then select "Edit table" on the context menu to edit the table.

Edit table

Figure-4: Edit table

5. Add/Delete column

Click “Add column” on the context menu to add a new column and click “Delete column” to delete the column. 

Add or delete column

Figure-5: Add/Delete column

6. Add foreign key

 1. Select “Connection” tool on the palette.

erd_new_connection_line

Figure-6: Create conntection

2. Select the table then click the primary table. An "Add Foreign key" dialog will pop up. Then set the foreign relation ship.

Set the relation ship for FK

Figure-7: Set relationships

NOTE: The primary table must contain primary key and corresponding columns in the foreign key and the referenced key must have similar data types.

7. Delete foreign key

You can select a foreign key and Press “Del” button on the keyboard to delete the foreign key.

8. Import schema data from file

You can import schema data from *.erd or *.xml data file.

  • *.erd file is defined by CUBRID TOOLS. It contains the schema information and the location information of table figures on the ERD canvas.
  • *.xml file on the ERD is a format file defined by ERwin.  

1. Click  Open file  button in the ERD editor toolbar to open schema data file.

NOTE: The existed tables on the ERD Editor will be cleaned after you import the schema data file. 

2. Click “OK” to confirm to clean the exist data. 

Confirm to clean the data

Figure-8: Confirm to clean the data.

3. Click “Browse” to select the schema data file.  

Browse the file

Figure-9: Open ERD file.

4. Click “OK” to open the file. 

ERD editor

9. Export data to file

Click  Save button  button to save the schema data to file. CUBRID TOOLS support the file of *.erd, *.xml, *.sql and image(*.jpg,...).

10. Compare schema data

Click Compare button  button to get the differents from ERD editor to current database. 

11. Thumbnail

You could see a thumbnail on the left-down of the application when you edit the ERD canvas. And you can drag mouse on it to view.

thumbnail

12. Other tools

  1. Zoom in/Zoom out:Zoom in/Zoom out all the figures.
  2. Ctrl+A: Select all the tables.
  3. Ctrl+S: Save the schema data to the file.
  4. Ctrl+Mouse click: Select multi objects.
  5. Auto layout : Arrange all the figures antomatically.
  6. Find: We support find the schema by name.
  7. Drag Map: If you click-down the mouse at any blank space on the ERD canvas, then you could drag-move the canvas.
comments powered by Disqus
Page info
viewed 637 times
translations en
Author
posted 6 months ago by
Kevin.Wang
Contributors
updated 4 months ago by
View revisions
tagged
Share this article