CreativeYellowERD

Tables (38)

TB_AGENCY (agency)

  • nvcNGCSeq (PK) — int(8) — Primary key — NOT NULL
  • nvcCPCode (Field) — varchar(5) — NOT NULL
  • nvcNGCCode (Field2) — varchar(5) — NOT NULL
  • nvcNGCName (Field3) — varchar(50) — NOT NULL
  • nvcCharger (Field4) — varchar(50)
  • nvcTel (Field5) — varchar(14)
  • nvcZipcode (Field6) — varchar(20)
  • nvcAddress1 (Field7) — varchar(400)
  • nvcAddress2 (Field8) — varchar(400)
  • siFlag (Field9) — smallint(6)
  • regdate (Field10) — datetime
  • moddate (Field11) — datetime

TB_AITALKING (aitalking)

  • talking_seq (PK) — int(11) — Primary key — NOT NULL
  • iOrderDTSeq (Field) — int(11)
  • prod_name (Field2) — varchar(200)
  • nvcCPCode (Field3) — varchar(5)
  • vcMGCode (Field4) — varchar(5)
  • CRS_TYPE_NUM (Field5) — char(4)
  • lang_cd (Field6) — char(4)
  • iMemberSeq (Field7) — int(11) — NOT NULL
  • writer_id (Field8) — varchar(50)
  • writer_name (Field9) — varchar(30) — NOT NULL
  • topic_level_cd (Field10) — char(4)
  • topic_type_cd (Field11) — char(4)
  • topic_seq (Field12) — int(11)
  • topic_title (Field13) — varchar(200)
  • SUBJECT (Field14) — varchar(400)
  • start_date (Field15) — varchar(30)
  • end_date (Field16) — varchar(30)
  • regdate (Field17) — datetime
  • complete_date (Field18) — datetime
  • TX_IDX (Field19) — int(11)
  • feedback_text (Field20) — text
  • iTeacherSeq (Field21) — int(11)
  • iTeacherName (Field22) — varchar(50)
  • firstCheckTeacherName (Field23) — varchar(50)
  • firstCheckDate (Field24) — datetime
  • doubleCheckTeacherSeq (Field25) — int(11)
  • doubleCheckTeacherName (Field26) — varchar(50)
  • doubleCheckDate (Field27) — datetime
  • writing_status (Field28) — char(1)
  • aiReturnData1 (Field29) — smallint(3)
  • aiReturnData2 (Field30) — smallint(3)
  • aiReturnData3 (Field31) — smallint(3)
  • aiReturnData4 (Field32) — smallint(3)
  • aiReturnData5 (Field33) — smallint(3)
  • aiReturnData6 (Field34) — smallint(3)
  • aiReturnData7 (Field35) — smallint(3)
  • aiReturnData8 (Field36) — smallint(3)
  • writing_membership_seq (Field37) — int(11)
  • content (Field38) — text
  • content_step3 (Field39) — text
  • content_kor (Field40) — text
  • file_name (Field41) — varchar(100)
  • best_yn (Field42) — varchar(2)
  • academy_name (Field43) — varchar(50)
  • student_level (Field44) — int(11)
  • hit_num (Field45) — int(11)
  • comm_num (Field46) — int(11)
  • ai_state (Field47) — smallint(6)
  • state (Field48) — int(11)
  • writing_date (Field49) — char(28)
  • teacher_seq (Field50) — int(11)
  • answerer_name (Field51) — varchar(30)
  • answer (Field52) — text
  • rewriting (Field53) — text
  • score1 (Field54) — int(11)
  • score2 (Field55) — int(11)
  • score3 (Field56) — int(11)
  • score4 (Field57) — int(11)
  • score5 (Field58) — int(11)
  • answer_date (Field59) — char(28)
  • … +13

TB_AITALKING_IMAGE (aitalking image)

  • image_seq (PK) — int(11) — Primary key — NOT NULL
  • book_num (Field) — varchar(5)
  • unit_num (Field2) — varchar(10)
  • image_url (Field3) — varchar(100) — NOT NULL
  • description_text (Field4) — text
  • question (Field5) — text
  • keywords (Field6) — text
  • image_text (Field7) — text
  • regdate (Field8) — datetime
  • moddate (Field9) — datetime

TB_AITALKING_LESSON_CHANGE_LOG (aitalking lesson change log)

  • iLogSeq (PK) — int(11) — Primary key — NOT NULL
  • iMemberSeq (Field) — int(11) — NOT NULL
  • iOrderDTSeq (Field2) — int(11)
  • iScheduleSeq (Field3) — int(11) — NOT NULL
  • from_lession_id (Field4) — int(11) — NOT NULL
  • to_lession_id (Field5) — int(11) — NOT NULL
  • changeTime (Field6) — varchar(50) — NOT NULL
  • lession_id (Field7) — int(11)
  • changeDate (Field8) — date
  • changeDateTime (Field9) — datetime

TB_AITALKING_TOPIC (aitalking topic)

  • topic_seq (PK) — int(11) — Primary key — NOT NULL
  • cp_code (Field) — varchar(5)
  • topic_level_cd (Field2) — char(4) — NOT NULL
  • topic_type_cd (Field3) — char(4) — NOT NULL
  • topic_title (Field4) — varchar(200) — NOT NULL
  • full_text (Field5) — text
  • keywords (Field6) — text
  • picture_information (Field7) — text
  • information (Field8) — text
  • direction (Field9) — text
  • picture (Field10) — varchar(100)
  • video (Field11) — text
  • image_list (Field12) — varchar(100)
  • regdate (Field13) — datetime
  • moddate (Field14) — datetime

