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