hanuri-old

Tables (50)

ai_proxy_logs

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id
  • action — varchar(120) — NOT NULL
  • provider — varchar(50) — NOT NULL
  • model — varchar(120) — NOT NULL
  • model_action — varchar(80) — NOT NULL
  • requested_at — datetime(6) — NOT NULL
  • responded_at — datetime(6) — NOT NULL
  • status_code — int — NOT NULL
  • success — tinyint(1) — NOT NULL
  • input_tokens — int — NOT NULL
  • output_tokens — int — NOT NULL
  • total_tokens — int — NOT NULL
  • usd_krw_rate — decimal(18,6) — NOT NULL
  • input_price_krw — decimal(18,6) — NOT NULL
  • output_price_krw — decimal(18,6) — NOT NULL
  • total_price_krw — decimal(18,6) — NOT NULL
  • credit_charged — decimal(12,4) — NOT NULL
  • credit_charged_user_id — bigint
  • credit_balance_after — decimal(12,4)
  • error_message — varchar(1000)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

ai_proxy_payloads

  • id — bigint — Primary key — NOT NULL
  • ai_proxy_log_id — bigint — Foreign key → ai_proxy_logs.id — NOT NULL
  • request_body — longtext
  • response_body — longtext
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

ai_token_credit_rates

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • provider — varchar(50) — NOT NULL
  • model — varchar(100) — NOT NULL
  • feature_type — varchar(50) — NOT NULL
  • category — varchar(50) — NOT NULL
  • label — varchar(100) — NOT NULL
  • credit_per_1k_tokens — decimal(12,4) — NOT NULL
  • visible — tinyint(1) — NOT NULL
  • updated_at — datetime — NOT NULL

app_code_items

  • id — bigint — Primary key — NOT NULL
  • code_group — varchar(80) — NOT NULL — Code category/group, e.g. SCHOOL_GRADE, REPORT_PILLAR
  • code — varchar(80) — NOT NULL — Stable code value used by API/frontend
  • label — varchar(200) — NOT NULL — Display label
  • parent_code — varchar(80) — Parent code inside the same or related group
  • sort_order — int — NOT NULL
  • description — text
  • metadata — json — Extra attributes such as colors, related pillars, guide text
  • active — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

class_groups

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • year — int — NOT NULL
  • name — varchar(100) — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

credit_deduction_rules

  • id — bigint — Primary key — NOT NULL
  • feature_key — varchar(64) — NOT NULL
  • group_name — varchar(64) — NOT NULL
  • label — varchar(128) — NOT NULL
  • fixed_deduct — decimal(12, 4) — NOT NULL
  • unit_type — varchar(16) — NOT NULL — PER_ACTION | PER_PAGE
  • sort_order — int — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

credit_histories

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • type — varchar(20) — NOT NULL
  • amount — decimal(12,4) — NOT NULL
  • reason — varchar(255) — NOT NULL
  • provider — varchar(50)
  • model — varchar(100)
  • prompt_tokens — int — NOT NULL
  • completion_tokens — int — NOT NULL
  • total_tokens — int — NOT NULL
  • credit_per_1k_tokens — decimal(12,4)
  • balance_after — decimal(12,4) — NOT NULL
  • target_month — char(7) — NOT NULL
  • grant_tier_label — varchar(64)
  • grant_student_min — int
  • grant_student_max — int
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

credit_settlement_logs

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint
  • feature_key — varchar(64) — NOT NULL
  • target_month — varchar(7) — NOT NULL
  • usage_units — int — NOT NULL
  • fixed_deduct_amount — decimal(12,4) — NOT NULL
  • fixed_deduct_total — decimal(12,4) — NOT NULL
  • actual_cost_krw — decimal(12,4) — NOT NULL
  • ai_proxy_log_id — bigint
  • note — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

credit_system_settings

  • id — bigint — Primary key — NOT NULL
  • setting_key — varchar(64) — NOT NULL
  • setting_value — decimal(18,4) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

credit_tier_grants

  • id — bigint — Primary key — NOT NULL
  • tier_code — varchar(32) — NOT NULL
  • tier_label — varchar(64) — NOT NULL
  • student_min — int
  • student_max — int
  • monthly_points — decimal(12,4) — NOT NULL
  • is_branch_head — tinyint(1) — NOT NULL
  • sort_order — int — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

gamma_theme

  • id — bigint — Primary key — NOT NULL
  • gamma_theme_id — varchar(64) — NOT NULL — Gamma API themeId
  • display_name — varchar(128) — NOT NULL — 사용자 선택 UI 표시명
  • sort_order — int — NOT NULL
  • visible — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

