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)