@Table(name = "user")

public class User {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int userId;

    private String identityCard;

    private String userName;

    private String password;

    private String firstName;

    private String lastName;

    private String email;

    private String phone;

    private String gender;

    private String address;

    private String imageMiddle;

    private String imageSmall;

    private String webSite;

    private String description;

    private LocalDate birthday;

    private LocalDate createDate;

    private LocalDateTime lastOnLineTime;

    @Transient

    private String title;

    @Transient

    private String image;

    @Transient

    private boolean rememberMe;

    @Transient

    private String newPassword;

    @Transient

    private List<Role> roles;

}

@Entity

@Table(name = "role")

public class Role {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int roleId;

    private String roleName;

    private String roleDesc;

    @Transient

    private boolean selected;

}

@Entity

@Table(name = "resource")

public class Resource {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int resourceId;

    private String resourceName;

    private String permission;

    @Transient

    private List<Role> roles;

}

@Entity

@Table(name = "user_role")

public class UserRole {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int userRoleId;

    private int userId;

    private int roleId;

}

@Entity

@Table(name = "role_resource")

public class RoleResource {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int roleResourceId;

    private int roleId;

    private int resourceId;

}

@Entity

@Table(name = "skill")

public class Skill {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int skillId;

    private int userId;

    private String skillName;

    private int applyMonths;

    private double graspDegree;

}

@Entity

@Table(name = "calendar_day")

public class CalendarDay {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private LocalDate date;

    private int type;

    private int weekNumber;

    private String weekName;

    private boolean isHoliday;

    private String holidayName;

    private int wage;

    private int rest;

}

@Entity

@Table(name = "building")

public class Building {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String buildingNo;

    private String buildingName;

    private String buildingDesc;

    @Transient

    private List<ClassRoom> classRooms;

    @Transient

    private List<College> colleges;

}

@Entity

@Table(name = "building_college")

public class BuildingCollege {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String buildingNo;

    private String collegeNo;

}

@Entity

@Table(name = "classes")

public class Classes {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String classesNo;

    private String collegeNo;

    private String classesName;

    private Integer studentNumber;

    @Transient

    private String universityNo;

}

@Entity

@Table(name = "classes_schedule")

public class ClassesSchedule implements Serializable {

    private static final long serialVersionUID = 519331018139467363L;

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    @Excel(name = "id", orderNum = "0", width = 15)

    private Long id;

    // 学期，以起止时间标识2020-02-01@2020-07-01

    private String semester;

    private String collegeNo;

    private String classesNo;

    private String courseNo;

    private String teacherNo;

    @Excel(name = "classRoomNo", orderNum = "5", width = 25)

    private String classRoomNo;

    @Excel(name = "scheduleTime", orderNum = "6", width = 25)

    private String scheduleTime;

    private double fitness;

    @Transient

    @Excel(name = "collegeName", orderNum = "1", width = 20)

    private String collegeName;

    @Transient

    @Excel(name = "classesName", orderNum = "2", width = 20)

    private String classesName;

    @Transient

    @Excel(name = "courseName", orderNum = "3", width = 20)

    private String courseName;

    @Transient

    @Excel(name = "teacherName", orderNum = "4", width = 20)

    private String teacherName;

    @Transient

    private College college;

    @Transient

    private Classes classes;

    @Transient

    private Course course;

    @Transient

    private Teacher teacher;

    @Transient

    private ClassRoom classRoom;

}

@Entity

@Table(name = "classes_task")

public class ClassesTask {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private Long id;

    // 学期，以起止时间标识2020-02-01@2020-07-01

    private String semester;

    private String collegeNo;

    private String classesNo;

    private String courseNo;

    private String teacherNo;

    private Integer studentNumber;

    // 总课时数

    private int classTimeCount;

    // 课程附加属性map装载，解析成json字符串形式

    private String courseAttr;

    @Transient

    private String collegeName;

    @Transient

    private String classesName;

    @Transient

    private String courseName;

    @Transient

    private String teacherName;

    @Transient

    private String classRoomNo;

    // 每两课时计划时间，每天五次，每次两节，20200323@01，代表2020-03-23上午一二节课

    @Transient

    private String scheduleTime;

    @Transient

    private College college;

    @Transient

    private Classes classes;

    @Transient

    private Course course;

    @Transient

    private Teacher teacher;

    @Transient

    private ClassRoom classRoom;

    @Transient

    private List<Building> buildings;

}

@Entity

@Table(name = "class_room")

public class ClassRoom {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String buildingNo;

    private String classRoomNo;

    private String classRoomName;

    private Integer capacity;

    private String classRoomAttr;

}

@Entity

@Table(name = "college")

public class College {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String collegeNo;

    private String collegeName;

    private String collegeDesc;

    private String universityNo;

    @Transient

    private University university;

}

@Entity

@Table(name = "course")

public class Course {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String courseNo;

    private String courseName;

    private String courseAttr;

    private String collegeNo;

    @Transient

    private String universityNo;

}

@Entity

@Table(name = "semester")

public class Semester {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String semesterNo;

    private String semesterPeriod;

    private String semesterName;

    private String semesterDesc;

    private String universityNo;

}

@Entity

@Table(name = "teacher")

public class Teacher {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String teacherNo;

    private String collegeNo;

    private String teacherName;

    private Integer age;

    private String title;

    @Transient

    private String universityNo;

}

@Entity

@Table(name = "teacher_course")

public class TeacherCourse {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String teacherNo;

    private String courseNo;

    private String classNo;

    private String classRoomNo;

    private String classTime;

}

@Entity

@Table(name = "university")

public class University {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String universityNo;

    private String universityName;

    private String universityDesc;

}