TableIndexOptions

Database's table index options.

Index

columnNames: string[]

Columns included in this index.

isFulltext: undefined | true | false

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

isSpatial: undefined | true | false

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

isUnique: undefined | true | false

Indicates if this index is unique.

name: undefined | string

Constraint name.

where: undefined | string

Index filter condition.