Spaces:
Sleeping
Sleeping
File size: 2,081 Bytes
e67d35c 9f03bd9 e67d35c 9f03bd9 e67d35c 9f03bd9 e67d35c | 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 | import {
Entity,
PrimaryGeneratedColumn,
Column,
ManyToOne,
JoinColumn,
CreateDateColumn,
UpdateDateColumn,
} from 'typeorm';
import type { Relation } from 'typeorm';
import type { User } from '../../auth/entities/user.entity';
export enum TaskType {
ASSIGNMENT = 'assignment',
QUIZ = 'quiz',
LAB = 'lab',
STUDY = 'study',
CUSTOM = 'custom',
}
export enum TaskPriority {
LOW = 'low',
MEDIUM = 'medium',
HIGH = 'high',
}
export enum TaskStatus {
PENDING = 'pending',
IN_PROGRESS = 'in_progress',
COMPLETED = 'completed',
OVERDUE = 'overdue',
}
@Entity('student_tasks')
export class StudentTask {
@PrimaryGeneratedColumn({ name: 'task_id', type: 'bigint', unsigned: true })
taskId: number;
@Column({ name: 'user_id', type: 'bigint', unsigned: true })
userId: number;
@Column({ name: 'task_type', type: 'enum', enum: TaskType })
taskType: TaskType;
@Column({ name: 'assignment_id', type: 'bigint', unsigned: true, nullable: true })
assignmentId: number | null;
@Column({ name: 'quiz_id', type: 'bigint', unsigned: true, nullable: true })
quizId: number | null;
@Column({ name: 'lab_id', type: 'bigint', unsigned: true, nullable: true })
labId: number | null;
@Column({ name: 'title', type: 'varchar', length: 255 })
title: string;
@Column({ name: 'description', type: 'text', nullable: true })
description: string | null;
@Column({ name: 'due_date', type: 'timestamp', nullable: true })
dueDate: Date | null;
@Column({ name: 'priority', type: 'enum', enum: TaskPriority, default: TaskPriority.MEDIUM })
priority: TaskPriority;
@Column({ name: 'status', type: 'enum', enum: TaskStatus, default: TaskStatus.PENDING })
status: TaskStatus;
@Column({ name: 'completion_percentage', type: 'int', default: 0 })
completionPercentage: number;
@CreateDateColumn({ name: 'created_at', type: 'timestamp' })
createdAt: Date;
@UpdateDateColumn({ name: 'updated_at', type: 'timestamp' })
updatedAt: Date;
@ManyToOne('User')
@JoinColumn({ name: 'user_id' })
user: Relation<User>;
}
|