File size: 1,321 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
import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
  CreateDateColumn,
} from 'typeorm';
import { User } from '../../auth/entities/user.entity';

export enum MetricType {
  ENGAGEMENT = 'engagement',
  PERFORMANCE = 'performance',
  PARTICIPATION = 'participation',
  TIME = 'time',
}

@Entity('learning_analytics')
export class LearningAnalytics {
  @PrimaryGeneratedColumn({
    name: 'analytics_id',
    type: 'bigint',
    unsigned: true,
  })
  analyticsId: number;

  @Column({ name: 'user_id', type: 'bigint', unsigned: true })
  userId: number;

  @Column({ name: 'course_id', type: 'bigint', unsigned: true })
  courseId: number;

  @Column({
    name: 'progress_id',
    type: 'bigint',
    unsigned: true,
    nullable: true,
  })
  progressId: number;

  @Column({ name: 'metric_type', type: 'enum', enum: MetricType })
  metricType: MetricType;

  @Column({
    name: 'metric_value',
    type: 'decimal',
    precision: 10,
    scale: 2,
  })
  metricValue: number;

  @Column({ name: 'metric_date', type: 'date' })
  metricDate: Date;

  @Column({ name: 'additional_data', type: 'longtext', nullable: true })
  additionalData: string;

  @CreateDateColumn({ name: 'created_at' })
  createdAt: Date;

  @ManyToOne(() => User)
  @JoinColumn({ name: 'user_id' })
  user: User;
}