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`