classday_server_erd
Tables (50)
ai_solution_request
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- request_id — varchar(10) — NOT NULL
- sub_question_id — bigint — NOT NULL
- state — varchar(10) — NOT NULL
- request_time — datetime — NOT NULL
- complete_time — datetime
- question_group_id — bigint — NOT NULL
alimtalk_event
- id — bigint — Primary key — NOT NULL
- alimtalk_history_id — bigint — NOT NULL
- target_user_id — bigint
- content — varchar(2000) — NOT NULL
- template_code — varchar(15) — NOT NULL
- receive_phone — varchar(20) — NOT NULL
- classday_request_id — varchar(30) — NOT NULL
- mn_wise_request_id — varchar(100) — NOT NULL
- is_success — tinyint — NOT NULL
- mn_wise_fail_code — varchar(10)
- alimtalk_fail_code — varchar(10)
alimtalk_history
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- content — varchar(1000) — NOT NULL
- template_code — varchar(15) — NOT NULL
- total_count — bigint — NOT NULL
- success_count — bigint — NOT NULL
- failure_count — bigint — NOT NULL
- year — int — NOT NULL
- month — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
alimtalk_registration
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- search_id — varchar(100) — NOT NULL
- approval_state — varchar(10) — NOT NULL
- registration_date — date
- is_blocked — tinyint(1) — NOT NULL
- block_reason — varchar(200)
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- profile_key — varchar(100)
assignment
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- title — varchar(50) — NOT NULL
- question_sheet_snapshot_id — bigint — NOT NULL
- boost_sheet_snapshot_id — bigint — NOT NULL
- due_date_time — datetime
- time_limit_minute — int
- is_closed — tinyint(1) — NOT NULL
- closed_time — datetime
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
assignment_submission
- id — bigint — Primary key — NOT NULL
- assignment_id — bigint — NOT NULL
- user_assignment_id — bigint — NOT NULL
- question_sheet_snapshot_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- user_group_id — bigint — NOT NULL
- correct_count — int — NOT NULL
- total_count — int — NOT NULL
- total_solving_time — int — NOT NULL
- state — varchar(20) — NOT NULL
- state_detail — varchar(20)
- phase — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
billing_key
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- tid — varchar(50) — NOT NULL
- billing_key — varchar(255) — NOT NULL
- card_company — varchar(50)
- card_number_masked — varchar(30)
- card_type — varchar(20)
- is_valid — tinyint(1) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
bookmark_question
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- question_group_id — bigint — NOT NULL
- first_depth_tag_id — bigint
- second_depth_tag_id — bigint
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- is_valid — tinyint(1) — NOT NULL
class_auto_care
- id — bigint — Primary key — NOT NULL
- edu_class_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- date — date — NOT NULL
- content — varchar(2000) — NOT NULL
class_video
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- title — varchar(100) — NOT NULL
- description — varchar(5000) — NOT NULL
- url — varchar(200) — NOT NULL
- thumbnail_url — varchar(200) — NOT NULL
- is_valid — tinyint — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
class_video_quota
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- used — int — NOT NULL
- quota — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
cloud_storage_payment_history
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- purchased_units — int — NOT NULL
- pay_for — varchar(50) — NOT NULL
- create_time — datetime — NOT NULL
common_care
- id — bigint — Primary key — NOT NULL
- teacher_user_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- chunk_id — bigint — NOT NULL
- title — varchar(100) — NOT NULL
- content — varchar(2000)
- file_urls — text — NOT NULL
- sent_time — datetime
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
common_care_chunk
- id — bigint — Primary key — NOT NULL
- teacher_user_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- title — varchar(100) — NOT NULL
- thumbnail_content — varchar(500) — NOT NULL
- sent_state — varchar(10) — NOT NULL
- reserve_time — datetime
- sent_time — datetime
- main_category — varchar(30)
- sub_category — varchar(30)
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
consultation
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- status — varchar(50) — NOT NULL
- consultation_details — text
- requested_at — timestamp
- scheduled_at — timestamp
- manager — varchar(20)
- is_valid — tinyint(1) — NOT NULL
- agent_notes — text
- create_time — timestamp
- update_time — timestamp
consultation_slot_policy
- id — bigint — Primary key — NOT NULL
- space_id — bigint
- policy_effect — varchar(20) — NOT NULL
- applies_date — date
- day_of_week — varchar(10)
- time_slot — time
- max_reservations — bigint
- priority — int — NOT NULL
- description — varchar(200)
- is_valid — tinyint(1) — NOT NULL
- create_time — timestamp
- update_time — timestamp
dbize_request
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- school_level — varchar(15) — NOT NULL
- subject — varchar(15) — NOT NULL
- dbize_source_type_tag_id — bigint — NOT NULL
- curriculum_revision_tag_id — bigint — NOT NULL
- academic_year — varchar(10) — NOT NULL
- publisher_tag_id — bigint
- main_unit_tag_id — bigint
- tag_ids — varchar(5000) — NOT NULL
- title — varchar(50) — NOT NULL
- description — varchar(500)
- pdf_urls — varchar(2000) — NOT NULL
- state — varchar(10) — NOT NULL
- dbized_sheet_id — bigint
- request_time — datetime — NOT NULL
- reject_reason — varchar(200)
drive_folder
- id — bigint — Primary key — NOT NULL
- parent_id — bigint
- drive_id — bigint — NOT NULL
- name — varchar(255) — NOT NULL
- is_root — tinyint(1) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
drive_question_sheet_mapping
- id — bigint — Primary key — NOT NULL
- drive_id — bigint — NOT NULL
- folder_id — bigint
- question_sheet_id — bigint — NOT NULL
- question_sheet_name — varchar(50) — NOT NULL
edu_class
- id — bigint — Primary key — NOT NULL
- title — varchar(50)
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- edu_space_id — bigint — NOT NULL
- description — varchar(200) — NOT NULL
- class_type — varchar(20) — NOT NULL
- is_default — tinyint — NOT NULL
- theme_id — bigint — NOT NULL
- is_valid — tinyint — NOT NULL
- fee — varchar(15) — NOT NULL
- payment_type — varchar(15) — NOT NULL
- session_count — smallint
edu_class_user
- id — bigint — Primary key — NOT NULL
- edu_class_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- last_read_message_id — bigint
- edu_space_id — bigint — NOT NULL
- is_consultation — tinyint — NOT NULL
- has_new_consultation_message — tinyint
- last_consultation_message_time — datetime
edu_class_user_group
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- user_group_id — bigint — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- left_session_count — smallint — NOT NULL
edu_space
- id — bigint — Primary key — NOT NULL
- title — varchar(50) — NOT NULL
- size_range — varchar(100)
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- description — varchar(200) — NOT NULL
- profile_origin_uri — varchar(200)
- theme_id — bigint — NOT NULL
- attendance_code — varchar(10) — NOT NULL
- cms_question_item_count — bigint — NOT NULL
- address — varchar(50)
- phone — varchar(20)
- is_payment_available — tinyint — NOT NULL
- invoice_sms_template — varchar(2000)
- invoice_alimtalk_template — varchar(2000)
- recommender_code — varchar(6)
- is_released_sheets_available — tinyint — NOT NULL
- leaders_apply_time — datetime
- free_trial_expired_at — datetime
edu_space_membership
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- membership_id — bigint — NOT NULL
- is_valid — tinyint(1) — NOT NULL
- expire_time — datetime
- billing_time — datetime
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- auto_renew — tinyint(1) — NOT NULL
- user_id — bigint
edu_space_notification_config
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- send_method_config — varchar(1000) — NOT NULL
- send_target_config — text — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
edu_space_notification_count
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- year — bigint — NOT NULL
- month — bigint — NOT NULL
- sms_success_count — int — NOT NULL
- sms_failure_count — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- alimtalk_success_count — int — NOT NULL
- alimtalk_failure_count — int — NOT NULL
edu_space_payment_config
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- business_number — varchar(15) — NOT NULL
- cat_id — varchar(15) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
edu_space_user
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- display_name — varchar(50) — NOT NULL
- user_role — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- profile_origin_uri — varchar(200) — NOT NULL
- description — varchar(50)
- inviter_user_id — bigint
- phone — varchar(30) — NOT NULL
- is_joined — tinyint — NOT NULL
- email — varchar(100)
- is_deactivated — tinyint — NOT NULL
- entry_date — date
- exit_date — date
- school — varchar(20)
- year — varchar(10)
- gender — varchar(10)
- address — varchar(50)
- fee — varchar(20)
- fee_paid — tinyint
- last_paid_date — date
- enroll_state — varchar(15) — NOT NULL
- birth — date
- regular_pay_date — tinyint
- name — varchar(50) — NOT NULL
emoji_reaction
- id — bigint — Primary key — NOT NULL
- message_id — bigint
- message_reply_id — bigint
- user_id — bigint — NOT NULL
- emoji — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
english_passage_unlock
- id — bigint — Primary key — NOT NULL
- client_request_id — varchar(50) — NOT NULL
- user_id — bigint — NOT NULL
- file_url — varchar(1000) — NOT NULL
- state — varchar(10) — NOT NULL
- curriculum_revision_tag_id — bigint — NOT NULL
- publisher_tag_id — bigint — NOT NULL
- main_category_tag_id — bigint
- academic_year — varchar(15) — NOT NULL
- unlocked_passage_ids — text — NOT NULL
- unlocked_question_count — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- unlocked_textbook_passage_ids — text — NOT NULL
- edu_space_id — bigint — NOT NULL
- detail_subject_tag_id — bigint
- year_tag_id — bigint — NOT NULL
- fail_reason — varchar(30)
event
- id — bigint — Primary key — NOT NULL
- schedule_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- edu_class_id — bigint
- user_id — bigint — NOT NULL
- start_time — datetime — NOT NULL
- end_time — datetime — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- title — varchar(30) — NOT NULL
- content — varchar(100) — NOT NULL
exam_sheet
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- title — varchar(30) — NOT NULL
- description — varchar(50) — NOT NULL
- category_id — bigint
- subject — varchar(20) — NOT NULL
- year — varchar(15) — NOT NULL
- source — varchar(10) — NOT NULL
- question_item_ids — varchar(2000) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
exam_sheet_category
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- name — varchar(30) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
feedback_sample
- id — int — Primary key — NOT NULL
- path — varchar(255) — NOT NULL — 피드백 문장의 카테고리 경로 (예: daily/lessonInfo/수업/수업_난이도/상)
- sentence — text — NOT NULL — 실제 피드백 문장 내용
- created_at — datetime — NOT NULL — 생성 시각
- updated_at — datetime — NOT NULL — 최종 업데이트 시각
file
- id — bigint — Primary key — NOT NULL
- message_id — bigint
- message_reply_id — bigint
- user_id — bigint — NOT NULL
- origin_uri — varchar(500) — NOT NULL
- extension — varchar(10) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
file_conversion_batches
- id — bigint — Primary key — NOT NULL
- batch_name — varchar(255)
- user_id — bigint — NOT NULL
- user_display_name — varchar(255)
- space_id — bigint — NOT NULL
- total_files — int
- description — text
- create_time — timestamp
- update_time — timestamp
file_question_sheet
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- type — varchar(10) — NOT NULL
- title — varchar(100) — NOT NULL
- description — varchar(200) — NOT NULL
- urls — text — NOT NULL
- subject — varchar(15) — NOT NULL
- academic_year — varchar(10) — NOT NULL
- school_level — varchar(15) — NOT NULL
- curriculum_revision_id — bigint
- publisher_tag_id — bigint
- school_id — bigint
- semester — tinyint
- exam_year — int
- exam_type — varchar(15)
- file_source_type — varchar(15)
- main_unit_tag_id — int
- tag_ids — varchar(5000) — NOT NULL
- preview_url — varchar(500) — NOT NULL
- report_count — int — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
file_question_sheet_report
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- file_question_sheet_id — bigint — NOT NULL
- reason — varchar(500) — NOT NULL
- create_time — datetime — NOT NULL
homework
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- title — varchar(50) — NOT NULL
- description — varchar(1000) — NOT NULL
- type — varchar(20) — NOT NULL
- due — datetime — NOT NULL
- submit_count — bigint — NOT NULL
- total_count — bigint — NOT NULL
- answer — text
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- is_finalized — tinyint — NOT NULL
- final_perfect_score — double
- final_average_correct_rate — double
- final_average_score — double
homework_submission
- id — bigint — Primary key — NOT NULL
- user_group_id — bigint — NOT NULL
- homework_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- edu_space_id — bigint — NOT NULL
- homework_type — varchar(30) — NOT NULL
- autograding_answer — text
- ai_feedback_answer — text
- state — varchar(30) — NOT NULL
- last_recognition_request_id — varchar(50)
- is_finalized — tinyint — NOT NULL
- final_score — double
- final_correct_rate — double
- final_correct_count — bigint
- final_solved_count — bigint
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
invitation
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- inviter_user_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- state — varchar(30) — NOT NULL
- last_invite_time — datetime — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- memo — mediumtext — NOT NULL
invoice
- id — bigint — Primary key — NOT NULL
- type — varchar(20) — NOT NULL
- edu_space_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- user_group_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- original_invoice_id — bigint
- year — bigint — NOT NULL
- month — bigint — NOT NULL
- publish_state — varchar(15) — NOT NULL
- publish_time — datetime
- payment_state — varchar(10)
- reserve_time — datetime
- send_method — varchar(30) — NOT NULL
- invoice_item — varchar(50) — NOT NULL
- amount — varchar(15) — NOT NULL
- is_discounted — tinyint — NOT NULL
- discount_value — varchar(15) — NOT NULL
- discount_type — varchar(15)
- discount_item — varchar(50)
- message — varchar(1000)
- fixed_sms_message — varchar(2000)
- fixed_alimtalk_message — varchar(2000)
- regular_payment_date — tinyint — NOT NULL
- payment_deadline_days — smallint — NOT NULL
- payment_session_count — smallint
- sent_count — tinyint — NOT NULL
- last_sent_time — datetime
- has_cancelled_payment_part — tinyint — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
link_payment_temp_store
- id — bigint — Primary key — NOT NULL
- invoice_id — bigint — NOT NULL
- tr_id — varchar(60) — NOT NULL
- price — varchar(15) — NOT NULL
- cat_id — varchar(15) — NOT NULL
- instm_month — varchar(50) — NOT NULL
- create_time — datetime — NOT NULL
membership
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- code — varchar(50) — NOT NULL
- fishing_price — int — NOT NULL
- price — int — NOT NULL
- is_selling — tinyint(1) — NOT NULL
- billing_cycle — varchar(50) — NOT NULL
- credit — int — NOT NULL
- first_purchase_bonus — int
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- user_id — bigint
- is_valid — tinyint(1) — NOT NULL
- cloud_pdf_bytes — bigint
- edu_space_size_lower_limit — int
membership_exposure
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- membership_id — bigint — NOT NULL
memo
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- subject_user_group_id — bigint — NOT NULL
- message_id — bigint
- message_reply_id — bigint
- title — varchar(100) — NOT NULL
- content — varchar(1000) — NOT NULL
- is_pinned — tinyint — NOT NULL
- is_valid — tinyint — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- type — varchar(10) — NOT NULL
message
- id — bigint — Primary key — NOT NULL
- edu_class_id — bigint — NOT NULL
- user_id — bigint
- content — varchar(2000) — NOT NULL
- reply_count — bigint — NOT NULL
- emoji_counts — varchar(500) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- message_type — varchar(10) — NOT NULL
- task_type — varchar(20) — NOT NULL
- is_valid — tinyint — NOT NULL
- task_id — bigint
message_reply
- id — bigint — Primary key — NOT NULL
- edu_class_id — bigint — NOT NULL
- message_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- content — varchar(2000) — NOT NULL
- emoji_counts — varchar(500) — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
- is_valid — tinyint — NOT NULL
message_reservation
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- edu_class_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- table_type — varchar(20) — NOT NULL
- announce — mediumtext
- homework — mediumtext
- exam — mediumtext
- send_to — varchar(20)
- target_type — varchar(20)
- reserve_time — datetime
- message_ids — varchar(1000)
- target_user_ids — varchar(1000)
- state — varchar(20) — NOT NULL
- sent_time — datetime
- memo — mediumtext — NOT NULL
- is_valid — tinyint — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL
message_template
- id — bigint — Primary key — NOT NULL
- edu_space_id — bigint — NOT NULL
- category — varchar(20) — NOT NULL
- name — varchar(50) — NOT NULL
- content — varchar(2000) — NOT NULL
- variables — varchar(500) — NOT NULL
- user_id — bigint — NOT NULL
- is_default — tinyint — NOT NULL
- create_time — datetime — NOT NULL
- update_time — datetime — NOT NULL