Blaybus
Tables (14)
Users
- user_id — BIGINT — Primary key — NOT NULL — PK
- username — VARCHAR(30) — NOT NULL — UNIQUE, 로그인 ID
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(30) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- role — VARCHAR(20) — NOT NULL — MENTOR, MENTEE, WITH_DRAW
- profile_img_url — TEXT
- fcm_token — VARCHAR(255)
- is_alarm_enabled — BOOL — NOT NULL — DEFAULT TRUE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
answer
- id — BIGINT — Primary key — NOT NULL
- comment — VARCHAR(500) — NOT NULL
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL — FK → Users
- feedback_id — BIGINT — Foreign key → task_feedbacks.id — NOT NULL — FK → task_feedbacks
daily_planners
- id — BIGINT — Primary key — NOT NULL
- plan_date — DATE — NOT NULL
- total_study_time — INT — NOT NULL — DEFAULT 0
- daily_memo — TEXT
- mentor_feedback — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- mentee_id — BIGINT — Foreign key → Users.user_id — NOT NULL — FK → Users, UNIQUE(mentee_id, plan_date)
mentee_info
- id — BIGINT — Primary key — NOT NULL
- school_name — VARCHAR(30) — NOT NULL
- korean_grade — INT
- math_grade — INT
- english_grade — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- mentor_id — BIGINT — Foreign key → Users.user_id — NOT NULL — FK → Users
- mentee_id — BIGINT — Foreign key → Users.user_id — NOT NULL — FK → Users, UNIQUE
notifications
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(30) — NOT NULL
- message — VARCHAR(300) — NOT NULL
- is_read — BOOLEAN — NOT NULL — DEFAULT FALSE
- created_at — DATETIME — NOT NULL
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL — FK → Users
study_contents
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- subject — VARCHAR(20) — NOT NULL — KOREAN, ENGLISH, MATH, OTHER
- content_url — TEXT
- created_at — DATETIME — NOT NULL
- mentor_id — BIGINT — Foreign key → Users.user_id — FK → Users
submission_images
- id — BIGINT — Primary key — NOT NULL
- image_url — TEXT
- submission_id — BIGINT — Foreign key → task_submissions.id — FK → task_submissions
task_feedbacks
- id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(300) — NOT NULL
- image_url — TEXT
- created_at — DATETIME — NOT NULL
- x_pos — FLOAT — NOT NULL
- y_pos — FLOAT — NOT NULL
- task_id — BIGINT — Foreign key → tasks.id — NOT NULL — FK → tasks
- mentor_id — BIGINT — Foreign key → Users.user_id — NOT NULL — FK → Users
- image_id — BIGINT — Foreign key → submission_images.id — NOT NULL — FK → submission_images
task_logs
- id — BIGINT — Primary key — NOT NULL
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- duration — INT — NOT NULL — 분 단위
- task_id — BIGINT — Foreign key → tasks.id — NOT NULL — FK → tasks
task_submissions
- id — BIGINT — Primary key — NOT NULL
- mentee_comment — VARCHAR(300)
- created_at — DATETIME — NOT NULL
- task_id — BIGINT — Foreign key → tasks.id — NOT NULL — FK → tasks
tasks
- id — BIGINT — Primary key — NOT NULL
- subject — VARCHAR(20) — NOT NULL — KOREAN, ENGLISH, MATH, OTHER
- title — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL — TODO, IN_PROGRESS, DONE / DEFAULT TODO
- actual_study_time — INT — NOT NULL — DEFAULT 0, 분 단위 누적
- task_date — DATE — NOT NULL
- is_mentor_checked — BOOL — NOT NULL — DEFAULT FALSE
- is_mandatory — BOOL — NOT NULL — DEFAULT FALSE, 멘토 출제 과제=true
- recurring_group_id — VARCHAR(36) — UUID, 반복 과제 그룹
- timer_status — VARCHAR(20) — NOT NULL — STOPPED, RUNNING / DEFAULT STOPPED
- timer_started_at — DATETIME
- weakness_id — BIGINT — Foreign key → weakness.id — FK → weakness
- daily_planner_id — BIGINT — Foreign key → daily_planners.id — NOT NULL — FK → daily_planners
- mentee_id — BIGINT — Foreign key → Users.user_id — NOT NULL — FK → Users
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
weakness
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- info_id — BIGINT — Foreign key → mentee_info.id — NOT NULL — FK → mentee_info
- content_id — BIGINT — Foreign key → study_contents.id — NOT NULL — FK → study_contents
weekly_reports
- id — BIGINT — Primary key — NOT NULL
- week_name — VARCHAR(50) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- overall_feedback — VARCHAR(300)
- strengths — VARCHAR(50)
- weaknesses — VARCHAR(50)
- info_id — BIGINT — Foreign key → mentee_info.id — NOT NULL — FK → mentee_info
zoom_feedbacks
- id — BIGINT — Primary key — NOT NULL
- meeting_date — DATETIME — NOT NULL
- summary — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- info_id — BIGINT — Foreign key → mentee_info.id — NOT NULL — FK → mentee_info