Datatypes
Deskree datatypes are not database-native types provided by the database company. Instead, it is an abstraction of those types with some additional functionality. We use those values to type-check the data sent via the APIs before it arrives in the database
Below is the list of all current datatypes and their description of use:
Datatype Name | Internal Format | Description | Limitations |
---|---|---|---|
UID | UID | Unique identifier of an object | One default column per table |
String | String | Any string data including json | <1Mb |
Integer | Integer | Any integer values (ex. 10, 12, 16) | 64-bit |
Float | Float | Any float values (ex. 10.20, 12.10, 16.14) | 64-bit |
Boolean | Boolean | true or false | |
Array of Strings | Array<string> | Array containing only string values. (ex. ["one", "two", "three"] | <1Mb |
Array of Integers | Array<integer> | Array containing only integer values. (ex. [1, 2, 3] | <1Mb |
Array of Floats | Array<float> | Array containing only float values. (ex. [1.2, 2.5, 3.1] | <1Mb |
Array of Booleans | Array<boolean> | Array containing only boolean values. (ex. [true, false] | <1Mb |
Storage | Storage | base64 string, fileURL, or data stream of a file that needs to uploaded to storage. When getting the data via API, a signed url to the uploaded file will be returned in the response. For more information view the Uploading Filespage. | Maximum base64 string file size is 4Mb
Maximum fileURL size is 50Mb
Maxium data stream size is 500Mb |
One-to-one reference | Users<string> | One-to-one reference to another object via UID. | |
One-to-many reference | Users<Array<string>> | One-to-many reference to other objects via UIDs. | |
Map | Map | Valid Object type | <1Mb |
If a column is set as required, the value must be provided during the API request, otherwise a
422
error will be returned.In the internal format, those values are marked with
?
sign at the end of the data type. For example, an optional String data type will be String?
Currently, there is no separate DateTime type available. However, this can be saved and queried/sorted in the database as a String datatype. For instance,
createdAt
and updatedAt
columns have String data type with data in ISO8601 format:YYYY-MM-DDTHH:mm:ssZ
Example:2021-06-29T15:27:34-04:00
Last modified 2mo ago