Tables

Tables are the building blocks of your schema. Each table on the canvas represents a database table—complete with columns, data types, indexes, and relationships you can define visually.

Adding a table

1. Click Add Table in the toolbar (or press T).

2. Click on the canvas to place it.

3. Type a name—the table starts with a default id column.

If you place a table over an existing group, it'll automatically become a child of that group.

Editing

Click a table to select it. The left panel lets you edit the table and its contents:

• Name — click the pencil icon or double-click the table header.

• Columns — use Add Column to add columns. Each column has a name, data type, nullable flag, and optional attributes like default values and comments.

• Indexes — use Add Index to define indexes on one or more columns.

• Color — pick from 12 colors via the color swatch in the footer.

• Comment — add a table-level comment from the options menu.

Notes

• Deleting a table also removes its columns, indexes, and connected relationships.

• Drag a table into a group region to add it to that group.