[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:556](https://github.com/evoluhq/evolu/blob/037c390af081e9944d616ff298a729515c5c5ab7/packages/common/src/Sqlite.ts#L556)

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 {
  name: string;
  sql: string;
} & {
}[];
```

#### Inherited from

```ts
InferType.indexes;
```

---

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

### tables

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

#### Inherited from

```ts
InferType.tables;
```