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

Compare with Current View Page History

« Previous Version 46 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








  • No labels

© 2019-2024, SimpleOne

https://simpleone.ru