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

sequelize validate unique index in two columns

Gifted Gazelle answered on November 18, 2021 Popularity 2/10 Helpfulness 1/10

answer sequelize validate unique index in two columns

sequelize validate unique index in two columns

Comment

var Tag = sequelize.define('Tag', {
    id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
    },
    user_id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
    },
    count: {
        type: DataTypes.INTEGER(11),
        allowNull: true
    },
    name: {
        type: DataTypes.STRING,
        allowNull: true,
    }
},
{
    indexes: [
        {
            unique: true,
            fields: ['user_id', 'count', 'name']
        }
    ]
});

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: two-columns unique-index whatever

Link to this answer
Share Copy Link