Skip to main content
Tables are database tables you create inside a project. Columns define the fields each record can store. Column names are validated, and supported types are INTEGER, REAL, TEXT, BLOB, and ANY.

​
Defaults

  • If you create a table without a primary key column, ZangTable automatically adds an id column as an integer primary key.
  • If you create a column without passing column_type, ZangTable uses TEXT.
  • The API does not automatically add created_at or updated_at columns. Add those yourself if your app needs them.

​
Typical flow

  1. Create a table with initial columns.
  2. Add or rename columns through the column endpoints.
  3. Use indexes for fields that power list filters and sort views.

Create table

List columns

Create index

Records guide