TB_AIWRITING (aiwriting)

  • writing_seq (PK) — int(11) — Primary key — NOT NULL
  • iOrderDTSeq (Field) — int(11)
  • prod_name (Field2) — varchar(200)
  • nvcCPCode (Field3) — varchar(5)
  • vcMGCode (Field4) — varchar(5)
  • CRS_TYPE_NUM (Field5) — char(4)
  • lang_cd (Field6) — char(4)
  • iMemberSeq (Field7) — int(11) — NOT NULL
  • writer_id (Field8) — varchar(50)
  • writer_name (Field9) — varchar(30) — NOT NULL
  • topic_level_cd (Field10) — char(4)
  • topic_type_cd (Field11) — char(4)
  • topic_seq (Field12) — int(11)
  • topic_title (Field13) — varchar(200)
  • SUBJECT (Field14) — varchar(400)
  • regdate (Field15) — datetime
  • m1_content_org (Field16) — text
  • m1_content_regdate (Field17) — datetime
  • m1_content_ai (Field18) — mediumtext
  • m1_content_ai_1 (Field19) — mediumtext
  • m1_content_ai_2 (Field20) — mediumtext
  • m1_content_ai_3 (Field21) — mediumtext
  • m1_content_completedate (Field22) — datetime
  • m1_feedbackRegdate (Field23) — datetime
  • m1_selectWord (Field24) — varchar(100)
  • m1_aiReturnData1 (Field25) — smallint(3)
  • m1_aiReturnData2 (Field26) — smallint(3)
  • m1_aiReturnData3 (Field27) — smallint(3)
  • m1_aiReturnData4 (Field28) — smallint(3)
  • m1_aiReturnData5 (Field29) — smallint(3)
  • m1_aiReturnData6 (Field30) — smallint(3)
  • m1_aiReturnData6 (Field31) — smallint(3)
  • m1_aiReturnData7 (Field32) — smallint(3)
  • m1_aiReturnData8 (Field33) — smallint(3)
  • m2_content_org (Field34) — text
  • m2_content_regdate (Field35) — datetime
  • m2_content_ai (Field36) — mediumtext
  • m2_content_ai_1 (Field37) — mediumtext
  • m2_content_ai_2 (Field38) — mediumtext
  • m2_content_ai_3 (Field39) — mediumtext
  • m2_content_completedate (Field40) — datetime
  • m2_feedbackRegdate (Field41) — datetime
  • m2_selectWord (Field42) — varchar(100)
  • m2_aiReturnData1 (Field43) — smallint(3)
  • m2_aiReturnData2 (Field44) — smallint(3)
  • m2_aiReturnData3 (Field45) — smallint(3)
  • m2_aiReturnData4 (Field46) — smallint(3)
  • m2_aiReturnData5 (Field47) — smallint(3)
  • m2_aiReturnData6 (Field48) — smallint(3)
  • m2_aiReturnData7 (Field49) — smallint(3)
  • m2_aiReturnData8 (Field50) — smallint(3)
  • m3_content_org (Field51) — text
  • m3_content_regdate (Field52) — datetime
  • m3_content_ai (Field53) — mediumtext
  • m3_content_ai_1 (Field54) — mediumtext
  • m3_content_ai_2 (Field55) — mediumtext
  • m3_content_ai_3 (Field56) — mediumtext
  • m3_content_completedate (Field57) — datetime
  • m3_feedbackRegdate (Field58) — datetime
  • m3_selectWord (Field59) — varchar(100)
  • … +55

TB_AIWRITING_AI_LANGUAGETOOL (aiwriting ai languagetool)

  • language_id (PK) — int(11) — Primary key — NOT NULL
  • iMemberSeq (Field) — int(11)
  • writing_seq (Field2) — int(11)
  • mission_pg (Field3) — char(1)
  • matches_len (Field4) — int(11)
  • context (Field5) — text
  • context_offset (Field6) — int(11)
  • context_length (Field7) — int(11)
  • LENGTH (Field8) — int(11)
  • OFFSET (Field9) — int(11)
  • replacements (Field10) — text
  • replacements_len (Field11) — int(11)
  • r_category_id (Field12) — varchar(50)
  • r_category_name (Field13) — varchar(50)
  • issueType (Field14) — varchar(50)
  • sentence (Field15) — varchar(50)
  • shortmessage (Field16) — varchar(50)
  • typename (Field17) — varchar(40)
  • is_deleted (Field18) — int(11)
  • reg_date (Field19) — varchar(50)
  • message (Field20) — text
  • original_text (Field21) — text

TB_AIWRITING_LESSON_CHANGE_LOG (aiwriting lesson change log)

  • iLogSeq (PK) — int(11) — Primary key — NOT NULL
  • iMemberSeq (Field) — int(11) — NOT NULL
  • iOrderDTSeq (Field2) — int(11)
  • iScheduleSeq (Field3) — int(11) — NOT NULL
  • from_lession_id (Field4) — int(11) — NOT NULL
  • to_lession_id (Field5) — int(11) — NOT NULL
  • changeTime (Field6) — varchar(50) — NOT NULL
  • lession_id (Field7) — int(11)
  • changeDate (Field8) — date
  • changeDateTime (Field9) — datetime

