API reference › @evolu/common › local‑first/Schema › SystemColumns

const SystemColumns: object({
  createdAt: DateIso,
  updatedAt: DateIso,
  isDeleted: /*#__PURE__*/ nullOr(SqliteBoolean),
  ownerId: OwnerId,
});

Defined in: packages/common/src/local-first/Schema.ts:164

System columns that are implicitly defined by Evolu.

  • createdAt: Set by Evolu on row creation, derived from Timestamp.
  • updatedAt: Set by Evolu on every row change, derived from Timestamp.
  • isDeleted: Soft delete flag created by Evolu and used by the developer to mark rows as deleted.
  • ownerId: Represents ownership and logically partitions the database.
Markdown for LLMs