CUBRID Query Brower have supported ERD feature from CUBRID Query Brower2014.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.
Click New Table button on the palette 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 are belong to same database can drag into the ERD editor.
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.
Figure-6: Select conntection tool
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.