[API reference](https://evolu.dev/docs/api-reference) › [@evolu/common](https://evolu.dev/docs/api-reference/common) › [Sqlite](https://evolu.dev/docs/api-reference/common/Sqlite) › SqliteSchema

Defined in: [packages/common/src/Sqlite.ts:520](https://github.com/evoluhq/evolu/blob/e7144e2bbe9069362b62dec1b64a8aa922b8f1b0/packages/common/src/Sqlite.ts#L520)

Full schema metadata for a [Sqlite](https://evolu.dev/docs/api-reference/common/Sqlite/interfaces/Sqlite) database.

Includes table-column mappings and user-visible indexes.

## Extends

- [`InferType`](https://evolu.dev/docs/api-reference/common/Type/type-aliases/InferType)\<_typeof_ [`SqliteSchema`](https://evolu.dev/docs/api-reference/common/Sqlite/variables/SqliteSchema)\>

## Properties

<a id="indexes"></a>

### indexes

```ts
indexes: readonly Readonly<{
  name: string;
  sql: string;
}>[];
```

#### Inherited from

[`SqliteSchema`](https://evolu.dev/docs/api-reference/common/Sqlite/interfaces/SqliteSchema).[`indexes`](https://evolu.dev/docs/api-reference/common/Sqlite/interfaces/SqliteSchema#indexes)

---

<a id="tables"></a>

### tables

```ts
tables: Readonly<Record<string, ReadonlySet<string>>>;
```

#### Inherited from

[`SqliteSchema`](https://evolu.dev/docs/api-reference/common/Sqlite/interfaces/SqliteSchema).[`tables`](https://evolu.dev/docs/api-reference/common/Sqlite/interfaces/SqliteSchema#tables)