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