rest

Tables (23)

TOPIK1_question_subtype

  • TOPIK1_subtype_id — INT — Primary key — NOT NULL
  • TOPIK1_question_subtype — VARCHAR(50) — NOT NULL

TOPIK1_question_type

  • TOPIK1_type_id — INT — Primary key — NOT NULL
  • TOPIK1_question_type — VARCHAR(50) — NOT NULL

TOPIK1_reading_ai

  • sentence_id — INT — Primary key — NOT NULL — AI로 생성 전 문장의 고유번호
  • TOPIK1_type_id — INT — Foreign key → TOPIK1_question_type.TOPIK1_type_id — NOT NULL
  • TOPIK1_subtype_id — INT
  • question_sentence — VARCHAR(1500) — NOT NULL
  • question_answer — VARCHAR(255)
  • question_wrong — VARCHAR(255)
  • sentence_used — ENUM('0', '1') — NOT NULL

TOPIK1_reading_bank

  • TOPIK1_type_id — INT — Foreign key → TOPIK1_question_type.TOPIK1_type_id — NOT NULL
  • TOPIK1_subtype_id — INT
  • TOPIK1_ng — INT
  • question_set — INT
  • paragraph — VARCHAR(1500)
  • question_image — VARCHAR(255)
  • question_answer — VARCHAR(255) — NOT NULL
  • question_wrong — VARCHAR(255) — NOT NULL

TOPIK1_user_mock_id

  • user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
  • TOPIK1_results_date — TIMESTAMP — NOT NULL
  • paragraph_id_01 — INT — NOT NULL
  • paragraph_id_02 — INT — NOT NULL
  • paragraph_id_03 — INT — NOT NULL
  • paragraph_id_04 — INT — NOT NULL
  • paragraph_id_05 — INT — NOT NULL
  • paragraph_id_06 — INT — NOT NULL
  • paragraph_id_07 — INT — NOT NULL
  • paragraph_id_08 — INT — NOT NULL
  • paragraph_id_09 — INT — NOT NULL
  • paragraph_id_10 — INT — NOT NULL
  • paragraph_id_11 — INT — NOT NULL
  • paragraph_id_12 — INT — NOT NULL
  • paragraph_id_13 — INT — NOT NULL
  • paragraph_id_14 — INT — NOT NULL
  • paragraph_id_15 — INT — NOT NULL
  • paragraph_id_16 — INT — NOT NULL
  • paragraph_id_17 — INT — NOT NULL
  • paragraph_id_18 — INT — NOT NULL
  • paragraph_id_19 — INT — NOT NULL
  • paragraph_id_20 — INT — NOT NULL
  • paragraph_id_21 — INT — NOT NULL
  • paragraph_id_22 — INT — NOT NULL
  • paragraph_id_23 — INT — NOT NULL
  • paragraph_id_24 — INT — NOT NULL
  • paragraph_id_25 — INT — NOT NULL
  • paragraph_id_26 — INT — NOT NULL
  • paragraph_id_27 — INT — NOT NULL
  • paragraph_id_28 — INT — NOT NULL
  • paragraph_id_29 — INT — NOT NULL
  • paragraph_id_30 — INT — NOT NULL
  • paragraph_id_31 — INT — NOT NULL
  • paragraph_id_32 — INT — NOT NULL
  • paragraph_id_33 — INT — NOT NULL
  • paragraph_id_34 — INT — NOT NULL
  • paragraph_id_35 — INT — NOT NULL
  • paragraph_id_36 — INT — NOT NULL
  • paragraph_id_37 — INT — NOT NULL
  • paragraph_id_38 — INT — NOT NULL
  • paragraph_id_39 — INT — NOT NULL
  • paragraph_id_40 — INT — NOT NULL
  • paragraph_id_41 — INT — NOT NULL
  • paragraph_id_42 — INT — NOT NULL
  • paragraph_id_43 — INT — NOT NULL
  • paragraph_id_44 — INT — NOT NULL
  • paragraph_id_45 — INT — NOT NULL
  • paragraph_id_46 — INT — NOT NULL
  • paragraph_id_47 — INT — NOT NULL
  • paragraph_id_48 — INT — NOT NULL
  • paragraph_id_49 — INT — NOT NULL
  • paragraph_id_50 — INT — NOT NULL
  • paragraph_id_51 — INT — NOT NULL
  • paragraph_id_52 — INT — NOT NULL
  • paragraph_id_53 — INT — NOT NULL
  • paragraph_id_54 — INT — NOT NULL
  • paragraph_id_55 — INT — NOT NULL
  • paragraph_id_56 — INT — NOT NULL
  • paragraph_id_57 — INT — NOT NULL
  • paragraph_id_58 — INT — NOT NULL
  • … +12

