Mongo Db Unique Constraint issue

Question

Developing ERP system for schools. So i have SCHOOL Schema and inside which i have referenced COURSE Schema. What i wanted to do is to have some fields inside COURSE schema unique like course name inside particular school. But if i mark the fields unique in schema itself it will cause problems.

One school can have multiple courses but the name of courses should be unique for that particular school. But two different schools can have courses with same name. eg:- school A has btech so school A can't have other course document with same name but school B can have course with the name btech.

If i make the course_name field unique in schema itself i can't add course_name which has been added in some other school already.

I can make this happen by fetching the db and then checking the course_name one-by-one. But i think that would not be the ideal solution.

Please let me know of some better solutions

I using MONGO DB.

//SCHOOL SCHEMA
const SchoolSchema = 
mongoose.Schema({
 course: [{ type:
 mongoose.Schema.Types.ObjectId,
    ref: 'course'
 }]
})

//Course Schema
const CourseSchema = 
 mongoose.Schema({course_name: {
    type: String,
}

Joe · Accepted Answer · 2021-11-29 07:00:36Z

1

In order to have the database enforce uniqueness on the school + course_name combination, both fields will need to be in the same collection.

The simplest way would be to include the school name or _id in the course schema.

answered Nov 29, 2021 at 7:00

Joe

29k4 gold badges25 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Prasoon Shukla Over a year ago

I have added school_name in my course schema but can't figure out what to do next. Please provide more details after what to do after adding the school_name in course schema.

Joe Over a year ago

stackoverflow.com/questions/35920733/… discusses creating a compound index with options - does that help?

Prasoon Shukla Over a year ago

Yes that surely does.

Collectives™ on Stack Overflow

Mongo Db Unique Constraint issue

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related