File size: 1,458 Bytes
ffb4c35 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 | const mongoose = require('mongoose');
const taskSchema = new mongoose.Schema({
title: {
type: String,
required: true,
trim: true
},
description: {
type: String,
trim: true
},
assignee: {
type: mongoose.Schema.Types.ObjectId,
ref: 'User',
required: true
},
creator: {
type: mongoose.Schema.Types.ObjectId,
ref: 'User',
required: true
},
priority: {
type: String,
enum: ['low', 'medium', 'high'],
default: 'medium'
},
status: {
type: String,
enum: ['pending', 'in-progress', 'completed', 'cancelled'],
default: 'pending'
},
deadline: {
type: Date,
required: true
},
tags: [{
type: String,
trim: true
}],
attachments: [{
filename: String,
url: String,
uploadedAt: {
type: Date,
default: Date.now
}
}],
comments: [{
user: {
type: mongoose.Schema.Types.ObjectId,
ref: 'User'
},
text: String,
createdAt: {
type: Date,
default: Date.now
}
}],
progress: {
type: Number,
min: 0,
max: 100,
default: 0
},
estimatedHours: {
type: Number,
default: 0
},
actualHours: {
type: Number,
default: 0
}
}, {
timestamps: true
});
// Index for better query performance
taskSchema.index({ assignee: 1, status: 1 });
taskSchema.index({ creator: 1 });
taskSchema.index({ deadline: 1 });
module.exports = mongoose.model('Task', taskSchema); |