You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 24 Next »
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
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_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 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.
- No labels