Tables & Fields

Tables define your data models. Each table has an id, name, fields, and optional permissions, indexes, and views.

Table Structure

tables: - id: 1 name: tasks fields: - id: 1 name: title type: single-line-text required: true - id: 2 name: completed type: checkbox permissions: create: authenticated read: all update: [admin, member] delete: [admin] indexes: - fields: [title] unique: true

Base Field Properties

Every field has these base properties: id (unique integer), name (identifier), type (one of 41 types), and optional required, unique, description, and defaultValue.

41 Field Types

Field types are organized into 9 categories:

Text Fields

single-line-textlong-textrich-textemailurlphone-numberbarcode

Numeric Fields

numbercurrencypercentrating

Selection Fields

single-selectmulti-selectcheckboxstatus

Date & Time Fields

datedate-timetime

User Fields

usercreated-byupdated-by

Relational Fields

linklookup

Media Fields

attachmentimagefilesignature

Computed Fields

formulaauto-numberrollup

Advanced Fields

jsongeodurationbuttonai-generatedlast-modified-timecreated-time

Permissions (RBAC)

Table permissions use role-based access control. Each permission (create, read, update, delete, comment) accepts: "all" (public), "authenticated" (logged-in users), or an array of role names.

permissions: create: authenticated # Any logged-in user read: all # Public access update: [admin, member] # Specific roles delete: [admin] # Admin only comment: authenticated
←OverviewTheme→