TB_AIWRITING_TOPIC (aiwriting topic)

  • topic_seq (PK) — int(11) — Primary key — NOT NULL
  • cp_code (Field) — varchar(5)
  • topic_level_cd (Field2) — char(4) — NOT NULL
  • topic_type_cd (Field3) — char(4) — NOT NULL
  • topic_title (Field4) — varchar(200) — NOT NULL
  • full_text (Field5) — text
  • full_dataurl (Field6) — varchar(100)
  • mission1_text (Field7) — text
  • mission1_dataurl (Field8) — varchar(100)
  • mission1_word1 (Field9) — varchar(100)
  • mission1_word1_text1 (Field10) — varchar(400)
  • mission1_word1_text2 (Field11) — varchar(400)
  • mission1_word1_text3 (Field12) — varchar(400)
  • mission1_word2 (Field13) — varchar(100)
  • mission1_word2_text1 (Field14) — varchar(400)
  • mission1_word2_text2 (Field15) — varchar(400)
  • mission1_word2_text3 (Field16) — varchar(400)
  • mission2_text (Field17) — text
  • mission2_dataurl (Field18) — varchar(100)
  • mission2_words (Field19) — varchar(100)
  • mission2_word1 (Field20) — varchar(100)
  • mission2_word1_text1 (Field21) — varchar(400)
  • mission2_word1_text2 (Field22) — varchar(400)
  • mission2_word1_text3 (Field23) — varchar(400)
  • mission2_word2 (Field24) — varchar(100)
  • mission2_word1_text1 (Field25) — varchar(400)
  • mission2_word1_text2 (Field26) — varchar(400)
  • mission2_word1_text3 (Field27) — varchar(400)
  • mission3_text (Field32) — text
  • mission3_dataurl (Field33) — varchar(100)
  • mission3_words (Field34) — varchar(100)
  • mission3_word1 (Field35) — varchar(100)
  • mission3_word1_text1 (Field36) — varchar(400)
  • mission3_word1_text2 (Field37) — varchar(400)
  • mission3_word1_text3 (Field38) — varchar(400)
  • mission3_word2 (Field39) — varchar(100)
  • mission3_word2_text1 (Field40) — varchar(400)
  • mission3_word2_text2 (Field41) — varchar(400)
  • mission3_word2_text3 (Field28) — varchar(400)
  • video (Field29) — text
  • regdate (Field30) — datetime
  • moddate (Field31) — datetime

TB_BOOKAICANVAS (bookaicanvas)

  • BC_IDX (PK) — int(11) — Primary key — NOT NULL
  • TOPIC_SEQ (Field) — int(11)
  • U_ID (Field2) — varchar(32) — NOT NULL
  • DELETE_YN (Field3) — char(1)
  • STATUS (Field4) — char(2)
  • CANVAS_FILE (Field5) — varchar(50)
  • MEMO (Field6) — text
  • STT (Field7) — text
  • REG_DATE (Field8) — datetime — NOT NULL
  • UPDATE_DATE (Field9) — datetime

TB_CANVAS_KOREAN (canvas korean)

  • korean_seq (PK) — int(11) — Primary key — NOT NULL
  • iOrderDTSeq (Field) — int(11)
  • prod_name (Field2) — varchar(200)
  • nvcCPCode (Field3) — varchar(5)
  • vcMGCode (Field4) — varchar(5)
  • CRS_TYPE_NUM (Field5) — char(4)
  • lang_cd (Field6) — char(4)
  • iMemberSeq (Field7) — int(11) — NOT NULL
  • writer_id (Field8) — varchar(50)
  • writer_name (Field9) — varchar(30) — NOT NULL
  • topic_level_cd (Field10) — char(4)
  • topic_type_cd (Field11) — char(4)
  • topic_seq (Field12) — int(11)
  • topic_title (Field13) — varchar(200)
  • SUBJECT (Field14) — varchar(400)
  • content_step1 (Field15) — text
  • content_AI (Field16) — mediumtext
  • content_Native (Field17) — mediumtext
  • coaching (Field18) — text
  • start_date (Field19) — varchar(30)
  • end_date (Field20) — varchar(30)
  • regdate (Field21) — datetime
  • complete_date (Field22) — datetime
  • iTeacherSeq (Field23) — int(11)
  • iTeacherName (Field24) — varchar(50)
  • comment_count (Field25) — smallint(3)
  • firstCheckTeacherSeq (Field26) — int(11)
  • firstCheckTeacherName (Field27) — varchar(50)
  • firstCheckDate (Field28) — datetime
  • doubleCheckTeacherSeq (Field29) — int(11)
  • doubleCheckTeacherName (Field30) — varchar(50)
  • doubleCheckDate (Field31) — datetime
  • writing_status (Field32) — char(1)
  • writing_membership_seq (Field33) — int(11)
  • content (Field34) — text
  • content_step3 (Field35) — text
  • content_kor (Field36) — text
  • file_name (Field37) — varchar(100)
  • best_yn (Field38) — varchar(2)
  • academy_name (Field39) — varchar(50)
  • student_level (Field40) — char(4)
  • hit_num (Field41) — int(11)
  • comm_num (Field42) — int(11)
  • ai_state (Field43) — smallint(6)
  • state (Field44) — int(11)
  • writing_date (Field45) — char(28)
  • teacher_seq (Field46) — int(11)
  • answerer_name (Field47) — varchar(30)
  • answer (Field48) — text
  • rewriting (Field49) — text
  • answer_date (Field50) — char(28)
  • manager_comment (Field51) — text
  • manager_comment_date (Field52) — char(28)
  • is_ai_only (Field53) — smallint(6)
  • TIMESTAMP (Field54) — varchar(28)
  • second_answerer_name (Field55) — varchar(30)
  • second_answer_date (Field56) — char(28)
  • is_speaking (Field57) — int(11)
  • content_step3_2 (Field58) — varchar(200)
  • content_step3_3 (Field59) — varchar(200)

TB_CANVAS_KOREAN_TOPIC (canvas korean topic)

  • topic_seq (PK) — int(11) — Primary key — NOT NULL
  • cp_code (Field) — varchar(5)
  • topic_level_cd (Field2) — char(4) — NOT NULL
  • topic_type_cd (Field3) — char(4) — NOT NULL
  • topic_title (Field4) — varchar(200) — NOT NULL
  • summary_text (Field5) — text
  • full_text (Field6) — text
  • full_dataurl (Field7) — varchar(100)
  • question_text (Field8) — text
  • regdate (Field9) — datetime
  • moddate (Field10) — datetime

