Setting unique compound index in schema definition

Working with Data Node.js Frameworks
,
1

I would like to have a combination of 3 keys (type, parent and name) as unique compound index. I defined the schema as follows, but I can still create a unit that has the same type, parent and name. What am I missing?

  const unitSchema = new mongoose.Schema({
    name: {
      type: String,
      required: true,
    },
    type: {
      type: String,
      required: true,
    },
    parent: {
      type: String,
      required: true,
    },
    administrators: {
      type: Array,
      required: true,
    },
  });

  unitSchema.index({ type: 1, parent: 1, name: 1 }, { unique: true });

  const Unit = mongoose.model('Unit', unitSchema);
2

I am wondering of this may help

3

Thank you @Natac13! It worked!!

As the author of this article says, it’s pretty weird that we have to use mongoose-unique-validator to accomplish this.

4

There is also this option I remembered

5

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.