Big Integer

This is a numeric field type, using for storage very huge numbers. The size of Big Integer is eight bytes. The range of numbers that can be stored - (-9223372036854775808 .. 9223372036854775807). In the SIMPLE interface it is displayed as an input field with numeric value in it.

Boolean

This field type is implementing binary logic (True or False, 1 or 0). In the SIMPLE interface it is displayed as a checkbox. You can change its default value to TRUE or FALSE by checking or unchecking it.

Char

This field type is used for storing symbolic data (for example, hash, ID, UUID, etc). The size of Char is 32 bytes. In the SIMPLE interface it is displayed as an input field with symbolic value in it.

Choice

This field type is implementing the functionality of the choices. For this, supporting fields in sys_db_column column were implemented. In the SIMPLE interface it is displayed as a drop-down list. Configuration settings of the items to be selected are located in the sys_choice table.

Hint: when you're creating a column you can specify Choice Table and Choice Column.

Conditions

Date

Date/Time

Days of week

Decimal

Due Date

Enum form_split_element_type

Float

Html

Document ID

Image

Integer

Journal Input

Json

List

Password

Percent Complete

Phone

Reference

Script

Small Integer

String

Text

Time

URL

This field type