Field types

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 stored data - int8. The range of numbers that can be stored - (-9223372036854775808 .. 9223372036854775807). In SimpleOne interface,, it is displayed as an input field with a numeric value in it.

Boolean

This field type implements binary logic (True or False, 1 or 0). In SimpleOne 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 stored data - 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 SimpleOne interface, it is displayed as an input field with the symbolic value in it.

Type of the stored data - char.

Choice

This field type implements the functionality of the choices. For this, supporting fields in the sys_db_column column were implemented. The field stores a string 80 symbols length that has varchar type. In SimpleOne interface, it is displayed as a drop-down list. Configuration settings of the items to be selected are located in the sys_choice table. Various 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

Hint: when 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 SimpleOne interface, it is displayed as a filter configuration widget. It stores condition JSON inside.

Condition

{“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 stored data - 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 SimpleOne 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 stored data - timestamp.

Days of week

This field type is used to operate with days of the week. In SimpleOne interface, it is displayed as seven checkboxes. The week beginning is always Sunday. The information is 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 stored data - int2.

Decimal

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

Document ID

This field type is used to store various ID. 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.

Duration

This field type stores time interval in milliseconds between two points specified. In SimpleOne interface, it is displayed as an amount of the days, hours, minutes and seconds.

Type of the stored data - int8.

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 SimpleOne 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 stored data - timestamp.

Encrypted Password

This field type is used to provide secure password storage in the database, with the decoding ability (2-way encryption).

This field type is physically implemented as a string 128 symbols length which has varchar type,

Before saving, password encodes basing on one of the encryption algorithm and a random string, Before usage, decoding performs.

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 stored data - 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 stored data - eight bytes.

Float

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

Html

This field type is stored as text and implemented as rich text widget, It has various 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 uploaded image files. In SimpleOne interface, it is displayed as a file upload modal window.

Type of the stored data - varchar.

Integer

This is a numeric field type. Size of the stored data - 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_activities_stream_field 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 stored data - text.

Json

This field type is physically stored as JSON. Example:

JSON

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

Type of the stored data - 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.

Page tree