EntitySchemaIndexOptions

Hierarchy

EntitySchemaIndexOptions

Index

Properties

Optional columns

columns: function | string[]

Index column names.

Optional fulltext

fulltext: undefined | true | false

The FULLTEXT modifier indexes the entire column and does not allow prefixing. Works only in MySQL.

Optional name

name: undefined | string

Index name.

Optional sparse

sparse: undefined | true | false

If true, the index only references documents with the specified field. These indexes use less space but behave differently in some situations (particularly sorts). This option is only supported for mongodb database.

Optional spatial

spatial: undefined | true | false

The SPATIAL modifier indexes the entire column and does not allow indexed columns to contain NULL values. Works only in MySQL.

Optional synchronize

synchronize: undefined | true | false

Indicates if index must sync with database index.

Optional unique

unique: undefined | true | false

Indicates if this index must be unique or not.

Optional where

where: undefined | string

Index filter condition.