MongoDB - Mongoose：文档结构/体系结构(MongoDB - Mongoose: document structure/architecture)

 我有一个相对简单的问题，然而，我一直被卡住，一遍又一遍。 我认为这是我第四次尝试重新构建我的文档以尝试获得理想的结果。 
 
 我想用以下结构在猫鼬中创建一个数据库： 
 
 用户有许多组 ， 帖子和评论 。 组 ， 帖子和评论都属于用户 。 帖子可以属于很多组 ，或者没有。 评论属于某个帖子 。 
 
 这是我到目前为止： 
 
 UserSchema 
 
var userSchema = mongoose.Schema({

    local            : {
        email        : String,
        password     : String,
        username     : String,  
        created: {type:Date, default: Date.now} 

    }

});
 
 PostSchema 
 
var PostSchema   = new Schema({
    url: String, 
    highlighted: String, 
    comment: String, 
    image: String, 
    timeStamp: String, 
    description: String, 
    title: String,
    created: {type:Date, default: Date.now}, 
    private: Boolean, 
    favorite: Boolean, 
    readlater: Boolean, 
    postedBy: {
        type: mongoose.Schema.Types.ObjectId,
        ref: 'User'
    },
    comments: [{
        text: String,
        postedBy: {
            type: mongoose.Schema.Types.ObjectId,
            ref: 'User'
        }
    }], 
    groups: [{
        name: String,
        postedBy: {
            type: mongoose.Schema.Types.ObjectId,
            ref: 'User'
        }
    }]
});
 
 groupSchema 
 
var GroupSchema = Schema({
    name    : String, 
    created: {type:Date, default: Date.now},
    postedBy: {
        type: mongoose.Schema.Types.ObjectId,
        ref: 'User'
    }
});
 
 虽然我可能在这个假设上是错误的，但我认为我已经向用户发表了评论，并且发表了评论，以仅仅以它应该的方式发布关系。 如果我错了，请纠正我。 我现在面临的主要问题是与我的小组发布关系。 目前，根本没有任何关系。 据我所知，就好像这个小组属于这个职位，而不是相反。 我能想到构建团队的唯一方式就是这样： 
 
var GroupSchema = Schema({
        name    : String, 
        created: {type:Date, default: Date.now},
        postedBy: {
            type: mongoose.Schema.Types.ObjectId,
            ref: 'User'
        }, 
        posts: [{
            title: String, 
            Url: String,
            comments: [{
                text: String
            }]
            etc....
        }]
    });
 
 我在上面的结构中可以看到的唯一问题是该帖子将被要求成为一个组的一部分，我希望这个组成为可选组。 所以据我所知，这也行不通。 
 
 如果有什么建议可以提供关于这应该如何结构，这将帮助我很大。 
 
 先谢谢你。 

I have a relatively simple question, however, I keep getting stuck, over and over again. I think this is the fourth time I have tried to re-structure my documents to try and get the desired result. 
 
I want to create a database in mongoose with the following structure:
 
A User has many groups, posts and comments. The groups, posts and comments all belong to a User. A post can belong to many groups, or none. And a comment belongs to a certain post. 
 
Here is what I have so far:
 
UserSchema
 
var userSchema = mongoose.Schema({

    local            : {
        email        : String,
        password     : String,
        username     : String,  
        created: {type:Date, default: Date.now} 

    }

});
 
PostSchema
 
var PostSchema   = new Schema({
    url: String, 
    highlighted: String, 
    comment: String, 
    image: String, 
    timeStamp: String, 
    description: String, 
    title: String,
    created: {type:Date, default: Date.now}, 
    private: Boolean, 
    favorite: Boolean, 
    readlater: Boolean, 
    postedBy: {
        type: mongoose.Schema.Types.ObjectId,
        ref: 'User'
    },
    comments: [{
        text: String,
        postedBy: {
            type: mongoose.Schema.Types.ObjectId,
            ref: 'User'
        }
    }], 
    groups: [{
        name: String,
        postedBy: {
            type: mongoose.Schema.Types.ObjectId,
            ref: 'User'
        }
    }]
});
 
groupSchema
 
var GroupSchema = Schema({
    name    : String, 
    created: {type:Date, default: Date.now},
    postedBy: {
        type: mongoose.Schema.Types.ObjectId,
        ref: 'User'
    }
});
 
Although I may be wrong on this assumption, I think I have the post to user and comment to post relationship just the way it should be. Please correct me if I am wrong. The main problem I am having right now is with my group to post relationship. Currently, there is no relationship at all. As far as I can, it is almost as if the group belongs to the post, instead of the other way around. The only other way I can think to structure the group would be like so: 
 
var GroupSchema = Schema({
        name    : String, 
        created: {type:Date, default: Date.now},
        postedBy: {
            type: mongoose.Schema.Types.ObjectId,
            ref: 'User'
        }, 
        posts: [{
            title: String, 
            Url: String,
            comments: [{
                text: String
            }]
            etc....
        }]
    });
 
The only problem I can see in the structure above is that the post will be required to be part of a group, which I want to be optional. So as far as I can tell, this will not work either. 
 
If there is any advice you can provide in regards to how this should be structured, it would help me greatly. 
 
Thank you in advance. 

原文：https://stackoverflow.com/questions/33932925