List of data types

When configuring a database table, all fields must have a data type. It's this data type that determines what type of data can be stored in the field.

This topic describes the available data types.

Boolean

A value of true or false.

Examples

  • true
  • false

Datetime

The combination of a date and a time, using a 24-hour clock. This is based on the datetime data type in MS SQL.

Examples

  • 2007-05-08 12:35:29. 1234567 +12:15

Decimal

A decimal number.

Examples

  • 0.3333333333333333333333333333

File

The path of a file that's stored on FL0's servers. You can save files to this field with the Save File component.

Guid

A Globally Unique Identifier.

Note: GUIDs are also known as Universally Unique Identifiers (UUIDs).

Examples

  • 9d7b3591-bfbc-4378-9ef8-1ee60d8ac05a
  • bdc65f4b-a236-4daf-aebb-88c2749a2c74
  • 8d47bbb6-5949-4c06-af1d-88e8b0f21cdd

Reference

The ID of a record in a different table, indicating a relationship between the records. To learn more, see Creating relationships.

String

A sequence of characters, such as a word, phrase, or body of text.

Examples

  • hello world