試題庫數(shù)據(jù)庫設(shè)計(參考版)
2025-03-28 12:05本頁面
【正文】 。參加考試學(xué)生表試卷Id 學(xué)號{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))。試卷列表id,name 考試時間,課程代號,考試與否{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))。答案表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))。題目附加信息關(guān)聯(lián)表create table q_e (eid int not null,qid int not null,constraint PK_e_q primary key (eid,qid))。題目表id 題目內(nèi)容課程id 題型id 章節(jié)關(guān)鍵詞難度添加時間添加人審核審核人create table questions(qid int not null,content text not null,cid varchar(20) not null,sid varchar(2) not null,chapter int not null,point varchar(50),qlevel int not null,add_time datetime not null,add_user varchar(20) not null,auditint not null,auditteacher varchar(20)constraint PK_questions primary key (qid))。課程題型關(guān)聯(lián)表課程ID 題型IDcreate table course_styles(cid varchar(20) not null,16sid int not null,constraint PK_course_styles primary key (cid,sid))。課程表id 課程名create table
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1