試題庫數(shù)據(jù)庫設(shè)計(jì)-資料下載頁
2025-03-25 12:05本頁面
【正文】 l,pid int not null,constraint PK_p_q primary key (qid,pid))。答案表create table answers (aid int not null,qid int not null,optionsname varchar(1) not null,options varchar(300) not null,answer int,constraint PK_answers primary key (aid))。圖片列表create table pics (pid int not null,pname varchar(30),pBlob image,constraint PK_pics primary key (pid))。試卷列表id,name 考試時(shí)間,課程代號(hào),考試與否{0 練習(xí),1 考試},試卷類型,考試方式{0 傳統(tǒng),1在線},審核,審核人ID,考試與否{0 未考,1 已考}create table testpaper_list(paper_id int not null,paper_name varchar(50) not null,paper_time datetime not null,cid varchar(20) not null,test int not null,paper_styles varchar(1),testway int,audit int not null,auditteacher varchar(20) not null,sysstate nt,constraint PK_testpaper_list primary key (paper_id))。試卷詳細(xì)信息create table testpaper(paper_id int not null,18qid int not null,q_num int,qscore int,constraint PK_testpaper primary key (paper_id,qid))。參加考試學(xué)生表試卷Id 學(xué)號(hào){0 未考，1 已考，2 作弊}create table paper_students(paper_id int not null,stu_id varchar(20) not null,stu_state int,constraint PK_paper_students primary key (paper_id,stu_id))。已考的試卷create table paper_done (paper_id int not null,stu_id varchar(20) not null,qid int not null,q_num int,answer varchar(200) not null,stu_score int,grade_teacher varchar(20),grade_time datetime,audit_teacher varchar(20),audit_time datetime,constraint PK_paper_done primary key (paper_id,stu_id,qid))。
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1