Node.js - Mongoose - How should I assign multiple Many-to-One relationships in this case?

Question

In this case, I need to assign multiple Many-to-One relationships, as you can see below:

var portfolioSchema = new Schema({
    volatility         :  Number,
    bonds              :  {
        percentage          :  { type: Number, default: 0.6 },
        USA                 :  {
            percentage           :  { type: Number, default: 0.7 },
            treasury             :  {
                percentage            :  { type: Number, default: 0.4 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            },
            municipal            :  {
                percentage            :  { type: Number, default: 0.2 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            },
            corporate            :  {
                percentage            :  { type: Number, default: 0.4 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            }
        },
        international       :  {
            percentage           :  { type: Number, default: 0.3 },
            developed            :  {
                percentage            :  { type: Number, default: 0.7 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            },
            emergent        :  {
                percentage            :  { type: Number, default: 0.3 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            }
        }
    },
    stocks          :  {
        percentage          :  { type: Number, default: 0.4 },
        USA                 :  {
            percentage           :  { type: Number, default: 0.7 },
            largeCaps            :  {
                percentage            :  { type: Number, default: 0.4 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            },
            mediumCaps           :  {
                percentage            :  { type: Number, default: 0.4 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            },
            smallCaps            :  {
                percentage            :  { type: Number, default: 0.2 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            }
        },
        international       :  {
            percentage           :  { type: Number, default: 0.3 },
            developed            :  {
                percentage            :  { type: Number, default: 0.7 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            },
            emergent        :  {
                percentage            :  { type: Number, default: 0.3 },
                securities            :  [ { type: ObjectId, ref: 'Security' } ]
            }
        }
    },
    _goal           :  { type: ObjectId, ref: 'Goal' }
});

var securitySchema = new Schema({
    name               :  { type: Date, required: true },
    avgReturn          :  Number,
    avgRisk            :  Number,
    percentage         :  Number
});

However, It seems to me that it would be easier to simply use an Array data type instead of [ { type: ObjectId, ref: 'Security' } ].

I am not sure about what I should do. Anyone would know the appropriate way to do this? Thank you!

What is `Array` data type? And why do you think it's different to `[]` data type? — Vasyl Boroviak, Mar 18 '15 at 00:20
I don't think it's different. My doubt is whether I should use just `Array` or `[ { type: ObjectId, ref: 'Security' } ]`. — bmpasini, Mar 18 '15 at 00:45

score 1 · Accepted Answer · answered Apr 22 '15 at 00:52

1

If you arrays are going to be only composed by your Security objects, you should use [ { type: ObjectId, ref: 'Security' } ].

answered Apr 22 '15 at 00:52

score 0 · Answer 2 · edited May 23 '17 at 11:58

0

You should not write the word Array in mongoose schemas. Here is a relevant answer. How to define object in array in Mongoose schema correctly with 2d geo index

So, the short answer to your question is: Use [ { type: ObjectId, ref: 'Security' } ].

edited May 23 '17 at 11:58

Community

1
1

answered Mar 18 '15 at 00:48

Vasyl Boroviak

5,959
5
51
70

I'm sorry, but the answer you said is relevant doesn't help me. It suggests using `Arrays` instead... Why would you suggest using `[ { type: ObjectId, ref: 'Security' } ]`? Could you please be more specific? – bmpasini Mar 18 '15 at 18:50

Node.js - Mongoose - How should I assign multiple Many-to-One relationships in this case?

2 Answers2