generation_histories

  • id — bigint — Primary key — NOT NULL
  • ai_proxy_log_id — bigint — Foreign key → ai_proxy_logs.id
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • feature_type — varchar(50) — NOT NULL
  • credit_used — decimal(12,4) — NOT NULL
  • provider — varchar(50)
  • model — varchar(100)
  • prompt_tokens — int — NOT NULL
  • completion_tokens — int — NOT NULL
  • total_tokens — int — NOT NULL
  • credit_per_1k_tokens — decimal(12,4)
  • input_json — json
  • result_json — json
  • status — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

generation_job

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • branch_name — varchar(128) — users.branch_name 스냅샷
  • job_type — varchar(50) — NOT NULL — LESSON_MATERIAL_PPT 등
  • status — varchar(20) — NOT NULL — PENDING | RUNNING | COMPLETED | FAILED | FAILED_TIMEOUT
  • idempotency_key — varchar(128) — NOT NULL
  • reserved_credit — decimal(14, 4) — NOT NULL
  • used_credit — decimal(14, 4)
  • feature_key — varchar(32)
  • units — int — NOT NULL
  • target_entity_type — varchar(64)
  • target_entity_id — bigint
  • request_data — json — NOT NULL
  • result_data — json
  • result_url — varchar(1000)
  • error_message — text
  • attempt_count — int — NOT NULL
  • max_attempts — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • started_at — datetime(6)
  • completed_at — datetime(6)
  • updated_at — datetime(6) — NOT NULL

hanuri_ai_templates

  • id — bigint — Primary key — NOT NULL
  • title — varchar(200) — NOT NULL
  • description — varchar(500)
  • image_url — varchar(1000)
  • html_source — mediumtext — NOT NULL
  • fields_json — json — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_books

  • id — bigint — Primary key — NOT NULL
  • title — varchar(500) — NOT NULL
  • author — varchar(500) — NOT NULL
  • publisher — varchar(255) — NOT NULL
  • isbn13 — varchar(20)
  • url — varchar(1000)
  • category — varchar(500)
  • introduce — mediumtext
  • pub_cmt — mediumtext
  • ai_category — varchar(100)
  • ai_keywords — json — NOT NULL
  • cover_url — varchar(1000)
  • registered_by_user_id — bigint
  • literature — tinyint
  • identity_hash — char(64)
  • created_at — timestamp — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_curated_books

  • id — bigint — Primary key — NOT NULL
  • textbook_id — bigint — Foreign key → hanuri_report_textbooks.id — NOT NULL
  • month — tinyint — NOT NULL
  • book_id — bigint — Foreign key → hanuri_report_books.id — NOT NULL
  • slot — tinyint — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_cycles

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — NOT NULL
  • textbook_track — varchar(16) — NOT NULL
  • cycle_no — int — NOT NULL
  • status — varchar(16) — NOT NULL
  • started_at — datetime(6) — NOT NULL
  • archived_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

