Quiz.java 2.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. package nju.seec.helper.entity;
  2. import lombok.Data;
  3. import nju.seec.helper.util.enums.QuizState;
  4. import nju.seec.helper.util.enums.SlideState;
  5. import org.springframework.data.annotation.CreatedDate;
  6. import org.springframework.data.jpa.domain.support.AuditingEntityListener;
  7. import javax.persistence.*;
  8. import java.time.LocalDateTime;
  9. import java.util.List;
  10. @Data
  11. @Entity
  12. @Table(name = "quiz", indexes = {@Index(columnList = "course"), @Index(columnList = "slide")}
  13. , uniqueConstraints = @UniqueConstraint(name = "测试名约束", columnNames = {"teacher", "name"}))
  14. @EntityListeners(AuditingEntityListener.class)
  15. public class Quiz {
  16. @Id
  17. @GeneratedValue(strategy = GenerationType.IDENTITY)
  18. @Column(name = "id")
  19. private Long id;
  20. @Basic
  21. @Column(name = "name", nullable = false)
  22. private String name;
  23. @ManyToOne(cascade = CascadeType.DETACH, fetch = FetchType.LAZY)
  24. @JoinColumn(name = "slide", referencedColumnName = "id")
  25. private Slide slide;
  26. @ManyToOne(cascade = CascadeType.DETACH, fetch = FetchType.LAZY)
  27. @JoinColumn(name = "course", referencedColumnName = "id")
  28. private Course course;
  29. @ManyToOne(cascade = CascadeType.DETACH, fetch = FetchType.LAZY)
  30. @JoinColumn(name = "teacher", referencedColumnName = "id")
  31. private User teacher;
  32. @ElementCollection
  33. private List<String> questions;
  34. @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  35. @JoinColumn(name = "studentScore")
  36. private List<StudentScore> studentScore;
  37. @Enumerated(value = EnumType.STRING)
  38. @Column(name = "quizTime")
  39. private SlideState quizTime = SlideState.BEFORE_CLASS;
  40. @Enumerated(value = EnumType.STRING)
  41. @Column(name = "state", nullable = false)
  42. private QuizState state;
  43. @Basic
  44. @Column(name = "create_at", nullable = false)
  45. @CreatedDate
  46. private LocalDateTime createAt;
  47. @Basic
  48. @Column(name = "modified_at", nullable = false)
  49. @CreatedDate
  50. private LocalDateTime modifiedAt;
  51. }