KTUGFaq
KTUG FAQ
Let him who takes the Plunge remember to return it by Tuesday.
占쏙옙占쏙옙占쏙옙占쏙옙占쏙옙占쏙옙占쏙옙/占쏙옙표&value=내가쓰는편집기/WordIndex › Karnes/2006-08&value=Yhchoe/TitleIndex › slomo&value=Tabularȯ › johnnam › KTUGCollection2006/TroubleShooting&value=Karnes › MakingExam
r1.1
@@ -1,14 +1,91 @@
̾ƹ hexam.cls ̿ mySQL php ̿ؼ DB TeX մϴ. ̹ DB pool ̿ؼ ְ ҷ մϴ. ɷ . KLDP vi like editor on WEB а Բ ִ editor Ϸ մϴ.
[[TableOfContents
]]
== DB
-
==
* 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)
*
id
AbstractOfQuestion :
id
char(200) not null, ̴.
* LANumberOfQuestion : smallint null,LA϶ Դϴ.
*
Qustion
QustionOrList :
text not null, Դϴ.
* Choice :
char(500) null, Դϴ.
* AnswerChoice :
smallint null, Դϴ.
*
Answer
AnswerString :
text null,ְ Դϴ.
* PointofQuestion :
smallint not null, ΰ?
*
Date
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
*
FigureOfQuestion
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,
figure
ΰ?
* DateOfAnswer : datetime not null, ´°
Դϴ. Pool %,
ǥø
ۼ
field
% Ϸ մϴ.
* 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
* LAid int(10) unsigned null, LAHExam table
* file_path
* file_name
* file_name2
* file_size
Ѱ Ѵ
ֽ
Ƹ ÿ ʿ table .
== 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 ٲٴ ʿ ʹ.
*
̰ <span> ִ
ΰ
TeX ٲ ִ. Ƹ TeX4ht
mouseover.js ϱ ߴ . ̰͵ (?) ɰ .
== Mainȭ 迡 ==
* Է κ: WebEditor ̿ϰ ٸ κе ̿ؼ 4 Էâ Ѵ.
mainâ category discription
ִ κ --> ⼭ , ְ, Ŀ
ְ ̴.
* ð
׳ ͼ ٿ
htmlȭ
ɵ ѹ .
* κ : κп
TeX source html ٲٴ ʿҵ ϴ.
óؾ
Ǿ ̴.
* ãƺ κ : category ã( ߴ ׳ Ʒ ϴ
ƴ paging(?
) ̶ ϴ technique ̿ , abstract() ã, ¥ ã ̻ ʿ
?
*
* TeX
* 蹮
Դϴ.
== DB html ϱ ==
* DB html· ϱ ߴ. ʿ
html ϴ ߿ ã
״
? Ȥ
̴.
* htmltolatex
java program
.
Ϸ
. ɷ ǹ,
츮
ϸ Ѵ. http://htmltolatex.sourceforge.net/ downƼ
Ǵµ .
̾ƹ 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Ƽ Ǵµ ʹ.