Spaces:
Sleeping
Sleeping
File size: 1,539 Bytes
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 | import {
Entity,
PrimaryGeneratedColumn,
Column,
ManyToOne,
JoinColumn,
CreateDateColumn,
} from 'typeorm';
import { User } from '../../auth/entities/user.entity';
@Entity('course_analytics')
export class CourseAnalytics {
@PrimaryGeneratedColumn({
name: 'analytics_id',
type: 'bigint',
unsigned: true,
})
analyticsId: number;
@Column({ name: 'course_id', type: 'bigint', unsigned: true })
courseId: number;
@Column({ name: 'instructor_id', type: 'bigint', unsigned: true })
instructorId: number;
@Column({ name: 'total_students', type: 'int', default: 0 })
totalStudents: number;
@Column({ name: 'active_students', type: 'int', default: 0 })
activeStudents: number;
@Column({
name: 'average_grade',
type: 'decimal',
precision: 5,
scale: 2,
nullable: true,
})
averageGrade: number;
@Column({
name: 'average_attendance',
type: 'decimal',
precision: 5,
scale: 2,
nullable: true,
})
averageAttendance: number;
@Column({
name: 'completion_rate',
type: 'decimal',
precision: 5,
scale: 2,
nullable: true,
})
completionRate: number;
@Column({
name: 'engagement_score',
type: 'decimal',
precision: 5,
scale: 2,
nullable: true,
})
engagementScore: number;
@Column({ name: 'calculation_date', type: 'date' })
calculationDate: Date;
@CreateDateColumn({ name: 'created_at' })
createdAt: Date;
@ManyToOne(() => User)
@JoinColumn({ name: 'instructor_id' })
instructor: User;
}
|