TOPIK1_user_mock_results

  • user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
  • TOPIK1_results_date — TIMESTAMP — NOT NULL
  • TOPIK1_results_01 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_02 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_03 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_04 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_05 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_06 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_07 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_08 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_09 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_10 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_11 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_12 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_13 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_14 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_15 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_16 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_17 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_18 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_19 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_20 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_21 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_22 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_23 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_24 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_25 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_26 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_27 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_28 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_29 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_30 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_31 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_32 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_33 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_34 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_35 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_36 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_37 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_38 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_39 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_40 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_41 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_42 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_43 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_44 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_45 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_46 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_47 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_48 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_49 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_50 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_51 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_52 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_53 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_54 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_55 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_56 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_57 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK1_results_58 — ENUM('0' , '1' ) — NOT NULL
  • … +12

TOPIK1_user_mock_results_type

  • user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
  • TOPIK1_results_listening — INT — NOT NULL
  • TOPIK1_results_reading — INT — NOT NULL
  • TOPIK1_results_total — INT — NOT NULL
  • TOPIK1_results_0104 — INT — NOT NULL — 물음에 맞는 대답 고르기
  • TOPIK1_results_0506 — INT — NOT NULL — 대화에 이어지는 말 고르기
  • TOPIK1_results_0710 — INT — NOT NULL — 대화의 장소 파악
  • TOPIK1_results_1114 — INT — NOT NULL — 대화의 화재 파악
  • TOPIK1_results_1516 — INT — NOT NULL — 대화 상황에 알맞는 그림 파악
  • TOPIK1_results_1721 — INT — NOT NULL — 대화 상황과 같은 내용 파악
  • TOPIK1_results_2224 — INT — NOT NULL — 중심생각 파악
  • TOPIK1_results_2530 — INT — NOT NULL — 복합 문제
  • TOPIK1_results_subtype01 — INT — NOT NULL — 대화의 목적 파악
  • TOPIK1_results_subtype02 — INT — NOT NULL — 대화 상황과 같은 내용 파악
  • TOPIK1_results_subtype03 — INT — NOT NULL — 대화의 중심 내용 파악
  • TOPIK1_results_subtype04 — INT — NOT NULL — 대화의 상황에서 이유 파악
  • TOPIK1_results_3133 — INT — NOT NULL — 문장의 중심 소재 파악
  • TOPIK1_results_3439 — INT — NOT NULL — 빈칸 채우기초급
  • TOPIK1_results_4042 — INT — NOT NULL — 맞지 않는 내용 파악
  • TOPIK1_results_4345 — INT — NOT NULL — 글과 같은 내용 파악
  • TOPIK1_results_4648 — INT — NOT NULL — 글의 중심내용 파악
  • TOPIK1_results_5758 — INT — NOT NULL — 문장 순서 배열
  • TOPIK1_results_4970 — INT — NOT NULL — 복합 문제(49~70, 57~58 제외)
  • TOPIK1_results_subtype05 — INT — NOT NULL — 빈칸 채우기중급
  • TOPIK1_results_subtype06 — INT — NOT NULL — 같은 내용 파악
  • TOPIK1_results_subtype07 — INT — NOT NULL — 글의 중심내용 파악
  • TOPIK1_results_subtype08 — INT — NOT NULL — 문장 위치 파악
  • TOPIK1_results_subtype09 — INT — NOT NULL — 글을 쓴 이유 파악
  • TOPIK1_results_subtype10 — INT — NOT NULL — 문맥 파악
  • TOPIK1_results_subtype11 — INT — NOT NULL — 명사 빈칸
  • TOPIK1_results_subtype12 — INT — NOT NULL — 조사 빈칸
  • TOPIK1_results_subtype13 — INT — NOT NULL — 동사 빈칸
  • TOPIK1_results_subtype14 — INT — NOT NULL — 일반부사 빈칸
  • TOPIK1_results_subtype15 — INT — NOT NULL — 동사어미 빈칸
  • TOPIK1_results_date — TIMESTAMP — NOT NULL

