ERD Builder

ERD Builder is a core feature that allows you to visually design database schemas with a drag-and-drop interface.

How to Create a Table

1. Click the "Add Table" button on the toolbar.
2. Enter the table name (example: users).
3. Click the "+" icon on the table to add a new column.

Configuring Columns

Each column supports various properties:

• Primary Key (PK): Unique row identifier.
• Data Type: Choose the data type that matches your database needs.
• Constraints: Such as not null, unique, or default value.

Supported Data Types

ERD Builder Pro supports a variety of standard MySQL and PostgreSQL data types. The table below shows the data type categories and their database system support:

Category	Data Type	Database
Numeric	INT, BIGINT, SMALLINT, TINYINT, MEDIUMINT, DECIMAL, NUMERIC, FLOAT, DOUBLE, REAL	MySQL / PostgreSQL
	INTEGER, SERIAL, BIGSERIAL, SMALLSERIAL, MONEY	PostgreSQL
String	VARCHAR, CHAR, TEXT	MySQL / PostgreSQL
	TINYTEXT, MEDIUMTEXT, LONGTEXT	MySQL
Date & Time	DATE, TIME, DATETIME, TIMESTAMP, YEAR	MySQL / PostgreSQL
	TIMESTAMPTZ, TIMETZ, INTERVAL	PostgreSQL
Boolean	BOOLEAN	MySQL / PostgreSQL
Binary/Blob	BINARY, VARBINARY, BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB	MySQL
	BYTEA	PostgreSQL
Identity & Special	BIT, ENUM, JSON, ULID	MySQL / PostgreSQL
	UUID, JSONB	PostgreSQL
Network & Search	INET, CIDR, MACADDR, MACADDR8, TSVECTOR, TSQUERY	PostgreSQL

Creating Relationships

To create relationships between tables (Foreign Key):

1. Point your cursor to the handle (white dot) next to the column.
2. Click and drag a line to the column in the target table.
3. You can set the relationship type (one-to-one, one-to-many) through that connector line.

Auto Layout

If your diagram starts to look cluttered or tables overlap each other, you can use the Auto Layout feature:

1. Click the "Auto Layout" icon (grid/layout icon) on the toolbar.
2. The system will automatically calculate the optimal position for each table based on existing relationships to minimize intersecting lines (edge crossing).

Export Diagram (Experimental)

[!CAUTION] The diagram export feature to image format (PNG/SVG) or PDF is currently in Experimental stage. You may encounter slight visual differences in the exported file compared to the editor view.

To export the diagram, click the Download icon on the editor toolbar.