API reference / @evolu/common / Evolu/Internal / DefaultColumns

Variable: DefaultColumns

const DefaultColumns: ObjectType<{
  createdAt: BrandType<
    Type<"String", string, string, StringError, string, StringError>,
    "DateIso",
    DateIsoStringError,
    StringError
  >;
  isDeleted: UnionType<
    [
      Type<"Null", null, null, NullError, null, NullError>,
      TransformType<
        Type<"Boolean", boolean, boolean, BooleanError, boolean, BooleanError>,
        UnionType<[LiteralType<0>, LiteralType<1>]>,
        never
      >,
    ]
  >;
  updatedAt: BrandType<
    Type<"String", string, string, StringError, string, StringError>,
    "DateIso",
    DateIsoStringError,
    StringError
  >;
}>;

Defined in: packages/common/src/Evolu/Schema.ts:215

Default columns automatically added to all tables.

createdAt: Set by Evolu when insert is called, or can be custom with upsert.
updatedAt: Always set by Evolu, derived from CrdtMessage timestamp. If you defer sync to avoid leaking time activity, use a custom column to preserve real update time.
isDeleted: Soft delete flag.