Database Schema - laamp/Conduit GitHub Wiki

users

user: {
    _id: ObjectId,
    name: String,
    email: String,
    password: String (hashed),
    role: String,
    photo: String (url),
    date: Date created,
    projects: [
        ObjectId, ObjectId, etc...
    ],
    tasks: [
        ObjectId, ObjectId, etc...
    ],
    assignedTasks: [
        ObjectId, ObjectId, etc...
    ]
}

projects

project: {
    _id: ObjectId,
    tasks: [
        ObjectId, ObjectId, etc...
    ],
    title: String,
    description: String,
    date: Date created,
    owner: ObjectId
}

tasks

task: {
    _id: ObjectId,
    assignees: [
        ObjectId, ObjectId, etc...
    ],
    project: ObjectId,
    completed: Boolean,
    title: String,
    description: String,
    date: Date created,
    owner: ObjectId
}