Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat for MongoDB, Navicat Premium

Apply Navicat Version No.: Version 10.x or above

Navicat will predict field types according to field names you entered when you design table without using Table Designer.

INTEGER/int/int4/NUMBER

- suffix "id", "no" (if it is the first column, it will be predicted as a primary key)

- suffix "num"

- "qty", "number"

- exactly "age", "count"

DECIMAL(10,2)/decimal(10,2)/NUMBER/REAL/money

- suffix "price", "cost", "salary"

FLOAT/double/float8/NUMBER/REAL/float

- "size", "height", "width", "length", "weight", "speed", "distance"

DATE/datetime/date/TEXT/datetime2

- "date", "time"

VARCHAR(255)/varchar(255)/VARCHAR2(255)/TEXT

- other field names