Database Tables

How Database Tables are setup

Xano's Database Table view gives you a high-level overview of the individual tables (or entities) and their associated schema. Database schema shown underneath each table is a blueprint of the database table which specifies what fields are present and their associated types. For example, the user table pictured above has an id column represented by an integer and a name column which is represented by text.

Viewing Database Table Relationships

Database Tables almost always have some sort of relationship to one another. Clicking on the "Show Table Relationships" checkbox will show how each table is related to one another.

You can see the fields that map the Database tables together

Sorting, Filtering, and Views

1. Use this option to switch between card and list view

2. Use this option to filter your tables by their assigned tags

3. Use this icon to sort your table list by the selected column

Adding a new Database Table

1. Add - Add a new table

2. Import - Import a CSV and create a new table with the CSV data

3. Table Name - The name of your new table

4. Primary Key Type - Choose between a sequential integer or a randomly generated UUID. Xano maintains the ID field for you. It is not currently possible to define a custom primary key.

5. Description - Give your table an internal description

6. Tag - Add a tag (or multiple tags) to your new database table

7. Add Basic CRUD Endpoints - Xano can auto-generate some basic endpoints for your new table to perform the following actions via API.

   1. Get All Data

   2. Get Specific Data

   3. Create New Data

   4. Update Existing Data

   5. Delete Data

Thinking through the Database Tables for your App