KTUGFaq
KTUG FAQ
You will receive a legacy which will place you above want.
Mika&value=뽺ũ › HLaTeX2DHUcs&value=LaTeX › KTUGCollection2005 › 占쏙옙호占쏙옙占쏙옙 › CygWinġϱ/FrontPage › MakingExam
r1.9
@@ -17,12 +17,25 @@
* DateOfAnswer : datetime not null, ´° Դϴ. Pool %, ۼ % Ϸ մϴ.* GradeOfQuestion : smallint not null, ̵ Դϴ.
create table HExamMain (
idOfMain int unsigned not null auto_increment primary key,
CategoryOfAnswer char(20) not null,
TypeOfQuestion char(2) not null,
AbstractOfQuestion varchar(200) not null
LANumberOfQuestion smallint null,
QuestionOrList varchar(500) not null,
Choice varchar(500) null,
AnswerChoice smallint null,
AnswerString varchar(500) null,
PointOfQuestion smallint not null,
DateOfAnswer datetime not null,
GradeOfQuestion smallint not null) ENGINE=INNODB;
LAHExam table* LAid : int(10) unsigned not null auto_increment, primary key
* idOfMain : int(10) unsigned not null , idOfMain
* CategoryOfAnswer : char(20) not null, ϴ°? chapter ϴ°?
* TypeOfQuestion : char(2) not null, Դϴ. (SC),multiplechoice(MC), ܴ(SS), (MS), ϰ Ŀ (LA)
* Choice : char(500) null, Դϴ.
* AnswerChoice : smallint null, Դϴ.
@@ -31,6 +44,23 @@
* DateOfAnswer : datetime not null, ´° Դϴ. Pool %, ۼ % Ϸ մϴ.* GradeOfQuestion : smallint not null, ̵ Դϴ.
create table LAHExam (
LAid int unsigned not null auto_increment primary key,
CategoryOfAnswer char(20) not null,
TypeOfQuestion char(2) not null,
AbstractOfQuestion varchar(200) not null,
QuestionOrList varchar(500) not null,
Choice varchar(500) null,
AnswerChoice smallint null,
AnswerString varchar(500) null,
PointOfQuestion smallint not null,
DateOfAnswer datetime not null,
GradeOfQuestion smallint not null,
Pa_IdOfMain int,
INDEX ParIdOfMain(Pa_IdOfMain)
FOREIGN KEY (Pa_IdOfMain) REFERENCE HExamMain(IdOfMain) ON DELETE CASCADE
) ENGINE=INNODB;
FigureOfQuestion table* idOfFigure : int(10) unsigned not null auto_increment, primary key
* idOfMain int(10) unsigned null, HExamMain table
̾ƹ hexam.cls ̿ mySQL php ̿ؼ DB TeX մϴ. ̹ DB pool ̿ؼ ְ ҷ մϴ. ɷ . KLDP vi like editor on WEB а Բ ִ editor Ϸ մϴ.
1.1 DB 迡 ¶
HExamMain table
- idOfMain : int(10) unsigned not null auto_increment,
- CategoryOfAnswer : char(20) not null, ϴ°? chapter ϴ°?
- TypeOfQuestion : char(2) not null, Դϴ. (SC),multiplechoice(MC), ܴ(SS), (MS), ϰ Ŀ (LA)
- AbstractOfQuestion : char(200) not null, ̴.
- LANumberOfQuestion : smallint null,LA϶ Դϴ.
- QustionOrList : text not null, Դϴ.
- Choice : char(500) null, Դϴ.
- AnswerChoice : smallint null, Դϴ.
- AnswerString : text null,ְ Դϴ.
- PointofQuestion : smallint not null, ΰ?
- DateOfAnswer : datetime not null, ´° Դϴ. Pool %, ۼ % Ϸ մϴ.
- GradeOfQuestion : smallint not null, ̵ Դϴ.
idOfMain int unsigned not null auto_increment primary key,
CategoryOfAnswer char(20) not null,
TypeOfQuestion char(2) not null,
AbstractOfQuestion varchar(200) not null
LANumberOfQuestion smallint null,
QuestionOrList varchar(500) not null,
Choice varchar(500) null,
AnswerChoice smallint null,
AnswerString varchar(500) null,
PointOfQuestion smallint not null,
DateOfAnswer datetime not null,
GradeOfQuestion smallint not null) ENGINE=INNODB;
LAHExam table
- LAid : int(10) unsigned not null auto_increment, primary key
- idOfMain : int(10) unsigned not null , idOfMain
- CategoryOfAnswer : char(20) not null, ϴ°? chapter ϴ°?
- TypeOfQuestion : char(2) not null, Դϴ. (SC),multiplechoice(MC), ܴ(SS), (MS), ϰ Ŀ (LA)
- QustionOrList : text not null, Դϴ.
- Choice : char(500) null, Դϴ.
- AnswerChoice : smallint null, Դϴ.
- AnswerString : text null,ְ Դϴ.
- PointofQuestion : smallint not null, ΰ?
- DateOfAnswer : datetime not null, ´° Դϴ. Pool %, ۼ % Ϸ մϴ.
- GradeOfQuestion : smallint not null, ̵ Դϴ.
LAid int unsigned not null auto_increment primary key,
CategoryOfAnswer char(20) not null,
TypeOfQuestion char(2) not null,
AbstractOfQuestion varchar(200) not null,
QuestionOrList varchar(500) not null,
Choice varchar(500) null,
AnswerChoice smallint null,
AnswerString varchar(500) null,
PointOfQuestion smallint not null,
DateOfAnswer datetime not null,
GradeOfQuestion smallint not null,
Pa_IdOfMain int,
INDEX ParIdOfMain(Pa_IdOfMain)
FOREIGN KEY (Pa_IdOfMain) REFERENCE HExamMain(IdOfMain) ON DELETE CASCADE
) ENGINE=INNODB;
FigureOfQuestion table
Ѱ Ѵٰ ϸ Ƹ ÿ ʿ table .
1.2 WebEditor ¶
ܷ̿ phpschool.com ڷᰡ ִ. WebTeX ̴. ã ŭ ̴ .
- site Webeditor ̴. http://www.ziwoo.net/zb/download.php?fileName=wysiwyg.zip&fileExtra=zb_ziwoo_javascript_120_2.zip&boardid=zb_ziwoo_javascript&uid=120&an=1
- ⼭ data htmlȭ Ǿ־ TeX ٲٴ ʿ ʹ.
1.4 DB html ϱ ¶
- DB html· ϱ ߴ. ʿ html ϴ ߿ ãƺ ״ ؼ̴.
- htmltolatex java program ִ. ̰ Ϸ Ѵ. ɷ ǹ, 츮 ϸ Ѵ. http://htmltolatex.sourceforge.net/ downƼ Ǵµ ʹ.