You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 47 Next »

Filled Manually

Field TypeDescriptionData TypeExample or Length
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. In SimpleOne interface, it is displayed as an input field with a numeric value in it.

int8-9223372036854775808 ... 9223372036854775807
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.

char

ru

en





Choice-like Fields

Field TypeDescriptionData TypeExample / Length
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.

boolean
Choice

This field type implements the functionality of the choices. In SimpleOne interface, it is displayed as a drop-down list.

For this, supporting fields in the sys_db_column column were implemented. 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).

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.

varchar80 symbols
Color

This field type is intended to keep and share information about the system color or the color of the interface element. This field type is used, for example, in the Rule Styles.

varchar40 symbols
Conditions

This field type is used to build AND/OR filters. In SimpleOne interface, it is displayed as a filter configuration widget. It stores JSON condition inside.

text








  • No labels