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 stores a 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 stores 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 a text input field + dictionary button. When pressed, then modal with two fields is shown:

• drop-down list with the tables;
• field with dictionary with the ability to select a table entry.

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’}, 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

This field type is used to store images. It stores reference to the image inside and displayed as an input field. Physically it is implemented as a string 100 symbols length which has varchar type.

Integer

This is numeric field type, four bytes in size. The range of numbers that can be stored - (-2147483648 .. +2147483647).

Journal Input

This field type is used to operate with the comment widget for the intermediate data storage when the comments have been adding. It is implemented as a text-area with a placeholder of the field title. Routinely, it stores NULL inside. When the comment is adding, the field value saving the following data to the sys_journal_field_list table:

• reference to the commented record;
• reference to the table containing this field;
• the comment itself;
• commentator name (user who has added the comment);
• field name.

After the comment saving the field value becomes NULL again.

Json

This field type is physically stored as JSON. Example:

{   “name”:“John”,   “age”:30,   “cars”: {     “car1”:“Ford”,     “car2”:“BMW”,     “car3”:“Fiat”   }  }

List

This field type is physically implemented as a lengthless text string. It stores ID's of the records of the specified table, comma-separated. It is displayed as a list of record values (which are the references to the record edit page), separated by the comma. When the field is unlocked, then the multiple-selecting function is available. It provides you the functionality of the adding, previewing and deleting records.

Password

This field type is physically implemented as a string 255 symbols length which has varchar type, It is displayed as an input field with password type.

Percent Complete

Данный тип поля используется для обозначения количества процентов выполнения задачи. Тип хранения данных - decimal. Отображается как обычный текстовый input.

Phone

Reference

Script

Small Integer

String

Text

Time

URL

This field type