数据库结构

create table Users( userName Varchar(50) not null primary key, userPassword Varchar(50) not null, userEmail Varchar(100) not null, uQuestion Varchar(50) not null, uAnswer Varchar(50) not null, registerTime timestamp not null, uSex Varchar(2), uBirthday Varchar(50), uAddress Varchar(100), mobilePhone int, qq int, point int, balance float, payPassword Varchar(50), technology Varchar(200) ); create table CourseType( ctId int auto_increment primary key, ctName Varchar(50) not null, ctDescription text ) create table Course( courseId int auto_increment primary key, courseName Varchar(100) not null, courseDescription text not null, courseTypeId int, needPoint int default 0, needBalance float default 0.0, foreign key(courseTypeId) references CourseType(ctId) ) create table Chapter( chapterId int auto_increment primary key, chapterName Varchar(100), chapterDescription text, isImportant Varchar(10), hardLevel int, courseId int, foreign key(courseId) references Course(courseId) ); create table KnowledgePoint( kpId int auto_increment primary key, kpName varchar(100) not null, kpContent text not null, kpChapterId int not null, startTime Varchar(50) not null, endTime Varchar(50) not null, foreign key(kpChapterId) references Chapter(chapterId) ); create table Question ( questionID int auto_increment not null, singleTitle varchar(300), options text, answer varchar(30), score int , difficulty int, courseID int , chapterID int, knowledgePointID int, questionPerson varchar(30), primary key (questionID ), foreign key(courseID ) references Course(courseId ), foreign key(chapterID ) references Chapter(chapterId), foreign key(knowledgePointID ) references KnowledgePoint(kpId) ); Create table TextPaper( testpaperID int auto_increment not null, testPaperName varchar(30), testPaperPerson varchar(30), total int , Primary key (testpaperID ) ); Create table ExamQuestion( testPaperID int , questionID int , foreign key (testPaperID ) references TextPaper(testpaperID ), foreign key (questionID ) references Question(questionID ) ); Create table ExamPlan ( examPlanID int auto_increment not null, examTimeLength int , examName varchar(30), startTime time, endTime time, Frequency int, testPaperID int, Primary key (examPlanID), foreign key (testPaperID ) references TextPaper(testpaperID ) ); Create table ExamStudent ( examPlanID int , userName varchar(30), Frequency int , foreign key (examPlanID ) references ExamPlan(examPlanID), foreign key (userName) references Users(userName) ); Create table ExamScore( examScoreID int auto_increment primary key, userName varchar(30), examPlanID int , score int, scoringRate int, startTime varchar(30), endTime varchar(30), timeLength int , total int, foreign key (examPlanID ) references ExamPlan(examPlanID ), foreign key (userName) references Users(userName ) ); Create table Result ( resultID int auto_increment primary key, examPlanID int, average double, passingRate int, excellentRate int, foreign key (examPlanID ) references ExamPlan(examPlanID ) );