Interface IndexOptions

Hierarchy

Properties

concurrently? fields? name? operator? parser? prefix? type? unique? using? where?

Properties

Optional concurrently

concurrently?: boolean

PostgreSQL will build the index without taking any write locks. Postgres only.

Default

false

Optional fields

fields?: (string | Fn | Literal | IndexField)[]

The fields to index.

Optional name

name?: string

The name of the index. Defaults to model name + _ + fields concatenated

Optional operator

operator?: string

Index operator type. Postgres only

Optional parser

parser?: null | string

For FULLTEXT columns set your parser

Optional prefix

prefix?: string

Prefix to append to the index name.

Optional type

type?: IndexType

Index type. Only used by mysql. One of UNIQUE, FULLTEXT and SPATIAL

Optional unique

unique?: boolean

Should the index by unique? Can also be triggered by setting type to UNIQUE

Default

false

Optional using

using?: string

The method to create the index by (USING statement in SQL). BTREE and HASH are supported by mysql and postgres. Postgres additionally supports GIST, SPGIST, BRIN and GIN.

Optional where

where?: WhereOptions<any>

Optional where parameter for index. Can be used to limit the index to certain rows.

Settings

Member Visibility

Theme

Generated using TypeDoc