TOPIK1_user_results_type

  • user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
  • paragraph_id — INT — Foreign key → create_TOPIK1_question.paragraph_id — NOT NULL
  • TOPIK1_type_id — INT — Foreign key → TOPIK1_question_type.TOPIK1_type_id — NOT NULL
  • TOPIK1_subtype_id — INT
  • division_exercise_mock — ENUM('0' , '1') — NOT NULL
  • user_question_time — TIME — NOT NULL
  • correct_results — ENUM('0' , '1') — NOT NULL
  • TOPIK1_results_date — TIMESTAMP — NOT NULL

TOPIK2_listening

  • TOPIK2_listening_file — VARCHAR(255) — Primary key — NOT NULL
  • TOPIK2_type_id — INT — Foreign key → TOPIK2_question_type.TOPIK2_type_id — NOT NULL
  • TOPIK2_subtype_id — INT — NOT NULL
  • question_set — INT
  • TOPIK2_question — VARCHAR(255)
  • question_wrong — VARCHAR(255) — NOT NULL
  • question_answer — VARCHAR(255) — NOT NULL

TOPIK2_question_subtype

  • TOPIK2_subtype_id — INT — Primary key — NOT NULL
  • TOPIK2_question_subtype — VARCHAR(50) — NOT NULL

TOPIK2_question_type

  • TOPIK2_type_id — INT — Primary key — NOT NULL
  • TOPIK2_question_type — VARCHAR(50) — NOT NULL

TOPIK2_reading_bank

  • TOPIK2_type_id — INT — Foreign key → TOPIK2_question_type.TOPIK2_type_id — NOT NULL
  • TOPIK2_subtype_id — INT — NOT NULL
  • TOPIK2_ng — INT
  • question_set — INT
  • paragraph — VARCHAR(1500)
  • question_image — VARCHAR(255)
  • question_answer — VARCHAR(255) — NOT NULL
  • question_wrong — VARCHAR(255) — NOT NULL

TOPIK2_reading_writing_ai

  • sentence_id — INT — Primary key — NOT NULL — AI로 생성 전 문장의 고유번호
  • TOPIK2_type_id — INT — Foreign key → TOPIK2_question_type.TOPIK2_type_id — NOT NULL
  • TOPIK2_subtype_id — INT — NOT NULL
  • question_sentence — VARCHAR(1500) — NOT NULL
  • question_answer — VARCHAR(255)
  • question_wrong — VARCHAR(255)
  • sentence_used — ENUM('0', '1') — NOT NULL