TB_CONTENT_QUIZLOG (content quizlog)

  • CNTT_QZLOG_IDX (PK) — int(11) — Primary key — NOT NULL
  • CNTT_QZ_IDX (Field) — int(11) — NOT NULL
  • STUDLOG_RPRT_IDX (Field2) — int(11) — NOT NULL
  • QZ_ADM_LBL (Field3) — varchar(50)
  • QZ_P1_SENTENCE (Field4) — varchar(100)
  • QZ_P2_VOICE (Field5) — varchar(20)
  • QZ_P3_DESC (Field6) — text
  • QZ_P4_IMAGE (Field7) — varchar(20)
  • SOLVED_YN (Field8) — char(1)
  • SPEND_TM (Field9) — float
  • WRONG_CNT (Field10) — int(11)
  • SCORE (Field11) — float
  • TRY_VALUE (Field12) — int(11)
  • VC_ACCURACY_LIST (Field13) — varchar(300)
  • VC_REC_NM_LIST (Field14) — varchar(1000)
  • DELETE_YN (Field15) — char(45)
  • REG_DATE (Field16) — datetime
  • BOFFICE_USER_ID (Field17) — varchar(20)
  • UPDATE_DATE (Field18) — datetime

TB_COURSE_LESSON (course lesson)

  • lesson_id (PK) — int(11) — Primary key — NOT NULL
  • iOrderDTSeq (Field) — int(11)
  • iMemberSeq (Field2) — int(11) — NOT NULL
  • iMemberName (Field3) — varchar(50)
  • iTeacherSeq (Field4) — int(11)
  • iTeacherName (Field5) — varchar(50)
  • WEEKDAY (Field6) — varchar(2)
  • start_date (Field7) — varchar(30)
  • end_date (Field8) — varchar(30)
  • start_time (Field9) — varchar(10)
  • end_time (Field10) — varchar(10)
  • lesson_time (Field11) — int(11)
  • topic_level_cd (Field12) — char(4)
  • topic_type_cd (Field13) — char(4)
  • topic_seq (Field14) — int(11)
  • topic_title (Field15) — varchar(200)
  • STATUS (Field16) — smallint(3)
  • score1 (Field17) — int(11)
  • score2 (Field18) — int(11)
  • score3 (Field19) — int(11)
  • score4 (Field20) — int(11)
  • score5 (Field21) — int(11)
  • strComment (Field22) — text
  • estimationYN (Field23) — char(1)
  • estimationDate (Field24) — datetime
  • estimationTeacherSeq (Field25) — int(11)
  • estimationTeacherName (Field26) — varchar(50)
  • memo (Field27) — text
  • iScheduleSeq (Field28) — int(11)
  • iScheDetailSeq (Field29) — int(11)
  • content_id (Field30) — int(11)
  • r_content_id (Field31) — int(11)
  • teacher_id (Field32) — int(11)
  • lesson_step (Field33) — int(11)
  • lesson_type (Field34) — varchar(4)
  • lesson_file (Field35) — varchar(400)
  • lesson_fsize (Field36) — int(11)
  • lesson_phone (Field37) — varchar(100)
  • r_start_date (Field38) — varchar(30)
  • r_end_date (Field39) — varchar(30)
  • change_yn (Field40) — varchar(2)
  • first_yn (Field41) — varchar(2)
  • randkey (Field42) — int(11)
  • mbr_id (Field43) — varchar(40)
  • pkg_class (Field44) — varchar(4)
  • pkg_cd (Field45) — varchar(20)
  • ext_id (Field46) — int(11)
  • tch_mbr_id (Field47) — varchar(40)
  • assign_id (Field48) — int(11)
  • p_lesson_id (Field49) — int(11)
  • iTBooksToSeq (Field50) — int(11)
  • iTBooksNeSeq (Field51) — int(11)
  • iTBPageToSeq (Field52) — int(11)
  • iTBPageNeSeq (Field53) — int(11)
  • iTBChapterToSeq (Field54) — int(11)
  • iTBChapterNeSeq (Field55) — int(11)
  • disp_yn (Field56) — varchar(2)
  • iBalanceSeq (Field57) — int(11)
  • nvcRoomCode (Field58) — varchar(5)
  • video_filename (Field59) — varchar(100)

TB_COURSE_LESSON_CHANGE_LOG (course lesson change log)

  • iLogSeq (PK) — int(11) — Primary key — NOT NULL
  • iMemberSeq (Field) — int(11)
  • iOrderDTSeq (Field2) — int(11)
  • iScheduleSeq (Field3) — int(11)
  • from_lession_id (Field4) — int(11)
  • to_lession_id (Field5) — int(11)
  • changeTime (Field6) — varchar(50)
  • lession_id (Field7) — int(11) — NOT NULL
  • changeDate (Field8) — date — NOT NULL
  • changeDateTime (Field9) — datetime — NOT NULL

TB_COURSE_LESSON_ClickLog (course lesson click log)

  • iMemberSeq (PK) — int(11) — Primary key — NOT NULL
  • clickLesson_id (Field) — int(11)
  • clickDate (Field2) — datetime
  • enterDate (Field3) — datetime
  • enterLesson_id (Field4) — int(11)
  • logDescription (Field5) — varchar(100)
  • memberType (Field6) — char(1)
  • memberIP (Field7) — varchar(50)

TB_HOLIDAY (holiday)

  • iHolidaySeq (PK) — int(11) — Primary key — NOT NULL
  • nvcHolidayName (Field) — varchar(50)
  • nvcHoliday (Field2) — varchar(10)
  • lang_cd (Field3) — char(4) — NOT NULL
  • regdate (Field4) — datetime
  • moddate (Field5) — datetime

TB_INTERESTS (interests)

  • IT_IDX (PK) — int(11) — Primary key
  • UPDATE_DATE (UNIQUE KEY) — datetime — Primary key — NOT NULL — UPDATE_DATE_UNIQUE
  • IT_NAME (Field) — varchar(45)
  • DELETE_YN (Field2) — char(1)
  • REG_DATE (Field3) — datetime

TB_INTERESTS_SMALL (interests small)

  • IS_IDX (PK) — int(11) — Primary key — NOT NULL
  • IT_IDX (Field) — int(11)
  • IS_NAME (Field2) — varchar(45)
  • DELETE_YN (Field3) — char(1)
  • REG_DATE (Field4) — datetime
  • UPDATE_DATE (Field5) — datetime

