package nju.seec.helper.entity; import lombok.Data; import lombok.experimental.Accessors; import nju.seec.helper.entity.converter.MapConverter; import org.hibernate.annotations.DynamicInsert; import org.hibernate.annotations.DynamicUpdate; import org.hibernate.annotations.UpdateTimestamp; import javax.persistence.*; import java.math.BigDecimal; import java.time.LocalDateTime; import java.util.Map; /** * @author sxt *

* updated by cst */ @Data @Accessors(chain = true) @Entity @Table(name = "quiz_student_answer", uniqueConstraints = @UniqueConstraint(name = "quiz_student_unique", columnNames = {"quiz_id", "student_id"})) @DynamicUpdate @DynamicInsert public class QuizStudentAnswer { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id") private Long id; @ManyToOne(cascade = {CascadeType.DETACH, CascadeType.MERGE, CascadeType.REFRESH}, fetch = FetchType.LAZY) @JoinColumn(name = "quiz_id", foreignKey = @ForeignKey(name = "answer_quiz")) private Quiz quiz; @ManyToOne(cascade = {CascadeType.DETACH, CascadeType.MERGE, CascadeType.REFRESH}, fetch = FetchType.LAZY) @JoinColumn(name = "student_id", foreignKey = @ForeignKey(name = "answer_student")) private User student; @SuppressWarnings("all") @Convert(converter = MapConverter.class) @Column(nullable = false) private Map answers; @Column(name = "submit_at", nullable = false) @UpdateTimestamp private LocalDateTime submitAt; @Column(name = "submit_number", nullable = false, columnDefinition = "int default 1 not null") private Integer submitNumber = 0; @Column(nullable = false) private BigDecimal score; }