TOPIK2_user_mock_id

  • user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
  • TOPIK2_results_date — TIMESTAMP — NOT NULL
  • paragraph_1_id_01 — INT — NOT NULL
  • paragraph_1_id_02 — INT — NOT NULL
  • paragraph_1_id_03 — INT — NOT NULL
  • paragraph_1_id_04 — INT — NOT NULL
  • paragraph_1_id_05 — INT — NOT NULL
  • paragraph_1_id_06 — INT — NOT NULL
  • paragraph_1_id_07 — INT — NOT NULL
  • paragraph_1_id_08 — INT — NOT NULL
  • paragraph_1_id_09 — INT — NOT NULL
  • paragraph_1_id_10 — INT — NOT NULL
  • paragraph_1_id_11 — INT — NOT NULL
  • paragraph_1_id_12 — INT — NOT NULL
  • paragraph_1_id_13 — INT — NOT NULL
  • paragraph_1_id_14 — INT — NOT NULL
  • paragraph_1_id_15 — INT — NOT NULL
  • paragraph_1_id_16 — INT — NOT NULL
  • paragraph_1_id_17 — INT — NOT NULL
  • paragraph_1_id_18 — INT — NOT NULL
  • paragraph_1_id_19 — INT — NOT NULL
  • paragraph_1_id_20 — INT — NOT NULL
  • paragraph_1_id_21 — INT — NOT NULL
  • paragraph_1_id_22 — INT — NOT NULL
  • paragraph_1_id_23 — INT — NOT NULL
  • paragraph_1_id_24 — INT — NOT NULL
  • paragraph_1_id_25 — INT — NOT NULL
  • paragraph_1_id_26 — INT — NOT NULL
  • paragraph_1_id_27 — INT — NOT NULL
  • paragraph_1_id_28 — INT — NOT NULL
  • paragraph_1_id_29 — INT — NOT NULL
  • paragraph_1_id_30 — INT — NOT NULL
  • paragraph_1_id_31 — INT — NOT NULL
  • paragraph_1_id_32 — INT — NOT NULL
  • paragraph_1_id_33 — INT — NOT NULL
  • paragraph_1_id_34 — INT — NOT NULL
  • paragraph_1_id_35 — INT — NOT NULL
  • paragraph_1_id_36 — INT — NOT NULL
  • paragraph_1_id_37 — INT — NOT NULL
  • paragraph_1_id_38 — INT — NOT NULL
  • paragraph_1_id_39 — INT — NOT NULL
  • paragraph_1_id_40 — INT — NOT NULL
  • paragraph_1_id_41 — INT — NOT NULL
  • paragraph_1_id_42 — INT — NOT NULL
  • paragraph_1_id_43 — INT — NOT NULL
  • paragraph_1_id_44 — INT — NOT NULL
  • paragraph_1_id_45 — INT — NOT NULL
  • paragraph_1_id_46 — INT — NOT NULL
  • paragraph_1_id_47 — INT — NOT NULL
  • paragraph_1_id_48 — INT — NOT NULL
  • paragraph_1_id_49 — INT — NOT NULL
  • paragraph_1_id_50 — INT — NOT NULL
  • paragraph_1_id_51 — TEXT
  • paragraph_1_id_52 — TEXT
  • paragraph_1_id_53 — TEXT
  • paragraph_1_id_54 — TEXT
  • paragraph_2_id_01 — INT — NOT NULL
  • paragraph_2_id_02 — INT — NOT NULL
  • paragraph_2_id_03 — INT — NOT NULL
  • paragraph_2_id_04 — INT — NOT NULL
  • … +46

TOPIK2_user_mock_results

  • user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
  • TOPIK2_results_date — TIMESTAMP — NOT NULL
  • TOPIK2_1_results_01 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_02 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_03 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_04 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_05 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_06 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_07 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_08 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_09 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_10 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_11 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_12 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_13 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_14 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_15 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_16 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_17 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_18 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_19 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_20 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_21 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_22 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_23 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_24 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_25 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_26 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_27 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_28 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_29 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_30 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_31 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_32 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_33 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_34 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_35 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_36 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_37 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_38 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_39 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_40 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_41 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_42 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_43 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_44 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_45 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_46 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_47 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_48 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_49 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_50 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_51 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_52 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_53 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_1_results_54 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_2_results_01 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_2_results_02 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_2_results_03 — ENUM('0' , '1' ) — NOT NULL
  • TOPIK2_2_results_04 — ENUM('0' , '1' ) — NOT NULL
  • … +46