TB_LEVELTEST (leveltest)

  • lvtest_seq (PK) — int(11) — Primary key — NOT NULL
  • iOrderDTSeq (Field) — int(11)
  • prod_name (Field2) — varchar(200)
  • nvcCPCode (Field3) — varchar(5)
  • vcMGCode (Field4) — varchar(5)
  • CRS_TYPE_NUM (Field5) — char(4)
  • lang_cd (Field6) — char(4)
  • iMemberSeq (Field7) — int(11)
  • tester_id (Field8) — varchar(50)
  • tester_name (Field9) — varchar(30)
  • topic_level_cd (Field10) — char(4)
  • topic_type_cd (Field11) — char(4)
  • topic_seq (Field12) — int(11)
  • topic_title (Field13) — varchar(200)
  • SUBJECT (Field14) — varchar(400)
  • regdate (Field15) — datetime
  • start_date (Field16) — varchar(30)
  • end_date (Field17) — varchar(30)
  • complete_date (Field18) — datetime
  • iTeacherSeq (Field19) — int(11)
  • iTeacherName (Field20) — varchar(50)
  • writing_status (Field21) — char(1)
  • file_name (Field22) — varchar(100)
  • academy_name (Field23) — varchar(50)
  • student_level (Field24) — int(11)
  • hit_num (Field25) — int(11)
  • ai_state (Field26) — smallint(6)
  • state (Field27) — int(11)
  • writing_date (Field28) — char(28)
  • teacher_seq (Field29) — int(11)
  • answerer_name (Field30) — varchar(30)
  • answer_date (Field31) — char(28)
  • manager_comment (Field32) — text
  • manager_comment_date (Field33) — char(28)
  • TIMESTAMP (Field34) — varchar(28)
  • second_answerer_name (Field35) — varchar(30)
  • second_answer_date (Field36) — char(28)
  • is_speaking (Field37) — int(11)
  • content_step3_2 (Field38) — varchar(200)
  • content_step3_3 (Field39) — varchar(200)

TB_LEVELTEST_TOPIC (leveltest topic)

  • topic_seq (PK) — int(11) — Primary key — NOT NULL
  • cp_code (Field) — varchar(5)
  • topic_level_cd (Field2) — char(4)
  • topic_type_cd (Field3) — char(4)
  • topic_title (Field4) — varchar(200)
  • information (Field5) — text
  • direction (Field6) — text
  • picture (Field7) — varchar(100)
  • video (Field8) — varchar(100)
  • regdate (Field9) — datetime
  • moddate (Field10) — datetime

TB_LEVEL_CD (level cd)

  • LC_IDX (PK) — int(11) — Primary key — NOT NULL
  • LC_NAME (Field) — varchar(45)
  • DELETE_YN (Field2) — char(1)
  • REG_DATE (Field3) — datetime
  • UPDATE_DATE (Field4) — datetime

TB_MANAGER (manager)

  • iMemberSeq (PK) — int(11) — Primary key — NOT NULL
  • user_type (Field) — int(11)
  • nvcCPCode (Field2) — varchar(5)
  • nvcNGCCode (Field3) — varchar(5)
  • vcMGCode (Field4) — varchar(5)
  • parent_id (Field5) — int(11)
  • admin_id (Field6) — int(11)
  • login_id (Field7) — varchar(32)
  • salt_str (Field8) — varchar(50)
  • password (Field9) — varchar(64)
  • user_level (Field10) — int(11)
  • kor_name (Field11) — varchar(45)
  • nick_name (Field12) — varchar(100)
  • birthday (Field13) — varchar(100)
  • gender (Field14) — varchar(2)
  • email (Field15) — varchar(200)
  • email_yn (Field16) — varchar(2)
  • mobile (Field17) — varchar(100)
  • sms_yn (Field18) — varchar(2)
  • zipcode (Field19) — varchar(20)
  • address1 (Field20) — varchar(400)
  • address2 (Field21) — varchar(400)
  • parent_name (Field22) — varchar(100)
  • parent_mobile (Field23) — varchar(100)
  • parent_sms_yn (Field24) — varchar(2)
  • memo (Field25) — varchar(4000)
  • siFlag (Field26) — smallint(6)
  • reg_date (Field27) — datetime
  • mod_date (Field28) — datetime
  • eng_name (Field29) — varchar(100)
  • jumin_no (Field30) — varchar(100)
  • lunar_yn (Field31) — varchar(2)
  • phone (Field32) — varchar(100)
  • d_zipcode (Field33) — varchar(100)
  • d_address1 (Field34) — varchar(400)
  • d_address2 (Field35) — varchar(400)
  • before_yn (Field36) — varchar(2)
  • after_yn (Field37) — varchar(2)
  • style (Field38) — varchar(4)
  • grade (Field39) — varchar(100)
  • photo (Field40) — varchar(400)
  • total_point (Field41) — int(11)
  • d_memo (Field42) — varchar(4000)
  • join_route (Field43) — varchar(4)
  • org_yn (Field44) — varchar(50)
  • STATUS (Field45) — int(11)
  • mbr_id (Field46) — varchar(20)
  • ex_int (Field47) — int(11)
  • ex_data1 (Field48) — varchar(100)
  • ex_data2 (Field49) — varchar(100)
  • b2b_id (Field50) — varchar(100)
  • delivery_yn (Field51) — varchar(2)
  • noon_yn (Field52) — varchar(2)
  • pc_cnt (Field53) — int(11)
  • lc_np_yn (Field54) — varchar(2)
  • point_use_yn (Field55) — varchar(2)
  • cn (Field56) — int(11)
  • mobile_app_id (Field57) — varchar(64)
  • mobile_app_key (Field58) — varchar(64)
  • mobile_os_name (Field59) — varchar(64)
  • … +21

TB_MEMBER_LoginLog (member login log)

  • iMemberSeq (Field) — int(11)
  • loginDate (Field2) — datetime
  • loginIP (Field3) — varchar(50)
  • serverIP (Field4) — varchar(50)

