codetree sql - Githubissues

3중 분류 참고 대중소

CREATE TABLE qpass_config (
  delete_limit varchar(10) default NULL
);

INSERT INTO qpass_config VALUES ('');

CREATE TABLE qpass_catBig (
  big_code char(2) NOT NULL default '',
  big_name varchar(50) default NULL,
  PRIMARY KEY  (big_code)
);

CREATE TABLE qpass_catMid (
  mid_code varchar(4) NOT NULL default '',
  mid_name varchar(50) default NULL,
  PRIMARY KEY  (mid_code)
);

CREATE TABLE qpass_catSmall (
  small_code varchar(6) NOT NULL default '',
  small_name varchar(50) default NULL,
  view_index int(11) default NULL,
  PRIMARY KEY  (small_code)
);

CREATE TABLE qpass_exam (
  uid int(11) NOT NULL auto_increment,
  small_code varchar(6) default NULL,
  exam_name varchar(200) default NULL,
  cat_countTotal tinyint(4) default NULL,
  cat_title01 varchar(100) default NULL,
  cat_title02 varchar(100) default NULL,
  cat_title03 varchar(100) default NULL,
  cat_title04 varchar(100) default NULL,
  cat_title05 varchar(100) default NULL,
  cat_title06 varchar(100) default NULL,
  cat_title07 varchar(100) default NULL,
  cat_title08 varchar(100) default NULL,
  cat_title09 varchar(100) default NULL,
  cat_title10 varchar(100) default NULL,
  cat_count01 tinyint(6) default NULL,
  cat_count02 tinyint(6) default NULL,
  cat_count03 tinyint(6) default NULL,
  cat_count04 tinyint(6) default NULL,
  cat_count05 tinyint(6) default NULL,
  cat_count06 tinyint(6) default NULL,
  cat_count07 tinyint(6) default NULL,
  cat_count08 tinyint(6) default NULL,
  cat_count09 tinyint(6) default NULL,
  cat_count10 tinyint(6) default NULL,
  exam_comment text,
  time_limit int(11) default NULL,
  view_ox tinyint(4) default NULL,
  reg_time datetime default NULL,
  PRIMARY KEY  (uid),
  KEY small_code (small_code)
);

CREATE TABLE qpass_question (
  uid int(11) NOT NULL auto_increment,
  exam_uid int(11) default NULL,
  cat_index tinyint(4) default NULL,
  question text,
  answer01 text,
  answer02 text,
  answer03 text,
  answer04 text,
  answer varchar(255) default NULL,
  comment text,
  view_index int(11) default NULL,
  reg_time datetime default NULL,
  PRIMARY KEY  (uid),
  KEY small_code (exam_uid)
);

CREATE TABLE qpass_result (
  mb_id varchar(30) NOT NULL default '',
  exam_uid int(11) NOT NULL default '0',
  try_list01 text,
  try_list02 text,
  try_list03 text,
  try_list04 text,
  try_list05 text,
  try_list06 text,
  try_list07 text,
  try_list08 text,
  try_list09 text,
  try_list10 text,
  reg_time01 datetime default NULL,
  reg_time02 datetime default NULL,
  reg_time03 datetime default NULL,
  reg_time04 datetime default NULL,
  reg_time05 datetime default NULL,
  reg_time06 datetime default NULL,
  reg_time07 datetime default NULL,
  reg_time08 datetime default NULL,
  reg_time09 datetime default NULL,
  reg_time10 datetime default NULL,
  latest_tryTime datetime default NULL,
  PRIMARY KEY  (exam_uid,mb_id)
);
Taebu / prq

codetree sql #20