TOPIK2_user_mock_results_type

  • user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
  • TOPIK2_results_listening — INT — NOT NULL
  • TOPIK2_results_reading — INT — NOT NULL
  • TOPIK2_1_results_total — INT — NOT NULL
  • TOPIK1_1_results_0103 — INT — NOT NULL — 일치하는 그림/도표 고르기
  • TOPIK1_1_results_0408 — INT — NOT NULL — 대화에 이어지는 말 고르기
  • TOPIK1_1_results_0912 — INT — NOT NULL — 대화 후 알맞은 행동 고르기
  • TOPIK1_1_results_1316 — INT — NOT NULL — 일치하는 내용 고르기
  • TOPIK1_1_results_1720 — INT — NOT NULL — 중심 생각 고르기
  • TOPIK1_1_results_2136 — INT — NOT NULL — 세트 문제일반
  • TOPIK1_1_results_3750 — INT — NOT NULL — 세트 문제상황 제시
  • TOPIK1_1_results_subtype01 — INT — NOT NULL — 중심 생각 고르기
  • TOPIK1_1_results_subtype02 — INT — NOT NULL — 일치하는 내용 고르기
  • TOPIK1_1_results_subtype03 — INT — NOT NULL — 화자의 행동 고르기
  • TOPIK1_1_results_subtype04 — INT — NOT NULL — 화자의 의도 고르기
  • TOPIK1_1_results_subtype05 — INT — NOT NULL — 화자가 누구인지 고르기
  • TOPIK1_1_results_subtype06 — INT — NOT NULL — 화자의 생각 고르기
  • TOPIK1_1_results_subtype07 — INT — NOT NULL — 화자의 태도 고르기
  • TOPIK1_1_results_subtype08 — INT — NOT NULL — 중심 내용 고르기
  • TOPIK1_1_results_subtype09 — INT — NOT NULL — 담화 전후 내용 파악
  • TOPIK1_1_results_subtype10 — INT — NOT NULL — 세부 내용 파악하기
  • TOPIK1_2_results_0102 — INT — NOT NULL — 빈칸 채우기중급
  • TOPIK1_2_results_0304 — INT — NOT NULL — 의미가 비슷한 말 고르기
  • TOPIK1_2_results_0508 — INT — NOT NULL — 중심내용 파악
  • TOPIK1_2_results_0912 — INT — NOT NULL — 일치하는 내용 고르기
  • TOPIK1_2_results_subtype01 — INT — NOT NULL — 도표의 내용과 같은 것 고르기
  • TOPIK1_2_results_subtype02 — INT — NOT NULL — 글의 내용과 같은 것 고르기
  • TOPIK1_2_results_1315 — INT — NOT NULL — 문장 순서 배열
  • TOPIK1_2_results_1631 — INT — NOT NULL — 빈칸 채우기고급, 16~18, 28~31
  • TOPIK1_2_results_subtype03 — INT — NOT NULL — 빈칸 채우기 : 16~18번
  • TOPIK1_2_results_1924 — INT — NOT NULL — 세트 문제일반1
  • TOPIK1_2_results_subtype04 — INT — NOT NULL — 빈칸 채우기 : 접속부사
  • TOPIK1_2_results_subtype05 — INT — NOT NULL — 같은 내용 파악
  • TOPIK1_2_results_subtype06 — INT — NOT NULL — 빈칸 채우기 : 숙어
  • TOPIK1_2_results_subtype07 — INT — NOT NULL — 중심 생각 파악
  • TOPIK1_2_results_subtype08 — INT — NOT NULL — 심정 파악
  • TOPIK1_2_results_2527 — INT — NOT NULL — 중심내용 파악 : 신문 기사 제목
  • TOPIK1_2_results_subtype09 — INT — NOT NULL — 빈칸 채우기 : 28~31번
  • TOPIK1_2_results_3234 — INT — NOT NULL — 같은 내용 파악
  • TOPIK1_2_results_3538 — INT — NOT NULL — 글의 주제 파악
  • TOPIK1_2_results_3941 — INT — NOT NULL — 문장 위치 파악
  • TOPIK1_2_results_4243 — INT — NOT NULL — 세트 문제장문
  • TOPIK1_2_results_4447 — INT — NOT NULL — 세트 문제일반2
  • TOPIK1_2_results_4850 — INT — NOT NULL — 세트 문제정치/경제
  • TOPIK1_results_subtype05 — INT — NOT NULL — 빈칸 채우기중급
  • TOPIK1_results_subtype06 — INT — NOT NULL — 같은 내용 파악
  • TOPIK1_results_subtype07 — INT — NOT NULL — 글의 중심내용 파악
  • TOPIK1_results_subtype08 — INT — NOT NULL — 문장 위치 파악
  • TOPIK1_results_subtype09 — INT — NOT NULL — 글을 쓴 이유 파악
  • TOPIK1_results_subtype10 — INT — NOT NULL — 문맥 파악
  • TOPIK1_results_subtype11 — INT — NOT NULL — 명사 빈칸
  • TOPIK1_results_subtype12 — INT — NOT NULL — 조사 빈칸
  • TOPIK1_results_subtype13 — INT — NOT NULL — 동사 빈칸
  • TOPIK1_results_subtype14 — INT — NOT NULL — 일반부사 빈칸
  • TOPIK1_results_subtype15 — INT — NOT NULL — 동사어미 빈칸
  • TOPIK1_results_date — TIMESTAMP — NOT NULL

