Tables / Columns
Learn how to create, view, edit, and delete tables and columns in the ERD.
Add Table
Add a new table to the ERD canvas.
Click Add Table Button
Click the "Add Table" button in the toolbar, or right-click on the canvas and select "New Table".
Enter Table Name
Enter the table name. The table will appear as a node on the canvas.
Add & Edit Columns
Add columns to a table and configure their properties.
Double-click Table
Double-click a table node to enter column editing mode.
Enter Column Information
Set the column name, data type, nullable, default value, and more.
Set PK
Select the PK checkbox for columns to be used as the Primary Key.
View Table List
View the list of tables in the database connected via the connection.
You can filter tables by name using the search bar at the top of the table list.
View in Detail Tab
When you select a table, a detail tab opens at the bottom. In the detail tab, you can view and edit detailed information such as columns, indexes, FK, and data.
| Area | Content |
|---|---|
| Database Table Information | Schema, table name, description, engine/charset, and other basic table information |
| Table Columns | Column name, type, PK, N/N (Not Null), A/I (Auto Increment), default value, comments - view/edit |
| Foreign Keys | View, add, and delete FK list |
| Indexes | View, add, and delete index (including Unique) list |
Save / Restore Table
You can save table structure changes made in the ERD to the current project without applying them to the database.
When there are unsaved changes in a table, the restore button becomes active. Click it to revert to the last saved version.
Apply to Database
Apply the table structure designed in the ERD to the actual database.
Select the changed tables and run the apply to database function. CREATE/ALTER DDL will be auto-generated and applied to the database.
Delete
Delete a table or column.
| Target | Delete Method |
|---|---|
| Table | Select the table, then choose "Delete Table" |
| Column | Click the delete (-) button on the column row in column editing mode |
Note: When you delete a table that has relation lines connected, those relation lines are also deleted. For tables with FK relations, you must first remove the FK from the referencing table before deleting.
