NEURON_
테이블 (24)
1:1문의(question) (question)
- id — BIGINT — 기본 키 — NOT NULL
- question_type — INT
- question_title — VARCHAR(255)
- question_content — TEXT
- created_at — DATETIME
- question_status — INT
- question_answer — TEXT
- answer_created_at — DATETIME
- user_id (id2) — BIGINT — 외래 키 → 유저(user).id — NOT NULL
diagnosis_circle
- id — BIGINT — 기본 키 — NOT NULL
- circle_info — TEXT
- diagnosis_level — INT
- circle_count — INT
공지사항(notice) (notice)
- id — BIGINT — 기본 키 — NOT NULL
- notice_title — VARCHAR(255)
- notice_content — VARCHAR(255)
- notice_content_detail — TEXT
- notice_count — INT
- notice_file — TEXT
- notice_category — INT
- notice_check — INT
- created_at — DATETIME
- notice_origin_file — TEXT
뉴런자료실(library) (library)
- id — BIGINT — 기본 키 — NOT NULL
- lib_title — VARCHAR(255)
- lib_content — VARCHAR(255)
- lib_content_detail — TEXT
- lib_count — INT
- lib_file — TEXT
- created_at — DATETIME
- lib_origin_file — TEXT
단어(voca) (voca)
- id — BIGINT — 기본 키 — NOT NULL
- voca_word — VARCHAR(255)
- voca_phonetic — VARCHAR(255)
- voca_mean — VARCHAR(255)
- voca_example — TEXT
- voca_example_mean — TEXT
- voca_part — VARCHAR(100)
- voca_unit — VARCHAR(100)
- voca_exam — VARCHAR(100)
단원(unit) (unit)
- id — BIGINT — 기본 키 — NOT NULL
- unit_title — VARCHAR(255)
- unit_genre — VARCHAR(255)
- unit_content — VARCHAR(255)
- unit_title_ko — VARCHAR(255)
- unit_no — INT
- unit_level — INT
단원시험등록(unit_with_exam) (unit_with_exam)
- with_id — BIGINT — 기본 키 — NOT NULL
- exam_id (id2) — BIGINT — 외래 키 → 시험(exam).id — NOT NULL
- unit_id (id3) — BIGINT — 외래 키 → 단원(unit).id — NOT NULL
단원히스토리(unit_history) (unit_history)
- id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME
- unit_history_status — INT
- unit_id (id2) — BIGINT — 외래 키 → 단원(unit).id — NOT NULL
- exam_id (id3) — BIGINT — 외래 키 → 시험(exam).id — NOT NULL
- user_id (id4) — BIGINT — 외래 키 → 유저(user).id — NOT NULL
- roadmap_id (id5) — BIGINT — 외래 키 → 로드맵(roadmap).id — NOT NULL
로드맵 학습센터 마이페이지 목표(roadmap_goal) (roadmap_goal)
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → 유저(user).id
- current_goal — VARCHAR(255)
- next_goal — VARCHAR(255)
- start_date — DATETIME
- current_goal_ids — VARCHAR(255)
- next_goal_ids — VARCHAR(255)
- roadmap_id (id2) — BIGINT — 외래 키 → 로드맵(roadmap).id — NOT NULL
로드맵 히스토리(roadmap_history) (roadmap_history)
- id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME
- roadmap_id (id2) — BIGINT — 외래 키 → 로드맵(roadmap).id — NOT NULL
- user_id (id3) — BIGINT — 외래 키 → 유저(user).id — NOT NULL
로드맵(roadmap) (roadmap)
- id — BIGINT — 기본 키 — NOT NULL
- roadmap_title — VARCHAR(255)
- roadmap_week — INT
- roadmap_file — VARCHAR(255)
- roadmap_origin_file — VARCHAR(255)
- roadmap_course — VARCHAR(255)
- roadmap_type — INT
- roadmap_goal_week — INT
로드맵단원등록(roadmap_with_unit) (roadmap_with_unit)
- with_id — BIGINT — 기본 키 — NOT NULL
- roadmap_id (id2) — BIGINT — 외래 키 → 로드맵(roadmap).id — NOT NULL
- unit_id (id3) — BIGINT — 외래 키 → 단원(unit).id — NOT NULL
문제 히스토리(question_history) (question_history)
- id — BIGINT — 기본 키 — NOT NULL
- question_id — BIGINT — 외래 키 → 시험문제(exam_question).qid
- q_history_correct — INT
- q_history_answer — TEXT
- q_history_my_answer_sentence — TEXT
- user_id (id2) — BIGINT — 외래 키 → 유저(user).id — NOT NULL
- exam_id (id3) — BIGINT — 외래 키 → 시험(exam).id — NOT NULL
- unit_id (id4) — BIGINT — 외래 키 → 단원(unit).id — NOT NULL
- roadmap_id (id5) — BIGINT — 외래 키 → 로드맵(roadmap).id — NOT NULL
배너(banner) (banner)
- id — BIGINT — 기본 키 — NOT NULL
- banner_image — TEXT
- banner_origin_image — TEXT
- banner_title — VARCHAR(255)
- banner_career — TEXT
시험(exam) (exam)
- id — BIGINT — 기본 키 — NOT NULL
- exam_type — INT
- exam_class — INT
- exam_level — INT
- exam_title — VARCHAR(255)
- exam_grade — VARCHAR(255)
- exam_count — INT
- exam_limit_time — INT
- exam_total — INT
시험결과(exam_result) (exam_result)
- id — BIGINT — 기본 키 — NOT NULL
- exam_pass — INT
- e_school_total_grade — INT
- e_school_level_rank — INT
- e_school_total_level — INT
- e_school_grade_rank — INT
- e_do_total_grade — INT
- e_do_level_rank — INT
- e_do_grade_rank — INT
- e_wide_total_grade — INT
- e_wide_level_rank — INT
- e_wide_total_level — INT
- e_wide_grade_rank — INT
- e_do_total_level — INT
- e_my_rank — INT
- e_total_rank — INT
- e_correct_count — INT
- e_total_count — INT
- e_total_score — INT
- e_exam_class — INT
- e_my_score — TEXT
- e_average_score — TEXT
- e_genre — TEXT
- e_exam_type — INT
- e_exam_level — INT
- e_school_grade_avg — INT
- e_school_level_avg — INT
- e_do_grade_avg — INT
- e_do_level_avg — INT
- e_wide_grade_avg — INT
- e_wide_level_avg — INT
- exam_id (id2) — BIGINT — 외래 키 → 시험(exam).id — NOT NULL
- user_id (id3) — BIGINT — 외래 키 → 유저(user).id — NOT NULL
- roadmap_id (id4) — BIGINT — 외래 키 → 로드맵(roadmap).id — NOT NULL
- unit_id (id5) — BIGINT — 외래 키 → 단원(unit).id — NOT NULL
시험단어등록(exam_with_voca) (exam_with_voca)
- with_id — BIGINT — 기본 키 — NOT NULL
- exam_id (id2) — BIGINT — 외래 키 → 시험(exam).id — NOT NULL
- voca_id (id3) — BIGINT — 외래 키 → 단어(voca).id — NOT NULL
시험문제(exam_question) (exam_question)
- qid — BIGINT — 기본 키 — NOT NULL
- e_question_content — TEXT
- e_question_answer — TEXT
- e_question_no — INT
- e_question_type — INT
- e_question_translation — TEXT
- e_question_category — INT
- e_question_title — VARCHAR(255)
- e_question_example_alp — TEXT
- e_question_example — TEXT
- e_question_subject — VARCHAR(255)
- e_question_explanation — TEXT
- e_question_genre_detail — VARCHAR(255)
- e_question_sentence — TEXT
- e_question_genre — VARCHAR(255)
- e_question_voca — TEXT
시험문제등록(exam_with_question) (exam_with_question)
- with_id — BIGINT — 기본 키 — NOT NULL
- exam_id — BIGINT — 외래 키 → 시험(exam).id
- question_id — BIGINT — 외래 키 → 시험문제(exam_question).qid
시험일시정지(stop_question) (stop_question)
- stop_id — BIGINT — 기본 키 — NOT NULL
- stop_remain_time — DATETIME
- user_id — BIGINT — 외래 키 → 유저(user).id
- stop_category — INT
- exam_id (id2) — BIGINT — 외래 키 → 시험(exam).id — NOT NULL
유저(user) (user)
- id — BIGINT — 기본 키 — NOT NULL
- user_name — VARCHAR(100)
- user_id — VARCHAR(100) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- user_phone — VARCHAR(30)
- user_email — VARCHAR(200)
- user_gender — VARCHAR(30)
- user_birth — VARCHAR(100)
- user_course — INT
- user_area — VARCHAR(50)
- user_type — INT
- user_school — VARCHAR(100)
- user_grade — VARCHAR(50)
- user_eng_time — VARCHAR(50)
- user_exam_grade — VARCHAR(50)
- user_personal_grade — VARCHAR(50)
- user_role — VARCHAR(45) — NOT NULL
- user_login_type — INT
- created_at — DATETIME
- updated_at — DATETIME
- user_child_ids — VARCHAR(50)
- user_profile — TEXT
- user_is_test — INT
- user_current_level — INT
- user_profile_origin — TEXT
- user_last_test_date — DATETIME
- roadmap_id — BIGINT
- user_start_roadmap_date — DATETIME
- user_stop_count — INT
- user_stop_week — BIGINT
- user_stop_day — BIGINT
- user_process — INT
- parent_id — BIGINT
자동로그인(persistent_logins) (persistent_logins)
- series — VARCHAR(64) — 기본 키 — NOT NULL
- username — VARCHAR(255) — NOT NULL
- token — VARCHAR(64) — NOT NULL
- last_used — TIMESTAMP — NOT NULL
자주묻는질문(qna) (qna)
- id — BIGINT — 기본 키 — NOT NULL
- qna_question — TEXT
- qna_answer — TEXT
- qna_category — INT
- created_at — DATETIME
학습 일시정지(stop) (stop)
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → 유저(user).id
- stop_start — DATETIME
- stop_end — DATETIME
- stop_type — INT
- stop_message — VARCHAR(255)
- stop_week — BIGINT
- stop_day — BIGINT
- INDEX — `f_u_key_idx`