package com.qxueyou.scc.exercise.model;

import java.io.Serializable;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.util.Date;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;

import org.hibernate.annotations.GenericGenerator;
import org.springframework.format.annotation.DateTimeFormat;

import com.fasterxml.jackson.annotation.JsonIgnore;
import com.qxueyou.scc.base.model.ITrace;


/**
 * The persistent class for the exercise_favorite_record database table.
 * 
 */
@Entity
@Table(name="exercise_favorite_record")
@NamedQuery(name="ExerciseFavoriteRecord.findAll", query="SELECT e FROM ExerciseFavoriteRecord e")
public class ExerciseFavoriteRecord implements Serializable,ITrace {
	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(generator = "hibernate-uuid")
	@GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
	@Column(name="FAVORITE_RECORD_ID", unique=true, nullable=false, length=32)
	private String favoriteRecordId;
	
	@Column(name="FAVORITE_BOOK_ID", length=32)
	private String favoriteBookId;
	
	@Column(name="EXERCISE_GROUP_ID", length=32)
	private String exerciseGroupId;
	
	@Column(name="EXERCISE_GROUP_TYPE", length=32)
	private short exerciseGroupType;

	@Column(name="ACCURACY", precision=10, scale=2)
	private BigDecimal accuracy;

	@Column(name="COMPLETION_RATE", precision=10, scale=2)
	private BigDecimal completionRate;

	@Column(name="CORRECT_COUNT")
	private BigInteger correctCount;
	
	@Column(name="DO_COUNT")
	private BigInteger doCount;
	
	@Column(name="TITLE_MAX_NUMBER", length=32)
	private String titleMaxNumber;

	@Column(name="CREATE_ID", nullable=false, length=32)
	@JsonIgnore
	private String createId;

	@Column(name="CREATE_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonIgnore
	private Date createTime;

	@Column(name="CREATOR", nullable=false, length=100)
	@JsonIgnore
	private String creator;

	@Column(name="DELETE_FLAG", nullable=false)
	@JsonIgnore
	private boolean deleteFlag;

	@Column(name="UPDATE_ID", length=32)
	@JsonIgnore
	private String updateId;

	@Column(name="UPDATE_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonIgnore
	private Date updateTime;
	
	/** 答案更新时间  */
	@Column(name="ANSWER_UPDATE_TIME")
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonIgnore
	private Date answerUpdateTime;

	@Column(name="UPDATOR", length=100)
	@JsonIgnore
	private String updator;
	
	@Column(name="SCORE",precision=10, scale=2)
	private BigDecimal score;
	
	@Column(name="STATUS", length=32)
	private String status;
	
	@OneToMany(fetch = FetchType.LAZY, mappedBy = "favorBook")
	@JsonIgnore 
	private List<ExerciseFavorite> favors;
	
	@ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.LAZY)
    @JoinColumn(name = "FAVORITE_BOOK_ID", referencedColumnName="FAVORITE_BOOK_ID",updatable=false,insertable=false)
	@JsonIgnore
	private ExerciseFavoriteBook favorBook;
	
	/** 题目总数  */
	@Column(name="ALL_COUNT")
	private BigInteger allCount;
	
	public String getFavoriteRecordId() {
		return favoriteRecordId;
	}

	public void setFavoriteRecordId(String favoriteRecordId) {
		this.favoriteRecordId = favoriteRecordId;
	}

	public String getFavoriteBookId() {
		return favoriteBookId;
	}

	public void setFavoriteBookId(String favoriteBookId) {
		this.favoriteBookId = favoriteBookId;
	}

	public String getExerciseGroupId() {
		return exerciseGroupId;
	}

	public void setExerciseGroupId(String exerciseGroupId) {
		this.exerciseGroupId = exerciseGroupId;
	}

	public short getExerciseGroupType() {
		return exerciseGroupType;
	}

	public void setExerciseGroupType(short exerciseGroupType) {
		this.exerciseGroupType = exerciseGroupType;
	}

	public BigDecimal getAccuracy() {
		return accuracy;
	}

	public void setAccuracy(BigDecimal accuracy) {
		this.accuracy = accuracy;
	}

	public BigDecimal getCompletionRate() {
		return completionRate;
	}

	public void setCompletionRate(BigDecimal completionRate) {
		this.completionRate = completionRate;
	}

	public BigInteger getCorrectCount() {
		return correctCount;
	}

	public void setCorrectCount(BigInteger correctCount) {
		this.correctCount = correctCount;
	}

	public BigInteger getDoCount() {
		return doCount;
	}

	public void setDoCount(BigInteger doCount) {
		this.doCount = doCount;
	}

	public String getTitleMaxNumber() {
		return titleMaxNumber;
	}

	public void setTitleMaxNumber(String titleMaxNumber) {
		this.titleMaxNumber = titleMaxNumber;
	}

	public String getCreateId() {
		return createId;
	}

	public void setCreateId(String createId) {
		this.createId = createId;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public String getCreator() {
		return creator;
	}

	public void setCreator(String creator) {
		this.creator = creator;
	}

	public boolean getDeleteFlag() {
		return deleteFlag;
	}

	public void setDeleteFlag(boolean deleteFlag) {
		this.deleteFlag = deleteFlag;
	}

	public String getUpdateId() {
		return updateId;
	}

	public void setUpdateId(String updateId) {
		this.updateId = updateId;
	}

	public Date getUpdateTime() {
		return updateTime;
	}

	public void setUpdateTime(Date updateTime) {
		this.updateTime = updateTime;
	}

	public String getUpdator() {
		return updator;
	}

	public void setUpdator(String updator) {
		this.updator = updator;
	}

	public BigDecimal getScore() {
		return score;
	}

	public void setScore(BigDecimal score) {
		this.score = score;
	}

	public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public List<ExerciseFavorite> getFavors() {
		return favors;
	}

	public void setFavors(List<ExerciseFavorite> favors) {
		this.favors = favors;
	}

	public BigInteger getAllCount() {
		return allCount;
	}

	public void setAllCount(BigInteger allCount) {
		this.allCount = allCount;
	}

	public Date getAnswerUpdateTime() {
		return answerUpdateTime;
	}

	public void setAnswerUpdateTime(Date answerUpdateTime) {
		this.answerUpdateTime = answerUpdateTime;
	}
	public ExerciseFavoriteBook getFavorBook() {
		return favorBook;
	}

	public void setFavorBook(ExerciseFavoriteBook favorBook) {
		this.favorBook = favorBook;
	}
	
}