Defining Schema

The schema is a JSON object sent to PUT /p/{id}/v1/schema:

{
  "tables": {
    "users": {
      "columns": {
        "display_name": "string",
        "avatar": "file",
        "role": { "type": "enum", "values": ["user", "admin"], "default": "user" }
      },
      "auth_table": true  // auto-creates email + password_hash
    },
    "posts": {
      "columns": {
        "user_id": "ref users required",
        "title": "string required",
        "body": "text",
        "published": "bool default false"
      },
      "access": { "read": "public", "create": "authenticated", "update": "owner", "delete": "owner" },
      "owner_field": "user_id"
    }
  }
}

Built-in columns

Every table automatically gets these — never define them:

• id — UUID v4, primary key
• created_at — ISO 8601 timestamp, set on insert
• updated_at — ISO 8601 timestamp, updated on every change

Table options