TB_OLD (old)

  • OD_IDX (PK) — int(11) — Primary key — NOT NULL
  • OD_NAME (Field) — varchar(45)
  • DELETE_YN (Field2) — char(1)
  • REG_DATE (Field3) — datetime
  • UPDATE_DATE (Field4) — datetime

TB_ORDER (order)

  • orderSeq (PK) — int(8) — Primary key — NOT NULL
  • mid (Field) — varchar(10)
  • tid (Field2) — varchar(40)
  • order_id (Field3) — varchar(24)
  • pay_price (Field4) — int(11)
  • timestamp (Field5) — varchar(20)
  • order_date (Field6) — datetime
  • cancel_date (Field7) — datetime
  • cancelDate (Field8) — varchar(8)
  • cancelTime (Field9) — varchar(6)
  • cshrCancelNum (Field10) — varchar(6)
  • pay_date (Field11) — datetime
  • nvcCPCode (Field12) — varchar(5)
  • vcMGCode (Field13) — varchar(5)
  • iMemberSeq (Field14) — int(11)
  • order_name (Field15) — varchar(200)
  • orderer_name (Field16) — varchar(100)
  • orderer_phone (Field17) — varchar(100)
  • orderer_email (Field18) — varchar(100)
  • order_price (Field19) — int(11)
  • pay_method (Field20) — varchar(5)
  • pay_step (Field21) — char(1)
  • applDate (Field22) — varchar(8)
  • applTime (Field23) — varchar(6)
  • VACT_Num (Field24) — varchar(14)
  • VACT_BankCode (Field25) — varchar(2)
  • vactBankName (Field26) — varchar(50)
  • VACT_Date (Field27) — varchar(8)
  • applNum (Field28) — varchar(8)
  • dt_trans (Field29) — varchar(8)
  • tm_trans (Field30) — varchar(6)
  • amt_input (Field31) — varchar(13)
  • dt_cshr (Field32) — varchar(8)
  • tm_cshr (Field33) — varchar(6)
  • no_cshr_appl (Field34) — varchar(9)
  • no_cshr_tid (Field35) — varchar(40)
  • class_per_week (Field36) — int(11)
  • class_period (Field37) — int(11)
  • order_type (Field38) — varchar(2)
  • receiver (Field39) — varchar(200)
  • zipcode (Field40) — varchar(100)
  • address1 (Field41) — varchar(200)
  • address2 (Field42) — varchar(200)
  • COMMENT (Field43) — varchar(4000)
  • receipt_yn (Field44) — varchar(2)
  • receipt_type (Field45) — varchar(4)
  • receipt_no (Field46) — varchar(100)
  • receipt_name (Field47) — varchar(100)
  • temp_price (Field48) — int(11)
  • payer (Field49) — varchar(100)
  • reg_date (Field50) — datetime
  • STATUS (Field51) — int(11)
  • settle_cd (Field52) — varchar(200)
  • settle_class (Field53) — varchar(20)
  • settle_state (Field54) — varchar(20)
  • entry_date (Field55) — datetime
  • mbr_id (Field56) — varchar(40)
  • noon_no (Field57) — varchar(40)
  • dsc_id (Field58) — int(11)
  • advice_status (Field59) — int(11)
  • … +13

TB_ORDER_ITEM (order item)

  • order_item_id (PK) — int(11) — Primary key — NOT NULL
  • order_id (Field) — varchar(24)
  • orderSeq (Field2) — int(8)
  • nvcCPCode (Field3) — varchar(5)
  • vcMGCode (Field4) — varchar(5)
  • iProductSeq (Field5) — int(11)
  • iMemberSeq (Field6) — int(11)
  • iMemberName (Field7) — varchar(50)
  • iMemberPhone (Field8) — varchar(50)
  • CRS_TYPE_NUM (Field9) — char(2)
  • CRS_DAY_NUM (Field10) — char(20)
  • CRS_CLASS_NUM (Field11) — varchar(10)
  • CRS_LESSON_TIME (Field12) — varchar(100) — NOT NULL
  • topic_level_cd (Field13) — char(4)
  • topic_type_cd (Field14) — char(4)
  • topic_seq (Field15) — int(11)
  • topic_title (Field16) — varchar(200)
  • prod_name (Field17) — varchar(200)
  • prod_price (Field18) — int(11)
  • prod_period (Field19) — varchar(1) — NOT NULL
  • iTeacherSeq (Field20) — int(11)
  • iTeacherName (Field21) — varchar(50)
  • pay_date (Field22) — date
  • start_date (Field23) — varchar(16) — NOT NULL
  • end_date (Field24) — varchar(16) — NOT NULL
  • start_time (Field25) — varchar(10) — NOT NULL
  • end_time (Field26) — varchar(10) — NOT NULL
  • siFlag (Field27) — char(1) — NOT NULL
  • useFlag (Field28) — char(1) — NOT NULL
  • STATUS (Field29) — int(11) — NOT NULL
  • iScheduleSeq (Field30) — int(11) — NOT NULL
  • month_cd (Field31) — varchar(16) — NOT NULL
  • option_price (Field32) — int(11) — NOT NULL
  • disc_price (Field33) — int(11) — NOT NULL
  • option_detail (Field34) — varchar(2000) — NOT NULL
  • prod_etc (Field35) — varchar(2000) — NOT NULL
  • prod_num (Field36) — int(11) — NOT NULL
  • item_type (Field37) — varchar(4) — NOT NULL
  • PACKAGE_YN (Field38) — char(1) — NOT NULL

TB_ORDER_SUBJECT (order subject)

  • OS_IDX (PK) — int(11) — Primary key — NOT NULL
  • orderSeq (Field) — int(11) — NOT NULL
  • order_item_id (Field2) — int(11) — NOT NULL
  • CRS_TYPE_NUM (Field3) — int(11) — NOT NULL
  • REG_DATE (Field4) — datetime — NOT NULL
  • UPDATE_DATE (Field5) — datetime — NOT NULL

