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.
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.
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.
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):
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. |
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”} |
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.
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.
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:
It is stored as Small Integer.
Type of the data stored - int2.
This field type of a variable length is implementing storage of the miscellaneous numerical data. Type of the data stored - decimal.
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:
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:
Type of the data stored - uuid.
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.
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.
This field is always paired up with the reference field that is referring to the sys_db_table table. For example:
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.
This field type implements a floating point number. Type of the data stored - float4.
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.
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.
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).
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:
After the comment saving the field value becomes NULL again.
Type of the data stored - text.
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.
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.
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.
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.
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.
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.
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) .
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).
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,
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.
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.
This field type is used to store URL. Physically it is stored as a string 255 symbols length. Type of the data stored - varchar.