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