TOPIK2_user_results_type

  • user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
  • paragraph_id — INT — Foreign key → create_TOPIK2_question.paragraph_id — NOT NULL — 지문별 고유번호. 중복방지
  • TOPIK2_type_id — INT — Foreign key → TOPIK2_question_type.TOPIK2_type_id — NOT NULL
  • TOPIK2_subtype_id — INT — NOT NULL
  • division_exercise_mock — ENUM('0' , '1') — NOT NULL
  • user_question_time — TIME — NOT NULL
  • correct_results — ENUM('0' , '1') — NOT NULL
  • TOPIK2_results_date — TIMESTAMP — NOT NULL

board_comment

  • comment_id — INT — Primary key — NOT NULL
  • notice_board_id — INT — Foreign key → notice_board.notice_board_id — NOT NULL
  • comment — TEXT — NOT NULL
  • write_date — TIMESTAMP — NOT NULL
  • writer — VARCHAR(50) — NOT NULL
  • comment_ban — ENUM('0','1') — NOT NULL

board_reply

  • reply_id — INT — Primary key — NOT NULL
  • comment_id — INT — Foreign key → board_comment.comment_id — NOT NULL
  • notice_board_id — INT — Foreign key → board_comment.notice_board_id — NOT NULL
  • comment — TEXT — NOT NULL
  • write_date — TIMESTAMP — NOT NULL
  • writer — VARCHAR(50) — NOT NULL
  • recomment_ban — ENUM('0','1') — NOT NULL

create_TOPIK1_question

  • paragraph_id — INT — Primary key — NOT NULL — 지문별 고유번호. 중복방지
  • TOPIK1_type_id — INT — Foreign key → TOPIK1_question_type.TOPIK1_type_id — NOT NULL
  • TOPIK1_subtype_id — INT
  • sentence_id — INT — AI로 생성 전 문장의 고유번호
  • question_set — INT — 한 지문에 2개 문제 세트 확인
  • paragraph — VARCHAR(1500)
  • question_image — VARCHAR(255) — 문제사진 이름
  • TOPIK1_question — VARCHAR(255) — 듣기 29번 문제 질문
  • question_answer — VARCHAR(255) — NOT NULL
  • question_wrong — VARCHAR(255) — NOT NULL — '/' 로 구분
  • question_counts — INT — NOT NULL — 처음에 0 input
  • question_used — ENUM('0', '1') — NOT NULL
  • listening_check — ENUM('0', '1') — NOT NULL

create_TOPIK2_question

  • paragraph_id — INT — Primary key — NOT NULL — 지문별 고유번호. 중복방지
  • TOPIK2_type_id — INT — Foreign key → TOPIK2_question_type.TOPIK2_type_id — NOT NULL
  • TOPIK2_subtype_id — INT
  • sentence_id — INT — AI로 생성 전 문장의 고유번호
  • TOPIK2_listening_file — VARCHAR(255)
  • question_set — INT — 한 지문에 2개 문제 세트 확인
  • paragraph — VARCHAR(1500)
  • question_image — VARCHAR(255) — 문제사진 이름
  • TOPIK2_question — VARCHAR(255) — 듣기 29번 문제 질문
  • question_answer — VARCHAR(255) — NOT NULL
  • question_wrong — VARCHAR(255) — NOT NULL — / 로 구분
  • question_counts — INT — NOT NULL — 처음에 0 input
  • question_used — ENUM('0', '1') — NOT NULL

notice_board

  • notice_board_id — INT — Primary key — NOT NULL
  • admin — ENUM('0' , '1') — NOT NULL
  • notice_board_title — VARCHAR(100) — NOT NULL
  • notice_board_contents — TEXT — NOT NULL
  • notice_board_bookmark — ENUM('' , '-fill') — NOT NULL
  • write_date — TIMESTAMP — NOT NULL
  • view_counts — INT — NOT NULL
  • writer — VARCHAR(50) — NOT NULL
  • board_ban — ENUM('0','1') — NOT NULL

user_info

  • user_id — VARCHAR(100) — Primary key — NOT NULL
  • admin — ENUM('0' , '1') — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • user_password — VARCHAR(100) — NOT NULL
  • user_country — VARCHAR(30) — NOT NULL
  • user_type — ENUM('0' , '1' , '2') — NOT NULL
  • user_in_date — DATATIME — NOT NULL
  • user_out_date — DATETIME
  • user_nickname — VARCHAR(50) — NOT NULL
  • user_ban — ENUM('0','B','C','Q','BC','A') — NOT NULL
  • user_delete_check — ENUM('0','1') — NOT NULL