Courselist - Database

Database entities

Course list project simply take Hibernate as the database layer technology. With tools provided by tornado, most of the operations are simplified. In this project, the only thing developer need to do is creating hibernate mapping file and generate POJOs(Plain old java object).

Entity class	Table name	Description
com.cyclopsgroup.courselist.entity.Course	c_cl_course	Main course table
com.cyclopsgroup.courselist.entity.CoursePrerequisite	c_cl_course_prerequisite	Course rerequisite relation
com.cyclopsgroup.courselist.entity.Teacher	c_cl_teacher	Teacher
com.cyclopsgroup.courselist.entity.StudentCourse	c_cl_student_course	Student course relation

com.cyclopsgroup.courselist.entity.Course

Property name	Column name	PK	Required	Type	Description
id	course_id	true	true	string	Primary key of course table
prefix	prefix	false	true	string	Course code prefix
courseCode	course_code	false	true	string	Course code
name	course_name	false	true	string	Displayed name for course
description	description	false	false	string	Long description for course
coRequisites	co_requisites	false	false	string	Course co-requisites
isDisabled	is_disabled	false	true	boolean	True if course is disabled
teacherId	teacher_id	false	true	string	Teacher's user ID
credit	credit	false	false	float	Credit for this course

com.cyclopsgroup.courselist.entity.CoursePrerequisite

Property name	Column name	PK	Required	Type	Description
id	course_prerequisite_id	true	true	string	Primary key of course table
courseId	course_id	false	true	string	Course id
prerequisteId	prerequisite_id	false	true	string	Prerequisite course id

com.cyclopsgroup.courselist.entity.Teacher

Property name	Column name	PK	Required	Type	Description
id	teacher_id	true	true	string	Student primary key
userId	user_id	false	true	string	Id of user object

com.cyclopsgroup.courselist.entity.StudentCourse

Property name	Column name	PK	Required	Type	Description
id	student_course_id	true	true	string	Primary key of course table
courseId	course_id	false	true	string	Course ID
studentId	student_id	false	true	string	Student ID
relationType	relationType	false	true	string	Status of this relationship. Could be finished, dropped or taking
score	score	false	true	float	The credit student got on this course