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 inside the timestamp measured in seconds. It shows how many seconds has been passed since 00:00:00 UTC 01 Jan 1970 (also known as Unix time or POSIX time). In the SIMPLE interface it is displayed as an input field with a datetime picker. The example of the datetime displayed: 2019-04-23 05:34:15.

Days of week

This field type is used to operate with days of week. In the SIMPLE interface it is displayed as a seven checkboxes. The week beginning is always Sunday. The information stored as a decimal number. It is formed like this:

• Every checkbox is stored as 1 bit. Also the status of this bit is stored (0/1, checked or not);
• So the week is the binary number that represents the sum of this bits;
• When saving in the database, this binary number has to be converted into decimal in advance.

It is stored as Small Integer.

Decimal

This field type of a variable length is implementing storage of the miscellaneous numerical data.

Document ID

This field type is used to store different ID. Physically they are stored as UUID.

UUID is written as a sequence of hex numbers in a lowercase, divided by a minus sign into several groups like this:

• Eight-digit group;
• Three groups of four digits each;
• 12-digit group.

It is 32 digits and 128 bits total.

Example: 00000000-0040-0000-0000-000000000008.

You can see it on the record create/edit page. It is displayed as

На странице создания/редактирования записи отображается как текстовый input + кнопка dictionary, при нажатии появляется модальное окно с двумя полями: drop&down с таблицами и поле с dictionary с возможностью выбора записи таблицы.

Due Date

This field type stores inside the timestamp measured in seconds. It shows how many seconds has been passed since 00:00:00 UTC 01 Jan 1970 (also known as Unix time or POSIX time). In the SIMPLE interface it is displayed as an input field with a datetime picker. The example of the datetime displayed: 2019-04-23 05:34:15.

Enum form_split_element_type

This is an options set (‘split’, ‘end_split’, ‘begin_split’}, very system field type. It is used only in the sys_ui_form_element table and stores the separator name

Float

This field type implements a floating point number.

Html

This field type is stored as text and implemented as rich text widget, It has different settings which are displayed as HTML tags in a database.

When this field is Read-Only, the data is displayed as HTML; otherwise it's displayed as text able to edit and transform.

Image

Integer

Journal Input

Json

List

Password

Percent Complete

Phone

Reference

Script

Small Integer

String

Text

Time

URL

This field type