mongoose - How to set up Unique Compound Index in NestJS (MongoDB)

Question

Hey i have a schema for user with an unique email:

@Schema()
export class User {
    @Prop()
    firstName!: string;

    @Prop()
    lastName!: string;

    @Prop({
        unique: true,
    })
    email!: string;

    @Prop({ nullable: true })
    password?: string;
}

But now i want to extend this. I wanna have Groups with their own users. I would create a collection of groups and add their id to the users like:

@Schema()
export class User {
    @Prop()
    groupId: string;

    @Prop()
    firstName!: string;

    ...
}

For each group the email should be unique. That means in the collection of users there could be duplicate emails but they should be unique by group which is named Unique Compound Index i guess.

How do i set this up in NestJS?

question from:https://stackoverflow.com/questions/65626559/how-to-set-up-unique-compound-index-in-nestjs-mongodb

Answer 1

Waitting for answers