Interface IndexOptions

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

The fields to index.

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

Index operator type. Postgres only

For FULLTEXT columns set your parser

Prefix to append to the index name.

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

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

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 parameter for index. Can be used to limit the index to certain rows.