Big Integer

It's a numeric field type used for the storage of the very huge numbers. Size of the data stored is eight bytes. Type of the data stored - int8. The range of numbers that can be stored - (-9223372036854775808 .. 9223372036854775807). In the SIMPLE interface,, it is displayed as an input field with a 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.

Type of the data stored - boolean.

Char

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

Type of the data stored - char.

Choice

This field type is implementing the functionality of the choices. For this, supporting fields in the sys_db_column column were implemented. It stores a string 80 symbols length that has varchar type. 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).

Hint: when you're creating a column you can specify Choice Table and Choice Column. In this case, the Choice Column values will be the options for the values of the specified table in the Choice Table.

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 and without specifying the time of the day. Size of the data stored is four bytes. Type of the data stored - date.

Date/Time

This field type stores inside the timestamp measured in seconds. It shows how many seconds have 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 date and time picker. The example of the date and time displayed: 2019-04-23 05:34:15.

Type of the data stored - timestamp.

Days of week

This field type is used to operate with days of the week. In the SIMPLE interface, it is displayed as 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 these bits;
  • When saving in the database proceeds, this binary number has to be converted into decimal in advance.

It is stored as Small Integer.

Type of the data stored - int2.

Decimal

This field type of a variable length is implementing storage of the miscellaneous numerical data. Type of the data stored - decimal.

Document ID

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

UUID is written as a sequence of hex numbers in 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 are shown:

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

Type of the data stored - uuid.

Due Date

This field type stores inside the timestamp measured in seconds. It shows how many seconds have 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 date and time picker. The example of the date and time displayed: 2019-04-23 05:34:15.

Type of the data stored - timestamp.

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.

Type of the data stored - enum_form_split_element_type.

Field Name

This field is always paired up with the reference field that is referring to the sys_db_table table. For example:

  • The field with this type is named Columns;
  • The field it depends on is named Tables.

If the data in the Table field is changed, then into the Columns field will be loaded columns from the Table table.

Size of the data stored - eight bytes.

Float

This field type implements a floating point number. Type of the data stored - float4.

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 the database.

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

Image

This field type is used to store images. It stores a 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 a numeric field type. Size of the data stored - four bytes. Type of the data stored - int4. 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 (the user who has added the comment);
  • field name.

After the comment saving the field value becomes NULL again.

Type of the data stored - text.

Json

This field type is physically stored as JSON. Example:

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

Type of the data stored - jsonb.

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

This field type is used to show the progress of task completion. Type of data storage - decimal. In the SIMPLE interface, it is displayed as an input field.

Phone

This field type is physically implemented as a string 15 symbols length. Type of the data stored - varchar. It stores a phone number inside, In the SIMPLE interface, it is displayed as an input field with the phone number.

Example: +74952128506.

Reference

This field type works like external key and stores the ID of the record of the specified table. This table must be specified in the Reference ID. It is physically stored as Big Integer.

Script

This field type is physically implemented as a lengthless text string. In the SIMPLE interface, it is displayed as a CodeMirror widget (JS component that provides ability of the code editing in the browser) .

Small Integer

This is numeric field type. Size of the data stored - two bytes. Type of the data stored - int2. The range of numbers that can be stored - (-32768 .. +32767).

String

This field type is physically implemented as a string 255 symbols length. Type of the data stored - varchar. In the SIMPLE interface, it is displayed as a text input field,

Text

This field type is physically implemented as a lengthless text string. The memory is allocated dynamically when processing the field. In the SIMPLE interface, it is displayed as a textarea.

Time

This field type is used for time storage. Timezone is not taken into account. The date is not stored. Size of the data stored - eight bytes. Type of the data stored - time. Format of the time storage is HH:MM:SS.

URL

This field type is used to store URL. Physically it is stored as a string 255 symbols length. Type of the data stored - varchar.