创建具有关联数据的复合索引?

本文介绍了创建具有关联数据的复合索引?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个用户表和一个 userAttributes 表.每个用户每个userAttribute只能有一个实例，所以我想为列名和userId创建一个复合唯一索引(由userAttributes.belongsTo创建.)如何做到这一点?

I have a User-table and a userAttributes table. Every user can only have one instance of each userAttribute, so I would like to create a composite unique index for the columns name and userId(That is created by userAttributes.belongsTo.) How can this be done?

UserAttribute = sequelize.define('userAttributes', { name: { type: Sequelize.STRING, allowNull: false, unique: 'nameIndex', validate: { isIn: [['phone', 'name','driverRequest']], } }, value: { type: Sequelize.STRING, allowNull: false }, }); User.hasMany(userAttributes, {unique: 'nameIndex'}); userAttributes.belongsTo(User, {unique: 'nameIndex'});

我尝试添加唯一的 nameIndex 没有成功，它似乎只适用于名称列.

I tride adding the unique nameIndex with no success, it seems to only apply to the name-column.

推荐答案

var Sequelize = require('sequelize'); var sequelize = new Sequelize('<yourDatabaseName>', '<yourUserName>', '<yourPassword', { host: '<ip>' }); var User = sequelize.define('user', { id: { type: Sequelize.STRING, allowNull: false, primaryKey: true }, }); var UserAttribute = sequelize.define('userattribute', { userId: { type: Sequelize.STRING, allowNull: false, unique: 'compositeIndex', references: { model: User, key: "id" } }, name: { type: Sequelize.STRING, allowNull: false, unique: 'compositeIndex' } }); User.hasOne(UserAttribute, { as: "UserAttribute" }) UserAttribute.belongsTo(User, { foreignKey: "userId", as: 'UserId' }) sequelize.sync({ // use force to delete tables before generating them force: true }).then(function() { console.log('tables have been created'); return User.create({ id: 'randomId1' }); }) .then(function() { console.log('tables have been created'); return User.create({ id: 'randomId2' }); }) .then(function() { return UserAttribute.create({ userId: 'randomId1', name: 'name1' }); }) .then(function() { return UserAttribute.create({ userId: 'randomId2', name: 'name1' }); }) // // generates Validation Error // .then(function() { // return UserAttribute.create({ // userId: 'randomId1', // name: 'name1' // }); // })