Field types

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. It is stored as string 80 symbols length. 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. Different types of Choices are available (they vary by Choice Type setting on the column creation form):

• 'None';
• Drop-down with 'None';
• Drop-down without 'None' (must specify a default value).

Conditions

This field type is used to build AND/OR filters. It is stored as text (a lengthless string). In the SIMPLE interface it is displayed as a filter configuration widget. It stores condition JSON inside.

{“condition”:[[[{“field”:“\”incident\“.\“description\“”,“operator”:“is not empty”,“values”:[],“type”:“string”,“columnId”:“190",“dotWalkingPath”:“190",“tableName”:“incident”}]]],“orderBy”:[],“tableName”:“incident”}

Date

This field type stores the date in the following format: YYYY-MM-DD to within 1 day without specifying the time of the day. Its size is four bytes.

Date/Time

This field type stores 

Этот тип  поля сохраняет в себе timestamp в секундах (сколько прошло секунд с 00:00:00 UTC 1 января 1970 года, также известно как Unix time). В системе отображается как поле ввода (input field) с возможностью выбора даты из предустановленного календаря (datetime picker). Пример вывода даты в поле: 2019-04-23 05:34:15

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