Docs
The schema designer
Underneath the reviews is a full schema designer. Use it to set up a project, or on its own.
Tables and relationships
- Double-click the canvas, or press T, to add a table.
- Select a table to edit it in the panel on the right: columns, types, keys, indexes, checks and comments.
- Drag from one column to another to connect tables. JillionDB adds the relationship and an index for it.
- Tidy layout lays everything out neatly. Positions never change your database.
Import what you have
Use Import SQL and paste or drop a schema dump: pg_dump, mysqldump, SQLite’s .schema, or the schema files from Rails, Django and Laravel. Anything that can’t be read is listed with its line before you import. Nothing is dropped quietly.
SQL, both ways
Open the SQL panel to see the schema as SQL for the chosen database. You can type in it: the canvas follows, and tables keep their identity and place.
Issues
The Issues panel lists design problems as you work: tables without a primary key, relationships without an index, mismatched types, and things a particular database can’t do.
Versions
Save a version before a big change. Compare shows the difference on the canvas and as a migration, with the same risk levels as a review.