TB_PART (part)

  • PT_IDX (PK) — int(11) — Primary key — NOT NULL
  • LC_IDX (Field) — int(11) — NOT NULL
  • PT_NAME (Field2) — varchar(10) — NOT NULL
  • DELETE_YN (Field3) — char(1) — NOT NULL
  • REG_DATE (Field4) — datetime — NOT NULL
  • UPDATE_DATE (Field5) — datetime — NOT NULL

TB_PHONICSBOOK (phonicsbook)

  • twinkle_seq (PK) — int(11) — Primary key — NOT NULL

TB_PHONICSBOOK_TOPIC (phonicsbook topic)

  • topic_seq (PK) — int(11) — Primary key — NOT NULL
  • cp_code (Field) — varchar(5) — NOT NULL
  • topic_type_cd (Field2) — char(8) — NOT NULL
  • book_num (Field3) — char(7) — NOT NULL
  • unit_num (Field4) — char(4) — NOT NULL
  • topic_title (Field5) — char(4) — NOT NULL
  • page (Field6) — char(10) — NOT NULL
  • image_url (Field7) — varchar(100) — NOT NULL
  • audio_url (Field8) — varchar(100) — NOT NULL

TB_PRODUCT (product)

  • iProductSeq (PK) — int(11) — Primary key — NOT NULL
  • nvcCPCode (Field) — varchar(5) — NOT NULL
  • lang_cd (Field2) — char(4) — NOT NULL
  • CRS_TYPE_NUM (Field3) — char(2) — NOT NULL
  • PROD_TYPE_NUM (Field4) — char(2) — NOT NULL
  • CRS_DAY_NUM (Field5) — varchar(50) — NOT NULL
  • CRS_USER_NUM (Field6) — varchar(100) — NOT NULL
  • CRS_CLASS_NUM (Field41) — varchar(10) — NOT NULL
  • periodType (Field7) — char(2) — NOT NULL
  • nvcProductName (Field8) — varchar(200) — NOT NULL
  • iPrice (Field9) — int(11)
  • siFlag (Field10) — smallint(3) — NOT NULL
  • siCommonUse (Field11) — smallint(6) — NOT NULL
  • CRS_LESSON_TIME (Field12) — varchar(100) — NOT NULL
  • CRS_WEEK_NUM (Field13) — varchar(100) — NOT NULL
  • Pay_Method (Field14) — varchar(100) — NOT NULL
  • nvcMemo (Field15) — varchar(300) — NOT NULL
  • prod_type (Field16) — int(8) — NOT NULL
  • teacher_type (Field17) — char(4) — NOT NULL
  • prod_desc (Field18) — varchar(1000) — NOT NULL
  • prod_img (Field19) — varchar(400) — NOT NULL
  • prod_eng_name (Field20) — varchar(200) — NOT NULL
  • prod_eng_desc (Field21) — varchar(1000) — NOT NULL
  • phone_msg (Field22) — varchar(400) — NOT NULL
  • prod_code (Field23) — varchar(200) — NOT NULL
  • CRS_MONTH (Field24) — varchar(100) — NOT NULL
  • iCourseSeq (Field25) — int(11) — NOT NULL
  • iTBooksSeq (Field26) — int(11) — NOT NULL
  • iAmount (Field27) — int(11) — NOT NULL
  • disc_price_role (Field28) — int(11) — NOT NULL
  • module (Field29) — varchar(100) — NOT NULL
  • module_id (Field30) — int(11) — NOT NULL
  • comp_cd (Field31) — varchar(200) — NOT NULL
  • ex_code1 (Field32) — varchar(100) — NOT NULL
  • sap_code (Field33) — varchar(100) — NOT NULL
  • service_target_cd (Field34) — varchar(10) — NOT NULL
  • Write_cnt (Field35) — int(11) — NOT NULL
  • period_month (Field36) — int(11) — NOT NULL
  • is_additional (Field37) — smallint(6) — NOT NULL
  • regdate (Field38) — datetime — NOT NULL
  • moddate (Field39) — datetime — NOT NULL
  • PACKAGE_YN (Field40) — char(1) — NOT NULL

TB_PRODUCT_SUBJECT (product subject)

  • PS_IDX (PK) — int(11) — Primary key — NOT NULL
  • iProductSeq (Field) — int(11)
  • CRS_TYPE_NUM (Field2) — int(11) — NOT NULL
  • REG_DATE (Field3) — datetime
  • UPDATE_DATE (Field4) — datetime

TB_QUESTION (question)

  • QT_IDX (PK) — int(11) — Primary key — NOT NULL
  • LC_IDX (Field) — int(11) — NOT NULL
  • PT_IDX (Field2) — int(11) — NOT NULL
  • QT_EXAM_NUM (Field3) — int(11)
  • QT_EXAM_TYPE (Field4) — char(2)
  • QT_EXAM_TITLE (Field5) — varchar(100)
  • QT_EXAM_TIME (Field6) — int(11)
  • QR_EXAM_RECORD (Field7) — varchar(45)
  • QT_EXAM_SAMPLE (Field8) — varchar(145)
  • QT_EXAM_PIC (Field9) — varchar(45)
  • QK_KEYWORD (Field10) — text
  • QT_PASSAGE (Field11) — text
  • QT_ANSWER_CHOICE (Field12) — varchar(250)
  • QT_CORRECT_ANSWER (Field13) — varchar(45)
  • DELETE_YN (Field14) — char(1)
  • REG_DATE (Field15) — datetime — NOT NULL
  • UPDATE_DATE (Field16) — datetime