hanuri_report_h_reports

  • id — bigint — Primary key — NOT NULL
  • report_link_id — bigint — Foreign key → hanuri_report_report.id
  • student_id — bigint — Foreign key → hanuri_report_students.id — NOT NULL
  • half_year_code — char(7) — NOT NULL
  • textbook_track — varchar(16) — NOT NULL
  • cycle_id — bigint
  • score_reading — int — NOT NULL
  • score_reading_max — int — NOT NULL — 읽기 역량 가능 최댓값
  • score_thinking — int — NOT NULL
  • score_thinking_max — int — NOT NULL — 사고 역량 가능 최댓값
  • score_discussion — int — NOT NULL
  • score_discussion_max — int — NOT NULL — 토론 역량 가능 최댓값
  • score_writing — int — NOT NULL
  • score_writing_max — int — NOT NULL — 글쓰기 역량 가능 최댓값
  • score_growth — int — NOT NULL
  • score_growth_max — int — NOT NULL — 성장 역량 가능 최댓값
  • score_overview — text
  • score_reading_desc — text
  • score_thinking_desc — text
  • score_discussion_desc — text
  • score_writing_desc — text
  • score_growth_desc — text
  • gauge_high_pillar — varchar(50)
  • gauge_low_pillar — varchar(50)
  • gauge_high_desc — text
  • gauge_low_desc — text
  • reading_type_name — varchar(100)
  • type_logic_code — varchar(50)
  • type_description — text
  • percentile_rank — int
  • teacher_comment — text
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_half_reading_types

  • id — bigint — Primary key — NOT NULL
  • logic_code — varchar(8) — NOT NULL
  • pillar_a — varchar(32) — NOT NULL
  • pillar_b — varchar(32) — NOT NULL
  • type_name — varchar(100) — NOT NULL
  • description — text — NOT NULL
  • sort_order — int — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_m_reports

  • id — bigint — Primary key — NOT NULL
  • report_link_id — bigint — Foreign key → hanuri_report_report.id
  • student_id — bigint — Foreign key → hanuri_report_students.id — NOT NULL
  • textbook_id — bigint
  • textbook_name — varchar(128)
  • textbook_track — varchar(16) — NOT NULL
  • cycle_id — bigint
  • round_no — int
  • target_month — date — NOT NULL
  • score_reading — int — NOT NULL
  • score_thinking — int — NOT NULL
  • score_discussion — int — NOT NULL
  • score_writing — int — NOT NULL
  • score_growth — int — NOT NULL
  • growth_moment — text
  • growth_meta — json — NOT NULL
  • writing_img_url1 — varchar(1000)
  • writing_img_url2 — varchar(1000)
  • book_id1 — bigint — Foreign key → hanuri_report_books.id
  • book_id2 — bigint — Foreign key → hanuri_report_books.id
  • strength_point — varchar(100)
  • weakness_point — varchar(100)
  • strength_cmt — text
  • weakness_cmt — text
  • book_keywords — json — NOT NULL
  • teacher_comment — text
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_q_reports

  • id — bigint — Primary key — NOT NULL
  • report_link_id — bigint — Foreign key → hanuri_report_report.id
  • student_id — bigint — Foreign key → hanuri_report_students.id — NOT NULL
  • quarter_end_ym — char(7) — NOT NULL
  • textbook_track — varchar(16) — NOT NULL
  • cycle_id — bigint
  • best_writing_url — varchar(1000)
  • mindmap_book — json
  • mindmap_cmt — text
  • mindmap_data — json — NOT NULL
  • growth_keywords — json — NOT NULL
  • growth_cmt — text
  • insight_tags — json — NOT NULL
  • insight_desc — text
  • teacher_comment — text
  • best_writing_cmt — text
  • teacher_ai_comment — text
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_report

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint — Foreign key → hanuri_report_students.id — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_students

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • student_nick — varchar(100) — NOT NULL
  • nick_suffix — varchar(3) — 동명이인 구분 (A, B, …, Z, AA, …, ZZZ)
  • student_grade — varchar(50) — NOT NULL
  • enrollment_ym — char(7) — NOT NULL
  • total_reports_written — int — NOT NULL
  • active — tinyint(1) — NOT NULL
  • withdrawn_at — datetime
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

hanuri_report_textbook_aliases

  • id — bigint — Primary key — NOT NULL
  • textbook_id — bigint — Foreign key → hanuri_report_textbooks.id — NOT NULL
  • alias — varchar(128) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_textbook_tiers

  • id — bigint — Primary key — NOT NULL
  • textbook_id — bigint — Foreign key → hanuri_report_textbooks.id — NOT NULL
  • tier — varchar(16) — NOT NULL
  • sort_order — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_textbooks

  • id — bigint — Primary key — NOT NULL
  • year — int — NOT NULL
  • name — varchar(128) — NOT NULL
  • grade_label — varchar(64) — NOT NULL
  • assignment_track — varchar(16) — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

hanuri_report_y_reports

  • id — bigint — Primary key — NOT NULL
  • report_link_id — bigint — Foreign key → hanuri_report_report.id
  • student_id — bigint — Foreign key → hanuri_report_students.id — NOT NULL
  • target_year — int — NOT NULL
  • textbook_track — varchar(16) — NOT NULL
  • cycle_id — bigint
  • score_reading — int — NOT NULL
  • score_thinking — int — NOT NULL
  • score_discussion — int — NOT NULL
  • score_writing — int — NOT NULL
  • score_growth — int — NOT NULL
  • annual_timeline — json — NOT NULL
  • outlook_comment — text
  • total_books — int — NOT NULL
  • lit_ratio — int — NOT NULL
  • non_lit_ratio — int — NOT NULL
  • book_lit_count — int — NOT NULL
  • book_non_lit_count — int — NOT NULL
  • roadmap_text — text
  • teacher_comment — text
  • cert_text — text
  • cert_grade_label — varchar(100)
  • is_certified — tinyint(1) — NOT NULL
  • cert_number — varchar(100)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

