BBS > plan

exam

작성자 : 이창우 (x1wins) | 등록일 : 2011-04-26 | 목록
첨부 파일이 없습니다.
첨부 이미지가 없습니다.
첨부 코드가 없습니다.
create table user
(
num integer not null auto_increment,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
userid varchar(100) not null,
username varchar(100) not null, /*사용자 이름*/
user_img varchar(100) not null, /* user picture */
primary key(num),
unique key(userid)
);

create table catagory
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
catagory varchar(100) not null,
next_num integer not null
);

create table grade
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
grade varchar(100) not null
);

create table subject
(
num integer not null auto_increment,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
grade_num integer not null,
catagory_num integer not null,
subject varchar(100) not null,
primary key(num),
unique key(subject)
);

create table unit
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
subject_num integer not null,
unit varchar(100) not null
);

create table explain
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
unit_num integer not null,
explain text not null
);

create table quiz
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
unit_num integer not null,
quiz text not null,
correct_answer integer not null,
read_count integer not null default 0,
recomment_count integer not null default 0,
reply_count integer not null default 0
);

create table example
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
quiz_num integer not null,
example text not null,
score integer not null
);

/*
create table correct_answer
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
quiz_num integer not null,
example_num integer not null
);
*/

create table user_answer
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
quiz_num integer not null,
example_num integer not null
);

create table result
(
num integer not null auto_increment primary key,
userid varchar(100) not null,
reg_date timestamp not null default current_timestamp,
ip varchar(100) not null,
del_yn varchar(1) default 'n',
quiz_num integer not null,
score integer not null
);
로그인 하셔야 댓글을 사용하실수 있습니다.
댓글쓰기를 누르면 로그인 페이지로 이동 후 돌아옵니다.
총 댓글 겟수 0
번호 제목 등록일 작성자 조회수
520 free css design (2) 2012-04-23 이창우 2128
174 design (0) 2011-06-10 이창우 2401
88 account book (0) 2011-05-12 이창우 3192
86 event money list (0) 2011-05-11 이창우 2142
-> exam (0) 2011-04-26 이창우 2964
< 1 >
글쓰기 검색