5、期DATETIME是表名：CLASS解释:班级CLASS(Class)是否主键字段名字段描述数据类型度可空约束缺省值备注是CLASSID班级IdVARCHAR(10I。CLASSNAME班级名称VARCHAR(3030是CLASSREMARK备注VARCHAR(5050是表名：COURSE解释:课程COURSE(Course)是否主键字段名字段描述数据类型度可空约束缺省值备注是COURSEID课程IdVARCHAR(1010COURSENAME课程名称VARCHAR(3030是COURSEDESCRIBE程描述VARCHAR(5050是COURSEREMARI课程备注VARCHAR(505
7、EOPLE试实到人数INTEGER(5)5是表名：EXAMPAPER解释:试卷EXAMPAPER(ExamPaper)是否主键字段名字段描述数据类型长度可空约束缺省值备注是PAPERID试卷IdVARCHAR(2020USERIDMANAGER管理员IdINTEGER(11)11是USERIDTEACHER老师IdINTEGER(11)11是PAPERNAME试卷名称VARCHAR(3030是PAPERDIFFICULTY试卷难度INTEGER(2)2是PAPERPERCENT试卷分数INTEGER(4)4是PAPERSTATUS试卷状态INTEGER(1)1是PAPERGENERATEDA
9、否主键字段名字段描述数据类型长度可空约束缺省值备注是POINTSID知识点IdINTEGER(11)11BOOKID教材IdVARCHAR(20)20是CHAPTER章INTEGER(4)4是SECTION节INTEGER(4)4是POINTSNAME知识点名称VARCHAR(30)30是POINTSCONTEN知识点内容VARCHAR(20002000是POINTSDIFFICUl知识点难度INTEGER(2)2是POINTSREMARK备注VARCHAR(50)50是表名：MANAGER解释：管理员MANAGER(Manager)是否主键字段名字段描述数据类型长度可空约束缺省值备注是USE
10、RID用户IdINTEGER(11)11MANAGERACADEMY管理员所在学院VARCHAR(3030是MANAGERDEPARTENT理员所在系VARCHAR(3030是MANAGERPOSITION管理员职位VARCHAR(3030是MANAGERNAME管理员名称VARCHAR(3030是MANAGERREMARK管理员备注VARCHAR(5050是表名PROBLEM解释题目PROBLEM(Problem)是否主键字段名字段描述数据类型长度可空约束缺省值备注是PROBLEMID题目IdINTEGER(11)11POINTSID知识点IdINTEGER(11)11是PROBLEM
11、NAME知识点名称VARCHAR(30)30是PROBLEMCONTENT知识点内容VARCHAR(500)500是PROBLEMANSWERA答案AVARCHAR(100)100是PROBLEMANSWERB答案BVARCHAR(100)100是PROBLEMANSWERC答案CVARCHAR(100)100是PROBLEMANSWERD答案DVARCHAR(100)100是PROBLEMSUBJECTANSWEM题答案VARCHAR(50005000是PROBLEMOBJECTANSWER观题答案VARCHAR(1)1是PROBLEMTRUE判断题答案BOOLEAN是PROBLEMTYPE
12、题目类型INTEGER(1)1是PROBLEMDIFFICULTY题目难度INTEGER(2)2是PROBLEMREMARK题目备注VARCHAR(50)50是表名:STUDENT解释:学生STUDENT(Student)是否主键字段名字段描述数据类型长度可空约束缺省值备注是USERID用户IdINTEGER(11)11STUDENTID学生IdVARCHAR(1010是COURSEID课程IdVARCHAR(1010是STUDENTNAME学生姓名VARCHAR(3(30是STUDENTACADEMY学生所在学院VARCHAR(3(30是STUDENTDEPARTMEI津生所在系VARCH
13、AR(3030是STUDENTREMARK学生备注VARCHAR(5(50是表名：STUDENTEXAM解释:学生考试STUDENTEXAM(StudentExam)是否主键字段名字段描述数据类型长度可空约束缺省值备注是USERID学生IdINTEGER(11)11是EXAMID考试IdVARCHAR(2(20STUDNTEXAMTID学生考试IdVARCHAR(2(20是STUDENTEXAMGRAD学生成绩INTEGER(4)4是表名：STUDENTEXAMPAPERPROBLEM释：StudentExamPaperProblemSTUDENTEXAMPAPERPROBLEM(Studen
14、tExamPaperProblem)是否主键字段名字段描述数据类型长度可空约束缺省值备注是USERID用户IdINTEGER(11)11是EXAMID考试IdVARCHAR(20)20是PROBLEMID题目IdINTEGER(11)11是PAPERID试卷IdVARCHAR(20)20STUDENTSUBJECTANSWE学生主观题答案VARCHAR(500(5000是STUDENTOBJECTANSWER学生客观题答案VARCHAR(1)1是STUDENTTRUEANSWER学生判断题答案BOOLEAN是STUDENTPROBLEMPERCENTfe题目分数INTEGER(3)3是S