lesson_material_set

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL — 생성 사용자
  • sido_id — bigint — Foreign key → sido.id — NOT NULL — 시·도 ID
  • sigungu_id — bigint — Foreign key → sigungu.id — 시·군·구 ID (없을 수 있음)
  • title — varchar(200) — NOT NULL — 표시 제목
  • content_markdown — mediumtext — 전체 Markdown
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • ppt_s3_key — varchar(512) — S3 object key for generated PPTX
  • ppt_file_name — varchar(255) — Download file name
  • ppt_status — varchar(32) — NOT NULL — NONE|PENDING|COMPLETED|FAILED
  • ppt_gamma_theme_id — varchar(64) — PPT 생성에 사용한 Gamma themeId

lesson_material_set_page

  • id — bigint — Primary key — NOT NULL
  • set_id — bigint — Foreign key → lesson_material_set.id — NOT NULL — 자료집 ID
  • page_no — int — NOT NULL — 페이지 순서(1부터)
  • title — varchar(200) — NOT NULL — 페이지 제목
  • content_markdown — text — NOT NULL — 페이지 Markdown (약 500자 이내 권장)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

lesson_material_set_school

  • id — bigint — Primary key — NOT NULL
  • set_id — bigint — Foreign key → lesson_material_set.id — NOT NULL — 자료집 ID
  • school_id — bigint — Foreign key → school.id — NOT NULL — 학교 ID
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

lesson_material_set_target_grade

  • id — bigint — Primary key — NOT NULL
  • set_id — bigint — Foreign key → lesson_material_set.id — NOT NULL — 자료집 ID
  • grade_code — varchar(20) — NOT NULL — E1..E6, M1..M3, H1..H3
  • school_level — varchar(20) — NOT NULL — ELEMENTARY, MIDDLE, HIGH
  • grade_label — varchar(30) — NOT NULL — 초2, 중1 등
  • grade_number — tinyint — NOT NULL — 학년 숫자
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

monthly_active_user

  • stat_month — varchar(7) — Primary key — NOT NULL — YYYY-MM
  • user_id — bigint — Primary key — NOT NULL
  • branch_name — varchar(128) — NOT NULL
  • first_active_at — datetime(6) — NOT NULL
  • last_active_at — datetime(6) — NOT NULL

monthly_branch_stats

  • stat_month — varchar(7) — Primary key — NOT NULL — YYYY-MM
  • branch_name — varchar(128) — Primary key — NOT NULL
  • active_user_count — int — NOT NULL
  • generation_count — int — NOT NULL
  • used_credit — decimal(14, 4) — NOT NULL
  • allocated_credit — decimal(14, 4) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

monthly_feature_stats

  • stat_month — varchar(7) — Primary key — NOT NULL — YYYY-MM
  • feature_group — varchar(32) — Primary key — NOT NULL — feedback | promo | materials | other
  • generation_count — int — NOT NULL
  • used_credit — decimal(14, 4) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

promo_content_checklist_items

  • id — bigint — Primary key — NOT NULL
  • template_id — bigint — Foreign key → promo_content_templates.id — NOT NULL
  • item_text — varchar(512) — NOT NULL
  • sort_order — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

promo_content_kinds

  • id — bigint — Primary key — NOT NULL
  • name — varchar(128) — NOT NULL
  • feature_key — varchar(64) — NOT NULL
  • sort_order — int — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

promo_content_parameters

  • id — bigint — Primary key — NOT NULL
  • template_id — bigint — Foreign key → promo_content_templates.id — NOT NULL
  • param_key — varchar(64) — NOT NULL
  • label — varchar(128) — NOT NULL
  • sort_order — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

promo_content_templates

  • id — bigint — Primary key — NOT NULL
  • kind_id — bigint — Foreign key → promo_content_kinds.id — NOT NULL
  • name — varchar(128) — NOT NULL
  • prompt_template — longtext — NOT NULL
  • target_char_count — int — NOT NULL
  • sort_order — int — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

promotion_content_prompts

  • id — bigint — Primary key — NOT NULL
  • usage_type — varchar(50) — NOT NULL
  • title — varchar(100) — NOT NULL
  • description — text
  • prompt — text — NOT NULL
  • checklist_json — json
  • dropdown_json — json
  • visible — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

saved_items

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • type — varchar(20) — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — longtext
  • file_url — text
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

