Text: variable-length character string.
Integer: signed four-byte integer with a range between -2147483648 to +2147483647.
Object: can point to data of any data type. You can assign a variable, constant, or expression of any data type to an object.
Table Reference: this is an integer that references another table using the id #.
File: upload a file.
Image Metadata: this allows you to upload any image files. For example: .jpg.
Video Metadata: this allows you to upload any video files. For example: .mp4.
Attachment Metadata: this allows you to upload any files with the exception of .exe.
Bool: logical Boolean (true/false).
Decimal: data type ranges from 131072 digits before the decimal point to 16383 digits after the decimal point.
Email: email address format: [email protected]
Password: this is a special case where the data is automatically encrypted using salt encryption.
Salt in cryptography, is random data that is used as an additional input to a one-way function that hashes data, a password or passphrase. Salts are used to safeguard passwords in storage.
Timestamp: this is the number of milliseconds that have elapsed since the Unix epoch.
Enum: a special data type that enables for a variable to be a set of predefined constants. The variable must be equal to one of the values that have been predefined for it.
Point (geo_point): a special type that represents a point on the map using latitude and longitude.
Point Collection (geo_multipoint): a special type that represents a collection of points on one map using latitude and longitude.
Path (geo_linestring): a collection of points that represent a line on a map using latitude and longitude of each point.
Path Collection (geo_multilinestring): a collection of lines on one map.
Polygon (geo_polygon): a collection of lines that form a multi-sided shape on a map.
Polygon Collection (geo_multipolygon): a collection of polygons on one map.