Schema Editor

The schema editor has been designed with ease of use in mind. It is equipped with a smart field completion and table templates, all of which allow for a fast and easy creation of database schema. Datazenit also gives suggestions on the most appropriate indexes and foreign keys that should be implemented in your columns and table structure.

With pre-defined table templates you can decrease the time spent building standard tables. The autocomplete feature will populate column settings automatically whenever possible. For example, in MySQL a column called “user_id” will most probably be an unsigned integer column with the length of 11. In this example, a foreign key and an index will be suggested too. Of course, all these settings can be customized or disabled completely.

Next: Data Visualization