Diagram
Adding Tables and Fields
Learn how to add and manage tables and fields in ChartDB to visualize your database schema effectively.
Add New Tables
To add new tables, you can use the sidebar or interact directly with the canvas.Click the 'Add Table' icon in the Sidebar
First, navigate to the Tables section in the ChartDB sidebar and click the ‘Add Table’ icon.
This instantly creates a new table in your diagram with a randomly generated name and a single default field.
Duplicate Existing Table via Sidebar
- Access table actions by clicking the settings icon next to the table name in the sidebar.
-
Select ‘Duplicate Table’ from the table actions menu.
Duplicate or Add Table via Right-Click on Canvas
You can also quickly add or duplicate tables directly on the canvas using the right-click context menu.
- Right-click anywhere on the canvas.
- Select ‘New Table’ to add a brand new table, or ‘Duplicate Table’ after selecting an existing table to clone it.
Managing Schemas
In ChartDB, tables are organized within Schemas. Schemas act like folders, providing a way to structure and group your tables, especially in databases like PostgreSQL and MSSQL that support them.
A diagram with multiple schemas
public schema is displayed when schemas are present in your database.
New tables added using the Add Table functionality will be placed within the currently active schema, which defaults to the public schema if not otherwise specified.
Add New Fields
Whether you’re refining your schema or adding new attributes, here’s how to add fields to your tables in ChartDB.Click the 'Add Field' Button
- Scroll to the bottom of the specific table’s details section in the sidebar. 2. Click the ‘Add Field’ button.
Click the Fields section '+' Icon
- Expand the ‘Fields’ section for the specific table in the sidebar.
-
Click the ’+’ icon next to the ‘Fields’ header.
field_4) and a default data type.
Configure Field Attributes
Once you’ve added a new field or need to modify an existing one, ChartDB provides configurable field attributes.Field Name
Field Name
To rename a field, simply click on the current field name in the sidebar and type in the new desired name.
Data Type
Data Type
To change a field’s data type, click the dropdown menu next to the current data type. This will display a list of available data types supported by your imported database.
Available data types are determined by the database you imported into ChartDB.
Nullability
Nullability
By default, new fields are often set as nullable. To toggle a field’s
nullability, click the ‘N’ icon next to the field.
Primary Key
Primary Key
To designate a field as a primary key, click the ‘P’ icon next to the field.
Unique Constraint and Comments
Unique Constraint and Comments
Click the three dots icon next to the field to access additional attributes. Check the ‘Unique’ checkbox to enforce a unique constraint. Use the ‘Comments’ text area to add field-level comments.
Field-level comments are distinct from table-level comments, which can be added in the table’s top-level settings.