Navicat Data Modeler supports a simple and cosy way to add tables or entities in physical and logical models. One great feature is field type prediction. It reduces the amount of time spent on design. In this tutorial, I will show you how to design a table without opening the table designer and how the field type prediction works.
First, open a physical model in Navicat Data Modeler. In the model, click the ‘Table’ icon to add a new table to the diagram. You can simply edit the table name here. Then, press either the ‘Tab’ or ‘Down Arrow’ key. Now, you can start to enter the field name. Navicat Data Modeler will predict field types based on the field names entered. For example, if you enter ‘id’, it predicts as a primary key and sets to ‘int’. If a name contains ‘date’, it sets to ‘datetime’ type. Or, you can simply enter an ‘asterisk’ before the field name to recognize as a primary key and enter a ‘colon’ after the field name to customize the field type.