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