TB_QUESTION_RESULT (question result)

  • QE_IDX (PK) — int(11) — Primary key — NOT NULL
  • QR_IDX (Field) — int(11) — NOT NULL
  • PT_IDX (Field2) — int(11) — NOT NULL
  • QT_IDX (Field3) — int(11) — NOT NULL
  • QU_USER_RECORD (Field4) — varchar(50)
  • QU_USER_RECORD_STT (Field5) — text
  • QR_USER_TEXT (Field6) — text
  • QR_USER_TOPIC_IDX (Field7) — int(11)
  • QR_CORRECT_ANSWER (Field8) — varchar(45)
  • QR_CORRECT_YN (Field9) — char(1)
  • DELETE_YN (Field10) — char(1)
  • REG_DATE (Field11) — datetime
  • UPDATE_DATE (Field12) — datetime

TB_QUESTION_RESULT_RATING (question result rating)

  • QG (PK) — int(11) — Primary key — NOT NULL
  • QR_IDX (Field) — int(11)
  • SW_TYPE (Field2) — char(1)
  • VO_RAT_CUR (Field3) — int(11)
  • VO_RAT_TOT (Field4) — int(11)
  • VO_CEFR (Field5) — text
  • VO_TEXT (Field6) — text
  • GR_RAT_CUR (Field7) — int(11)
  • GR_RAT_TOT (Field8) — int(11)
  • GR_CEFR (Field9) — text
  • GR_TEXT (Field10) — text
  • CO_RAT_CUR (Field11) — int(11)
  • CO_RAT_TOT (Field12) — int(11)
  • CO_CEFR (Field13) — text
  • CO_TEXT (Field14) — text
  • FL_RAT_CUR (Field15) — int(11)
  • FL_RAT_TOT (Field16) — int(11)
  • FL_CEFR (Field17) — text
  • FL_TEXT (Field18) — text
  • PR_RAT_CUR (Field19) — int(11)
  • PR_RAT_TOT (Field20) — int(11)
  • PR_CEFR (Field21) — text
  • PR_TEXT (Field22) — text
  • IN_RAT_CUR (Field23) — int(11)
  • IN_RAT_TOT (Field24) — int(11)
  • IN_CEFR (Field25) — text
  • IN_TEXT (Field26) — text
  • DI_RAT_CUR (Field27) — int(11)
  • DI_RAT_TOT (Field28) — int(11)
  • DI_CEFR (Field29) — text
  • DI_TEXT (Field30) — text
  • OV_RAT_CUR (Field31) — int(11)
  • OV_RAT_TOT (Field32) — int(11)
  • OV_CEFR (Field33) — text
  • OV_TEXT (Field34) — text
  • SO_RAT_CUR (Field35) — int(11)
  • SO_RAT_TOT (Field36) — int(11)
  • SO_CEFR (Field37) — text
  • SO_TEXT (Field38) — text
  • AC_RAT_CUR (Field39) — int(11)
  • AC_RAT_TOT (Field40) — int(11)
  • AC_CEFR (Field41) — text
  • AC_TEXT (Field42) — text
  • AP_RAT_CUR (Field43) — int(11)
  • AP_RAT_TOT (Field44) — int(11)
  • AP_CEFR (Field45) — text
  • AP_TEXT (Field46) — NULL
  • RMAP_VO_GTEXT (Field48) — text
  • RMAP_VO_MTEXT (Field49) — text
  • RMAP_GR_GTEXT (Field50) — text
  • RMAP_GR_MTEXT (Field51) — text
  • RMAP_CO_GTEXT (Field52) — text
  • RMAP_CO_MTEXT (Field53) — text
  • RMAP_FL_GTEXT (Field54) — text
  • RMAP_FL_MTEXT (Field55) — text
  • RMAP_SO_GTEXT (Field56) — text
  • RMAP_SO_MTEXT (Field57) — text
  • RMAP_AC_GTEXT (Field58) — text
  • RMAP_AC_MTEXT (Field59) — text
  • RMAP_AP_GTEXT (Field60) — text
  • … +16

TB_QUESTION_USER (question user)

  • QU_IDX (PK) — int(11) — Primary key — NOT NULL
  • LC_IDX (Field) — int(11) — NOT NULL
  • IT_IDX (Field2) — int(11) — NOT NULL
  • OD_IDX (Field3) — int(11) — NOT NULL
  • PT_IDX (Field4) — int(11) — NOT NULL
  • QT_IDX (Field5) — int(11) — NOT NULL
  • iMemberSeq (Field6) — int(11)
  • leveltest_seq (Field7) — int(11)
  • QU_USER_RECORD (Field8) — varchar(50)
  • QU_USER_RECORD_STT (Field9) — text
  • QR_USER_TEXT (Field10) — text
  • QR_USER_TOPIC_IDX (Field11) — int(11)
  • QR_CORRECT_ANSWER (Field12) — varchar(45)
  • QR_CORRECT_YN (Field13) — char(1)
  • DELETE_YN (Field14) — char(1)
  • REG_DATE (Field15) — datetime
  • UPDATE_DATE (Field16) — datetime

TB_SCHEDULE (schedule)

  • iScheduleSeq (Field) — int(11) — NOT NULL
  • nvcCPCode (Field2) — varchar(5)
  • teacher_id (Field3) — int(11)
  • iTBooksSeq (Field4) — int(11)
  • lang_cd (Field5) — varchar(4)
  • iCourseSeq (Field6) — int(11)
  • iProductSeq (Field7) — int(11)
  • iBalanceSeq (Field8) — int(11)
  • nvcTCenterCode (Field9) — varchar(5)
  • crs_lesson_time (Field10) — varchar(4)
  • CRS_DAY_NUM (Field11) — varchar(100)
  • crs_week_num (Field12) — varchar(4)
  • crs_code (Field13) — varchar(200)
  • crs_name (Field14) — varchar(200)
  • crs_phone (Field15) — varchar(100)
  • Field16
  • Field17
  • Field18
  • Field19
  • Field20
  • Field21
  • Field22
  • Field23
  • Field24
  • Field25
  • Field26
  • Field27
  • Field28
  • Field29
  • Field30
  • Field31
  • Field32
  • Field33