//-------------------------------
//考卷内容表
drop table examcontent;
create table ExamContent(
Pid number(4,0) not null,
Tid number(4,0) null,
Type number(4,0) null,
Source number(1,0) null,
Answer varchar2(4000) null,
FullMark number(3,1) null,
Score number(3,1) null
);
//--------------------------------
考试汇总信息表
drop table testinfo;
create table TestInfo(
ExamID number(4,0) not null, //自动编号
Course_id number(4,0) not null,
TimeLast number(3,0) default 120,
TotalScore number(3,0) default 100,
AverScore number(5,2) default 0,
TotalStu number(4,0) null,
RealStu number(4,0) null,
TeachID number(4,0) null,
StuType varchar2(10) default '3+1'
);
//---------------------------------------
//考卷信息表
drop table paperinfo;
create table PaperInfo(
PaperID number(4,0) not null, //自动编号
ExamID number(4,0) not null,
CourseID number(4,0) null,
StartTime date null,
EndTime date null,
Flag number(1,0) null,
StuID varchar2(8) null,
StuPwd number(8,0) null,
TeachName varchar2(10) null,
Score number(4,1) default 0
);
//-----------------------
//考生信息表
drop table stuinfo;
create table StuInfo(
StuID varchar2(8) not null,
StuName varchar2(10) null,
Sex varchar2(2) null,
Birthday date null,
EnrollDay date null,
NativePlc varchar2(20) null,
DelSign number(1,0) null
);
//------------------