Breaking News: Grepper is joining You.com. Read the official announcement!

adding indexing on a db model in mysql using sequelize

Beautiful Baboon answered on December 27, 2021 Popularity 3/10 Helpfulness 7/10

answer adding indexing on a db model in mysql using sequelize

adding indexing on a db model in mysql using sequelize

Comment

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;
};

Popularity 3/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: indexing model mysql sql using

Link to this answer
Share Copy Link

Contributed on Dec 27 2021

Beautiful Baboon

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

adding indexing on a db model in mysql using sequelize

Contents

More Related Answers

adding indexing on a db model in mysql using sequelize

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.