Options
All
  • Public
  • Public/Protected
  • All
Menu

Interface TableIndexOptions

Database's table index options.

Hierarchy

  • TableIndexOptions

Index

Properties

columnNames

columnNames: string[]

Columns included in this index.

Optional isFulltext

isFulltext: boolean

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

Optional isSpatial

isSpatial: boolean

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

Optional isUnique

isUnique: boolean

Indicates if this index is unique.

Optional name

name: string

Constraint name.

Optional where

where: string

Index filter condition.

Generated using TypeDoc