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 )
);
本文档为【数据库结构】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑,
图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。