Cyclops Group Software Foundation
Search in site
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

All rights reserved, 2002 ~ 2004, Cyclops Group.

Last published: 10 February 2007

Valid XHTML 1.0!SourceForge FoundationPowered by MavenDonate to Cyclops Group