test

Tables (66)

area

  • area_id — BIGINT — NOT NULL
  • area_name — VARCHAR(100) — NOT NULL

attached_files

  • document_attached_file_id — BIGINT — NOT NULL
  • document_attached_file_url — VARCHAR(150) — NOT NULL

attendance

  • attendance_date — DATE — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL
  • enter_time — TIME
  • checkout_time — TIME
  • explained — TINYINT — NOT NULL
  • attendance_type_id — BIGINT — NOT NULL
  • attendance_explain_id — BIGINT — NOT NULL

attendance_explain

  • attendance_explain_id — BIGINT — NOT NULL
  • attendance_explain_result_type_id — BIGINT — NOT NULL
  • attendance_explain_content — VARCHAR(1000)
  • attendance_explain_file — VARCHAR(150)

attendance_type

  • attendance_type_id — BIGINT — NOT NULL
  • attentance_type — VARCHAR(10) — NOT NULL

class_info

  • class_id — BIGINT — NOT NULL
  • class_room_number — INT — NOT NULL
  • class_number — INT — NOT NULL
  • cardinal_number — INT — NOT NULL
  • teacher_name — VARCHAR(20) — NOT NULL

comment

  • comment_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_anonymous — BOOLEAN — NOT NULL

curriculum

  • curriculum_id — BIGINT — Primary key — NOT NULL
  • ebook_id — BIGINT — Primary key — NOT NULL
  • date — DATETIME — NOT NULL
  • type — ENUM('코딩과정', '프로젝트', '알고리즘', '기타') — NOT NULL
  • youtube_link — varchar(100) — 당일에만 생성되며 이후에는 사라진다
  • classification — varchar(100) — NOT NULL
  • subject — varchar(100) — NOT NULL
  • cardinal_number — BIGINT — NOT NULL — INDEX

documents

  • document_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL
  • document_attached_file_id — BIGINT — NOT NULL
  • document_type_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • contents — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL

e_learning

  • e_learning_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • recommend_count — BIGINT — NOT NULL
  • e_learning_item_id — BIGINT — NOT NULL

e_learning_attend

  • e_learning_id — BIGINT — Primary key — NOT NULL — PK
  • member_id — BIGINT — Primary key — NOT NULL — PK
  • status — ENUM — NOT NULL
  • recommend_status — TINYINT(1) — NOT NULL
  • attended_at — DATETIME — NOT NULL

e_learning_item

  • e_learning_item_id — BIGINT — NOT NULL
  • e_learning_category_id — BIGINT — NOT NULL
  • name — VARCHAR(100)

ebook

  • ebook_id — BIGINT — NOT NULL
  • cardinal_number — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • link — VARCHAR(150) — NOT NULL
  • like_count — BIGINT — NOT NULL
  • view_count — BIGINT — NOT NULL
  • favorite_count — BIGINT — NOT NULL
  • category — VARCHAR(20) — NOT NULL

evaluation

  • evaluation_id — BIGINT — NOT NULL
  • test_id — BIGINT — NOT NULL
  • description — VARCHAR(1000)

experience_item

  • item_id — BIGINT — NOT NULL
  • category_id — TINYINT — NOT NULL
  • item_text — VARCHAR(100) — NOT NULL
  • item_fixed_reward — INT — NOT NULL

faq

  • faq_id — BIGINT — NOT NULL
  • faq_type_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL

faq_type

  • faq_type_id — BIGINT — NOT NULL
  • faq_type_name — VARCHAR(20) — NOT NULL

favorite_e_learning

  • e_learning_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL

favorite_ebook

  • ebook_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL

favorite_lecture

  • lecture_replay_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL

favorite_post

  • post_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL

level_exp_table

  • rank — VARCHAR(100) — Primary key — NOT NULL
  • tier — INT — Primary key — NOT NULL
  • exp_lower_bound — BIGINT — NOT NULL

liked_members

  • mentoring_story_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL

member

  • member_id — BIGINT — NOT NULL
  • track_id — BIGINT — NOT NULL
  • class_id — BIGINT — FK
  • login_id — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • cardinal_number — INT — NOT NULL
  • student_number — INT
  • area_id — BIGINT — NOT NULL
  • address — VARCHAR(100)
  • phone_number — VARCHAR(100) — NOT NULL
  • emergency_phone_number — VARCHAR(100) — NOT NULL
  • profile_image — VARCHAR(100)
  • role — ENUM('user', 'admin', 'pro', 'teacher', 'mentor') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_ssatal — TINYINT — NOT NULL

member_evaluation_answer

  • member_id — BIGINT — Primary key — NOT NULL
  • evaluation_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Primary key — NOT NULL
  • objective_choice — INT
  • subjective_answer — TEXT

member_experience_log

  • log_id — BIGINT — NOT NULL
  • item_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • received_date — DATETIME — NOT NULL
  • value — INT — NOT NULL

mentoring

  • mentoring_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • mentoring_category_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • contents — VARCHAR(1000) — NOT NULL
  • views — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

mentoring_best

  • best_id — BIGINT — NOT NULL
  • mentoring_id — BIGINT — NOT NULL
  • add_title — VARCHAR(1000)

mentoring_category

  • mentoring_category_id — BIGINT — NOT NULL
  • mentoring_category_name — VARCHAR(20) — NOT NULL

mentoring_meeting_reply

  • reply_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • contents — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_anonymous — TINYINT — NOT NULL
  • parent_reply_id — BIGINT

mentoring_notice

  • mentoring_notice_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • mentoring_notice_category_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • contents — VARCHAR(1000) — NOT NULL
  • views — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

