package nju.seec.helper.entity; import lombok.Data; import nju.seec.helper.util.enums.QuizState; import nju.seec.helper.util.enums.SlideState; import org.springframework.data.annotation.CreatedDate; import org.springframework.data.jpa.domain.support.AuditingEntityListener; import javax.persistence.*; import java.time.LocalDateTime; import java.util.List; @Data @Entity @Table(name = "quiz", indexes = {@Index(columnList = "course"), @Index(columnList = "slide")} , uniqueConstraints = @UniqueConstraint(name = "测试名约束", columnNames = {"teacher", "name"})) @EntityListeners(AuditingEntityListener.class) public class Quiz { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id") private Long id; @Basic @Column(name = "name", nullable = false) private String name; @ManyToOne(cascade = CascadeType.DETACH, fetch = FetchType.LAZY) @JoinColumn(name = "slide", referencedColumnName = "id") private Slide slide; @ManyToOne(cascade = CascadeType.DETACH, fetch = FetchType.LAZY) @JoinColumn(name = "course", referencedColumnName = "id") private Course course; @ManyToOne(cascade = CascadeType.DETACH, fetch = FetchType.LAZY) @JoinColumn(name = "teacher", referencedColumnName = "id") private User teacher; @ElementCollection private List questions; @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY) @JoinColumn(name = "studentScore") private List studentScore; @Enumerated(value = EnumType.STRING) @Column(name = "quizTime") private SlideState quizTime = SlideState.BEFORE_CLASS; @Enumerated(value = EnumType.STRING) @Column(name = "state", nullable = false) private QuizState state; @Basic @Column(name = "create_at", nullable = false) @CreatedDate private LocalDateTime createAt; @Basic @Column(name = "modified_at", nullable = false) @CreatedDate private LocalDateTime modifiedAt; }