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