Default Values

SpacetimeDB: Default Values ↗

Column defaults are declared with .default(value) on a value type.

import * as Stdb from "effect-spacetimedb"

const profile = Stdb.table("profile", {
  public: true,
  columns: {
    id: Stdb.u64().primaryKey().autoInc(),
    displayName: Stdb.string().default("anonymous"),
    score: Stdb.u32().default(0),
    subscribed: Stdb.bool().default(false),
  },
})

Defaults use the authored TypeScript value for the wrapped Stdb.* value type. The library rejects defaults on primary keys, auto-increment columns, unique columns, and unsupported native metadata shapes.