Data Types and DBMS Features
Column type choices in the ERD are shown for the connected DBMS. You can manage DBMS built-in types, user-defined types, and table options in one place.
How Type Lists Are Built
The Data Type cell in the column grid shows a type list for the current Connection's DBMS. Displayed types and apply results can differ across DBMSs such as MySQL, PostgreSQL, Oracle, SQL Server, and SQLite.
| Item | Behavior |
|---|---|
| Built-in types | Provides commonly used types for the selected DBMS as a list. |
| Manual input | You can manually enter types that are not in the list. |
| Size and scale | For types that need it, specify length and decimal digits together. |
| Default value | Enter literal values, SQL expressions, or an unset state separately. |
Default Value Input Mode
In the Default Value cell, you can specify the nature of the value. Enter strings and numbers as Value, and database functions or sequences such as CURRENT_TIMESTAMP or seq.nextval as Expression.
| Mode | Behavior |
|---|---|
| Value | Generates DDL as a literal value according to the column type and DBMS rules. |
| Expression | Applies the entered SQL expression to DDL without wrapping it in quotes. |
| Not Set | Removes the column default value. |
User-Defined Types
If the database has user-defined types, they appear in the column type list. NeoSQL supports PostgreSQL enum, domain, composite, and range families, Oracle Object Type, and SQL Server alias/CLR type. If types with the same name exist in multiple Schemas, they are distinguished by Schema name.
If a user-defined type does not appear, refresh the Schema or category and check again.
ENUM and SET Values
MySQL/MariaDB built-in ENUM or SET types can be edited in a separate value-list modal. PostgreSQL enum works by selecting a user-defined type already defined in the DB, and if you change to another type, the previous value list is no longer used.
| Situation | Result |
|---|---|
| ENUM/SET selected | Manage allowed values through the value-list editing modal. |
| Changed to another type | The existing value list is removed and only the new type is applied. |
| UDT enum selected | Select a type already defined in the DB. |
Extra Table Properties
For MySQL/MariaDB connections, you can select Engine, Character Set, and Collation in the table basic information area of the detail panel. When Character Set changes, the available Collation list is updated together.
| Option | Description |
|---|---|
| Engine | Select a storage engine provided by the server. |
| Character Set | Select the table's default character set. |
| Collation | Select a sorting rule available for the selected Character Set. |
| Apply to DB | Review changed options in the DDL preview before applying them to the DB. |