package com.qxueyou.scc.school.model;

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

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.Table;

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

import com.qxueyou.scc.base.model.ITrace;
import com.qxueyou.scc.teach.subject.model.Subject;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.qxueyou.scc.user.model.UserStudent;


/**
 * 学生课表  实体类
 * @author ody.yuan
 *
 */
@Entity
@Table(name="SCH_STUDENT_SCHEDULE")
@NamedQuery(name="SchStudentSchedule.findAll", query="SELECT s FROM SchStudentSchedule s")
public class SchStudentSchedule implements Serializable,ITrace {
	
	private static final long serialVersionUID = 1L;

	/** 课程主键 */
	@Id
	@GeneratedValue(generator = "hibernate-uuid")
	@GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
	@Column(name="STUDENT_SCHEDULE_ID", unique=true, nullable=false, length=32)
	private String studentScheduleId;

	/** 课程名称*/
	@Column(name="NAME", length=150)
	private String name;

	/** 上课内容，简介 */
	@Column(name="CONTENT")
	private String content;
	
	@Column(name="TEACHER",length=50)
	private String teacher;

	@Column(name="TEACHER_ID", length=32)
	private String teacherId;
	
	/** 班级ID */
	@Column(name="CLASS_ID", length=32)
	private String classId;

	/** 学校专业  */
	@Column(name="COLLEGE_COURSE_ID", length=32)
	private String collegeCourseId;
	
	/** 课程ID */
	@Column(name="SUBJECT_ID", length=32)
	private String subjectId;
	
	/** 图片路径  */
	@Column(name="IMG_PATH", length=32)
	private String imgPath;
	
	/** 学期ID  */
	@Column(name="TERM_ID", length=32)
	private String termId;
	
	/** 学员ID */
	@Column(name="STUDENT_ID", length=32)
	private String studentId;
	
	/** 上课地址ID  */
	@Column(name="ADDRESS_ID", length=32)
	private String addressId;

	/** 状态 */
	@Column(name="STATUS")
	private short status;
	
	/** 地址 */
	@Column(name="ADDRESS", length=255)
	private String address;

	/** 结束时间 */
	@Column(name="END_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm")
	private Date endTime;

	/** 开始时间 */
	@Column(name="START_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm")
	private Date startTime;
	
	/** 高校课表使用：第几节课开始ID  */
	@Column(name="DAY_START_ID", length=32)
	private String dayStartId;
	
	/** 高校课表使用：第几节课开始序号  */
	@Column(name="DAY_START_ORDER")
	private short dayStartOrder;
	
	/** 高校课表使用：第几节课结束ID  */
	@Column(name="DAY_END_ID", length=32)
	private String dayEndId;
	
	/** 高校课表使用：第几节课结束序号  */
	@Column(name="DAY_END_ORDER")
	private short dayEndOrder;
	
	/**班级课表主键*/
	@Column(name="CLASS_SCHEDULE_ID",  length=32)
	private String classScheduleId;
	
	@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)
	private String creator;
	
	/**  修改人ID  */
	@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="UPDATOR", length=100)
	@JsonIgnore
	private String updator;

	@Column(name="DELETE_FLAG", nullable=false)
	@JsonIgnore
	private boolean deleteFlag;
	
	/** 学生 */
	@ManyToOne(cascade = CascadeType.REFRESH,fetch = FetchType.LAZY)
    @JoinColumn(name = "STUDENT_ID",referencedColumnName="STUDENT_ID",updatable=false,insertable=false)
	@JsonIgnore
	private UserStudent userStudent;
	
	@ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.LAZY)
	@JoinColumn(name = "SUBJECT_ID",referencedColumnName="SUBJECT_ID",updatable=false,insertable=false)
	@JsonIgnore
	private Subject subject;

	public String getStudentScheduleId() {
		return studentScheduleId;
	}

	public void setStudentScheduleId(String studentScheduleId) {
		this.studentScheduleId = studentScheduleId;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

	public String getTeacher() {
		return teacher;
	}

	public void setTeacher(String teacher) {
		this.teacher = teacher;
	}

	public String getTeacherId() {
		return teacherId;
	}

	public void setTeacherId(String teacherId) {
		this.teacherId = teacherId;
	}

	public String getClassId() {
		return classId;
	}

	public void setClassId(String classId) {
		this.classId = classId;
	}

	public String getCollegeCourseId() {
		return collegeCourseId;
	}

	public void setCollegeCourseId(String collegeCourseId) {
		this.collegeCourseId = collegeCourseId;
	}

	public String getSubjectId() {
		return subjectId;
	}

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

	public String getImgPath() {
		return imgPath;
	}

	public void setImgPath(String imgPath) {
		this.imgPath = imgPath;
	}

	public String getTermId() {
		return termId;
	}

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

	public String getStudentId() {
		return studentId;
	}

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

	public String getAddressId() {
		return addressId;
	}

	public void setAddressId(String addressId) {
		this.addressId = addressId;
	}

	public short getStatus() {
		return status;
	}

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

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public Date getEndTime() {
		return endTime;
	}

	public void setEndTime(Date endTime) {
		this.endTime = endTime;
	}

	public Date getStartTime() {
		return startTime;
	}

	public void setStartTime(Date startTime) {
		this.startTime = startTime;
	}

	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 getDayStartId() {
		return dayStartId;
	}

	public void setDayStartId(String dayStartId) {
		this.dayStartId = dayStartId;
	}

	public short getDayStartOrder() {
		return dayStartOrder;
	}

	public void setDayStartOrder(short dayStartOrder) {
		this.dayStartOrder = dayStartOrder;
	}

	public String getDayEndId() {
		return dayEndId;
	}

	public void setDayEndId(String dayEndId) {
		this.dayEndId = dayEndId;
	}

	public short getDayEndOrder() {
		return dayEndOrder;
	}

	public void setDayEndOrder(short dayEndOrder) {
		this.dayEndOrder = dayEndOrder;
	}

	public UserStudent getUserStudent() {
		return userStudent;
	}

	public void setUserStudent(UserStudent userStudent) {
		this.userStudent = userStudent;
	}

	public String getClassScheduleId() {
		return classScheduleId;
	}

	public void setClassScheduleId(String classScheduleId) {
		this.classScheduleId = classScheduleId;
	}

	public Subject getSubject() {
		return subject;
	}

	public void setSubject(Subject subject) {
		this.subject = subject;
	}

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