SystemColumns

Type

The columns every row carries automatically. You never declare or set them.

The columns every table has without your declaring them. They are added to read results and stripped from write inputs, so you read id, created_at, updated_at, and last_updated_by freely but never pass them to push or update. Ordering by created_at orders by age, and last_updated_by records who last touched the row, drawn from the caller's auth context.

SystemColumns.ts

interface SystemColumns {
  id: string
  created_at: number
  updated_at: number
  last_updated_by: string
}

Fields

string

AutoUUID assigned on insert if you do not supply one.

created_at

number

AutoUnix epoch milliseconds, set once when the row is first written.

updated_at

number

AutoUnix epoch milliseconds, rewritten on every mutation to the row.

last_updated_by

string

AutoThe id of the user whose auth context performed the last write.

Read the system columns

const v = await Vendors.get(id);
v.id;              // string
v.created_at;      // number (unix ms)
v.last_updated_by; // user id