MongoDB embedded document as key-val array

Question

I'm trying to use mongoose to represent an association between 3 schemas:

Schema1: {
    //fields
}

Schema2: {
    //fields    
}

Scehma3: {
   //fields
   - [Scehma1:Scehma2] - collection of key-val elements
     where the key is a ref to schema1 and val is ref to scehma2
}

Does mongoose support this king of association without creating a schema4?

MongoDB documents are based on JSON, which only supports key/values in objects and restricts keys to strings. So, the array could be a collection of objects with the keys being the ObjectId in string form -- field: [Schema.Types.Mixed]. — Jonathan Lonowski
– Jonathan Lonowski, Commented Mar 16, 2015 at 18:09
You may find How to organise a many to many relationship in MongoDB and Many-to-many relationships in CouchDB or MongoDB of interest, as well as Mongoose's guide on population. — Jonathan Lonowski
– Jonathan Lonowski, Commented Mar 16, 2015 at 18:16

jtmarmon · Accepted Answer · 2015-03-16 23:22:09Z

1

You can't create ambiguous keys in mongoose because its whole purpose is to handle your document structure for you. What you can do, however, is create an array of objects.

Schema4: {
  schemaRefs: [{
    refToSchema1: {type: mongoose.Types.ObjectId, ref: 'Schema1'},
    refToSchema2: {type: mongoose.Types.ObjectId, ref: 'Schema2'}
  }]
}

For future reference it's far easier to understand your question when you provide real examples rather than false names. Even if you falsify your example (e.g. some relationship between restaurants and customers or something) it's much easier to understand the relationship you're trying to make.

answered Mar 16, 2015 at 23:22

jtmarmon

6,2698 gold badges30 silver badges46 bronze badges

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

2 Comments

Ben Diamant Over a year ago

Hey! looks like a good direction for me, following you suggestion I can use "schemaRefs in schema3 no? why do I need a new schema for that

jtmarmon Over a year ago

oops you don't i just miscounted :D

Collectives™ on Stack Overflow

MongoDB embedded document as key-val array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related