Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Filled Manually
description
Field Type | Description | Data Type | Length or Example |
---|---|---|---|
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 |
Decimal???? | |||
Encrypted Password | This field type is used to provide secure password storage in the database, with the decoding ability (2-way encryption). Before saving, password encodes basing on one of the encryption algorithm and a random string, Before usage, decoding performs. | varchar | 128 symbols |
Choice-like Fields
description
Field Type | Description | Data Type | Length or Example | |||||||
---|---|---|---|---|---|---|---|---|---|---|
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.
| varchar | 80 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. | varchar | 40 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 | ||||||||
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. | 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. | timestamp | 2019-04-23 05:34:15 | |||||||
Days of week???? | ||||||||||
Document ID | This field type is used to store various ID. Physically they are stored as UUID.
| uuid | УМЕСТИТЬ ПРИМЕР: 00000000- 0040- 0000-0000-000000000008 | |||||||
Table of Contents | ||||
---|---|---|---|---|
|