[API reference](https://evolu.dev/docs/api-reference) › [@evolu/common](https://evolu.dev/docs/api-reference/common) › [local‑first/Schema](https://evolu.dev/docs/api-reference/common/local-first/Schema) › UpsertValues

```ts
type UpsertValues<T> = NullableColumnsToOptional<T> & {
  isDeleted?: SqliteBoolean;
};
```

Defined in: [packages/common/src/local-first/Schema.ts:288](https://github.com/evoluhq/evolu/blob/e7144e2bbe9069362b62dec1b64a8aa922b8f1b0/packages/common/src/local-first/Schema.ts#L288)

Upsert values: `id` required, nullable columns optional, non-nullable columns
required. Includes `isDeleted` for soft deletes.

## Type Declaration

| Name         | Type                                                                                | Defined in                                                                                                                                                                     |
| ------------ | ----------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `isDeleted?` | [`SqliteBoolean`](https://evolu.dev/docs/api-reference/common/Sqlite/type-aliases/SqliteBoolean) | [packages/common/src/local-first/Schema.ts:290](https://github.com/evoluhq/evolu/blob/e7144e2bbe9069362b62dec1b64a8aa922b8f1b0/packages/common/src/local-first/Schema.ts#L290) |