mentoring_notice_category

  • mentoring_notice_category_id — BIGINT — NOT NULL
  • mentoring_notice_category_name — VARCHAR(100) — NOT NULL

mentoring_notice_reply

  • reply_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • mentoring_notice_id — BIGINT — NOT NULL
  • contents — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_anonymous — TINYINT — NOT NULL
  • parent_reply_id — BIGINT

mentoring_reply

  • mentoring_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL
  • contents — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_anonymous — TINYINT — NOT NULL
  • parent_reply_id — BIGINT

mentoring_story

  • mentoring_story_id — BIGINT — NOT NULL
  • mentoring_story_category_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • contents — VARCHAR(1000) — NOT NULL
  • views — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

mentoring_story_best

  • mentoring_story_id — BIGINT — Primary key — NOT NULL
  • add_title — VARCHAR(1000)

mentoring_story_category

  • mentoring_story_category_id — BIGINT — NOT NULL
  • mentoring_story_category_name — VARCHAR(100) — NOT NULL

mentoring_story_reply

  • reply_id — BIGINT — Primary key — NOT NULL
  • mentoring_story_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • contents — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_anonymous — TINYINT — NOT NULL
  • parent_reply_id — BIGINT

mileage_balance

  • member_id — BIGINT — NOT NULL
  • total_earned — INT — NOT NULL
  • total_used — INT — NOT NULL
  • current_balance — INT — NOT NULL

mileage_category

  • category_id — TINYINT — NOT NULL
  • category_text — VARCHAR(100) — NOT NULL — 학업성취우수

mileage_item

  • item_id — BIGINT — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL — 1등, 2등
  • item_point — INT — NOT NULL
  • category_id — TINYINT — NOT NULL

mileage_log

  • log_id — BIGINT — NOT NULL
  • mileage_date — TIMESTAMP — NOT NULL
  • item_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL

mileage_transfer

  • mileage_transfer_id — BIGINT — NOT NULL
  • value — INT
  • transfer_date — DATETIME
  • member_id — BIGINT — NOT NULL

notice

  • notice_id — BIGINT — NOT NULL
  • notice_type_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • sticky — TINYINT — NOT NULL
  • cardinal_number — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

notice_addon_file

  • file_id — BIGINT — Primary key — NOT NULL
  • notice_id — BIGINT — Primary key — NOT NULL
  • file_uri — VARCHAR(150) — NOT NULL
  • file_order — BIGINT — NOT NULL

notification

  • notification_id — BIGINT — NOT NULL
  • notification_type_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL

notification_inbox

  • receiver_member_id — BIGINT — Primary key — NOT NULL
  • notification_id — BIGINT — Primary key — NOT NULL
  • is_read — BOOLEAN — NOT NULL

notification_outbox

  • sender_id — BIGINT — Primary key — NOT NULL
  • notification_id — BIGINT — Primary key — NOT NULL

objective_problem

  • question_id — BIGINT — NOT NULL
  • content — VARCHAR(1000)
  • is_correct — BOOLEAN — NOT NULL

post_file

  • post_file_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • file_address — VARCHAR(150) — NOT NULL

post_like

  • post_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL

problem

  • question_id — BIGINT — NOT NULL
  • evaluation_id — BIGINT — NOT NULL
  • content — VARCHAR(1000)
  • type — ENUM('subjective','objective') — NOT NULL

qna

  • question_id — BIGINT — Primary key — NOT NULL
  • questioner_id — BIGINT — Primary key — NOT NULL
  • qna_type_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • addon — VARCHAR(150)
  • is_answered — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

qna_answer

  • question_id — BIGINT — Primary key — NOT NULL
  • questionee_id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL

quest

  • quest_id — BIGINT — NOT NULL
  • test_id — BIGINT — NOT NULL
  • quest_content — VARCHAR(1000)

quest_answer_attached_files

  • file_id — BIGINT — NOT NULL
  • file_url — VARCHAR(150) — NOT NULL

quest_attachment_file

  • file_id — BIGINT — NOT NULL
  • quest_id — BIGINT — NOT NULL
  • file_url — VARCHAR(150) — NOT NULL

quest_member_answer

  • member_id — BIGINT — Primary key — NOT NULL
  • quest_id — BIGINT — Primary key — NOT NULL
  • file_id — BIGINT — NOT NULL
  • quest_content — VARCHAR(1000)
  • is_submitted — BOOLEAN — NOT NULL

replay_history

  • replay_history_id — BIGINT — Primary key — NOT NULL
  • lecture_replay_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL

scholar_rule

  • rule_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • uri — varchar(100) — NOT NULL

survey_multiple_choice

  • choice_order — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Primary key — NOT NULL
  • choice_content — VARCHAR(1000) — NOT NULL

survey_question

  • question_id — BIGINT — NOT NULL
  • survey_id — BIGINT — NOT NULL
  • question_content — VARCHAR(1000) — NOT NULL
  • question_order — INT — NOT NULL
  • question_type — VARCHAR(20) — NOT NULL
  • is_subjective — BOOLEAN — NOT NULL

survey_response

  • question_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL
  • question_order — INT — NOT NULL
  • choice — TINYINT
  • opinion — TEXT

survey_status

  • member_id — BIGINT — Primary key — NOT NULL
  • survey_id — BIGINT — Primary key — NOT NULL
  • servey_status — ENUM('진행중', '예정', '종료') — NOT NULL

test_result

  • test_result_id — BIGINT — NOT NULL
  • test_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • test_score — INT — NOT NULL
  • test_comment — VARCHAR(1000)

track

  • track_id — BIGINT — NOT NULL
  • name — VARCHAR(20) — NOT NULL