package com.qxueyou.scc.school.model;

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

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

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

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


/**
 * 学生课程成绩
 * @author ody.yuan
 *
 */
@Entity
@Table(name="SCH_STUDENT_ACHIEVEMENT")
@NamedQuery(name="SchStudentAchievement.findAll", query="SELECT s FROM SchStudentAchievement s")
public class SchStudentAchievement implements Serializable,ITrace {
	
	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(generator = "hibernate-uuid")
	@GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
	@Column(name="STUDENT_ACHIENEMENT_ID", unique=true, nullable=false, length=32)
	private String studentAchienementId;

	/** 学员ID */
	@Column(name="STUDENT_ID", length=32)
	private String studentId;

	/** 课程ID  */
	@Column(name="SUBJECT_ID", length=32)
	private String subjectId;

	/** 学期ID  */
	@Column(name="TERM_ID", length=32)
	private String termId;

	/** 期中成绩  */
	@Column(name="PERIOD_ACHIEVEMENT", precision=4, scale=2)
	private BigDecimal periodAchievement;
	
	/** 期末成绩  */
	@Column(name="FINAL_ACHIEVEMENT", precision=4, scale=2)
	private BigDecimal finalAchievement;

	/** 平时成绩  */
	@Column(name="PERFORMANCE", precision=4, scale=2)
	private BigDecimal performance;
	
	/** 最终成绩-分数  */
	@Column(name="ACHIEVEMENT_SCORE", precision=4, scale=2)
	private BigDecimal achievementScore;
	
	/** 最终成绩-等级  */
	@Column(name="ACHIEVEMENT_LEVEL")
	private short achievementLevel;
	
	/** 备注  */
	@Column(name="REMARK", length=255)
	private String remark;
	
	@Column(name="CREATE_ID")
	@JsonIgnore
	private String createId;

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

	@Column(name="CREATOR")
	@JsonIgnore
	private String creator;

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

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

	@Column(name="UPDATE_TIME")
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonIgnore
	private Date updateTime;

	@Column(name="UPDATOR")
	@JsonIgnore
	private String updator;

	public String getStudentAchienementId() {
		return studentAchienementId;
	}

	public void setStudentAchienementId(String studentAchienementId) {
		this.studentAchienementId = studentAchienementId;
	}

	public String getStudentId() {
		return studentId;
	}

	public void setStudentId(String studentId) {
		this.studentId = studentId;
	}

	public String getSubjectId() {
		return subjectId;
	}

	public void setSubjectId(String subjectId) {
		this.subjectId = subjectId;
	}

	public String getTermId() {
		return termId;
	}

	public void setTermId(String termId) {
		this.termId = termId;
	}

	public BigDecimal getPeriodAchievement() {
		return periodAchievement;
	}

	public void setPeriodAchievement(BigDecimal periodAchievement) {
		this.periodAchievement = periodAchievement;
	}

	public BigDecimal getFinalAchievement() {
		return finalAchievement;
	}

	public void setFinalAchievement(BigDecimal finalAchievement) {
		this.finalAchievement = finalAchievement;
	}

	public BigDecimal getPerformance() {
		return performance;
	}

	public void setPerformance(BigDecimal performance) {
		this.performance = performance;
	}

	public BigDecimal getAchievementScore() {
		return achievementScore;
	}

	public void setAchievementScore(BigDecimal achievementScore) {
		this.achievementScore = achievementScore;
	}

	public short getAchievementLevel() {
		return achievementLevel;
	}

	public void setAchievementLevel(short achievementLevel) {
		this.achievementLevel = achievementLevel;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	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;
	}
	
	
}