/SQL/Adding indexing on a db model in mysql using sequelize

Adding indexing on a db model in mysql using sequelize

module.exports = (sequelize, DataTypes) => {
    const Item = sequelize.define('Item', {
        itemId:  DataTypes.STRING,
        ownerId:  DataTypes.INTEGER,
        status: DataTypes.STRING,
        type: DataTypes.STRING,
        nature: DataTypes.STRING,
        content: DataTypes.STRING,
        moment: DataTypes.BIGINT
    },
    {
      indexes:[
       {
         unique: false,
         fields:['ownerId']
       }
      ]
    });

    return Item;
};

Similar codes

19 votes205 views3 answers
How to change column type psql
SQL
0 vote207 views1 answer
Print boolean in plsql
SQL
6 votes198 views4 answers
How to remove unique key in mysql
SQL
5 votes200 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote189 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote207 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
5 votes223 views4 answers
SQL Order of execution
SQL
0 vote201 views1 answer
Postgresql delete limit
SQL
2 votes203 views4 answers
Mysql get all tables row count
SQL
0 vote276 views1 answer
Example of sql querry result sepapreted by comma
SQL