CUBRID Manager have supported ERD feature from CUBRID Manager2014.01. You can edit/view schema information expediently by it.
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.
Figure-1: Open ERD edtor from context menu.
Figure-2: Open ERD edtor by toolbar.
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.
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.
Figure-3: Create table
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.
Double click table or right click the table then select "Edit table" on the context menu to edit the table.
Figure-4: Edit table
Click “Add column” on the context menu to add a new column and click “Delete column” to delete the column.
1. Select “Connection” tool on the palette.
2. Select the table then click the primary table. An "Add Foreign key" dialog will pop up. Then set the foreign relation ship.
NOTE: The primary table must contain primary key and corresponding columns in the foreign key and the referenced key must have similar data types.
You can select a foreign key and Press “Del” button on the keyboard to delete the foreign key.
You can import schema data from *.erd or *.xml data file.
1. Click 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.
Figure-8: Confirm to clean the data.
3. Click “Browse” to select the schema data file.
Figure-9: Open ERD file.