Managing your Databases
The Entity Relationship Diagram
When you select a database from the list, you'll be shown an Entity Relationship Diagram that visualizes the relationships between tables and columns. Each box represents a table and every line underneath it is a column. The green lines represent foreign keys.
Important to note is that you must press Save to update your database after any changes are made. This also saves your current view position and zoom level.
Adding a New Table
To add a new table to your database, press the Add New Table button. This will generate a table without any columns and with a default name. To edit your table name, you can type in a new name and press the Enter key. Then press Save after! Please note that it is best practice to only rename tables during early-stage database planning, as this does not automatically rename all the related constraints in a SQL database.
Adding a New Column
To add a column to an existing table, press the Add Column button. You can customize the column name, type, or constraints by pressing the small arrow on each column. Remember to save your work regularly!
