Xano supports a number of different field types to be used in the building of your database.
While Xano's table editor might appear like a standard spreadsheet, it can store rich content in each cell. For example, a table can contain records (rows) with attachments, files, checkboxes, location data, links to records in other tables, and much more.
The data type is for the Database to understand what type of data is expected inside of each column, and it's always a way to ensure data is stored in a consistent and known format.
Below are all of the supported Field Types in Xano:
variable-length character string.
Typically used for things like titles, names, descriptions and urlsInteger:
A number without decimals.
Used to store whole numbers like age or a credit card number
Object: An object is a collection of properties or key values. Here's a great example of what an object is.
If the object was a car, it's properties might be brand, weight, color, make, yearEnum: A list of possible values.
This is typically used when you're doing a list like roles (basic, admin, super admin).
Table Reference: this is what is used to define Table relationships. It's an integer that references another table using the id .
Used to tell Xano when one piece of content is related to another.Timestamp: A timestamp is stored as a Unix timestamp in milliseconds.
Anytime you store a date or time, you would use this field type.
JSON: Consists of 6 data types. First four data types (string, number, boolean and null) can be referred as simple data types. Other two data types (object and array) can be referred as complex data types. Here's a great article if you want to learn more.
Typically used when you are storing temporary data. a good example is user-generated data such as filling out a form or data logging.
Password: this is a special case where the data entered into this field is automatically encrypted using salt encryption. You can also configure how passwords are stored.Use to store passwords or anything sensitive
Timestamp: this is the number of milliseconds that have elapsed since the Unix epoch.
Learn more about Date & Time in Xano
API Access on field types
This feature allows you to further enforce restrictions when it comes to how your Database Fields are displayed using the API.
Public - This field is accessible to be used in any API.
Private - When you create a CRUD API endpoint that references this table, This field will be hidden from the Input section of the NO CODE API builder.
Internal - When you create a CRUD API endpoint that references this table, This field will be hidden from the Input section of the NO CODE API builder AND from the response of any Database Function that accesses it.