school

  • id — bigint — Primary key — NOT NULL
  • sido_id — bigint — Foreign key → sido.id — NOT NULL — 시·도 ID
  • sigungu_id — bigint — 시·군·구 ID
  • sigungu_id_key — bigint — 유니크키용 (NULL→0)
  • name — varchar(200) — NOT NULL — 학교명
  • school_type — varchar(20) — 초등학교/중학교/고등학교
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

school_evaluation_plan_file_grade_summary

  • id — bigint — Primary key — NOT NULL
  • file_id — bigint — Foreign key → school_evaluation_plan_files.id — NOT NULL — school_evaluation_plan_files.id
  • school_id — bigint — Foreign key → school.id — school.id
  • grade — tinyint — NOT NULL — 학년 (초 1~6, 중·고 1~3)
  • summary — text — 1차 요약 (사람이 읽는 문장)
  • focus_keywords — json — 주요 키워드
  • feature_vector — json — 2차 정규화 feature vector (0~10)
  • model_name — varchar(80)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

school_evaluation_plan_file_target_grades

  • id — bigint — Primary key — NOT NULL
  • file_id — bigint — Foreign key → school_evaluation_plan_files.id — NOT NULL
  • grade_code — varchar(20) — NOT NULL — E_ALL, E1..E6, M_ALL, M1..M3, H_ALL, H1..H3
  • school_level — varchar(20) — NOT NULL — ELEMENTARY, MIDDLE, HIGH
  • grade_label — varchar(30) — NOT NULL — 초1, 초등 전체 등
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

school_evaluation_plan_files

  • id — bigint — Primary key — NOT NULL
  • source — varchar(100) — NOT NULL — 자료출처
  • school_type — varchar(20) — NOT NULL — 초/중/고등학교
  • sido — varchar(50) — 시/도
  • sigungu — varchar(50) — 시/군/구
  • sido_id — bigint — Foreign key → sido.id — 시/도 ID
  • sigungu_id — bigint — Foreign key → sigungu.id — 시/군/구 ID
  • school_id — bigint — Foreign key → school.id — 학교 ID
  • school_name — varchar(200) — 학교명
  • submission_ym — char(6) — NOT NULL — 제출연월(yyyyMM)
  • file_name — varchar(500) — NOT NULL — 원본 파일명
  • original_file_url — varchar(1000) — 원본 파일 URL
  • s3_url — varchar(1000) — NOT NULL — S3 업로드 URL
  • file_extension — varchar(20) — 파일 확장자
  • file_size — bigint — 파일 크기(byte)
  • content_hash — varchar(128) — NOT NULL — 파일 해시
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

sido

  • id — bigint — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL — 시·도명
  • display_order — int — NOT NULL — 표시 순서
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

sigungu

  • id — bigint — Primary key — NOT NULL
  • sido_id — bigint — Foreign key → sido.id — NOT NULL — 시·도 ID
  • name — varchar(100) — NOT NULL — 시·군·구명
  • display_order — int — NOT NULL — 표시 순서
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

teacher_lesson_session_students

  • id — bigint — Primary key — NOT NULL
  • session_id — bigint — Foreign key → teacher_lesson_sessions.id — NOT NULL
  • report_student_id — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

teacher_lesson_sessions

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • year — int — NOT NULL
  • day_of_week — tinyint — NOT NULL — 1=Mon .. 7=Sun
  • start_hour — tinyint — NOT NULL — 9..21
  • duration_hours — tinyint — NOT NULL
  • textbook_id — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

teacher_students

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • textbook_id — bigint — Foreign key → hanuri_report_textbooks.id
  • assignment_track — varchar(16) — NOT NULL
  • class_group_id — bigint — Foreign key → class_groups.id
  • year — int — NOT NULL
  • class_name — varchar(100) — NOT NULL
  • name — varchar(20) — NOT NULL
  • display_name — varchar(20) — NOT NULL
  • duplicate_suffix — varchar(4)
  • report_student_id — bigint — Foreign key → hanuri_report_students.id
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

users

  • id — bigint — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255)
  • name — varchar(100) — NOT NULL
  • active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • role — varchar(20) — NOT NULL
  • branch_name — varchar(100)
  • teacher_no — varchar(50)
  • student_count — int — NOT NULL
  • billing_student_count — int — NOT NULL — 정산/지급용 학생 수(외부 API)
  • monthly_credit — decimal(12, 4) — NOT NULL
  • remaining_credit — decimal(12, 4) — NOT NULL
  • monthly_grant_credit — decimal(12, 4) — NOT NULL — 매월 1일 자동 지급 크레딧(관리자 설정)
  • last_credit_grant_month — varchar(7) — 마지막 월간 기본 지급 월(YYYY-MM)