블레이버스

테이블 (7)

과제 (task)

  • task_id — BIGINT
  • mentee_id — BIGINT — 외래 키 → 사용자.user_id
  • mentor_id — BIGINT — 외래 키 → 사용자.user_id
  • subject_id — BIGINT — 외래 키 → 교과목.subject_id
  • task_date — DATE — NOT NULL
  • task_name — VARCHAR(100) — NOT NULL
  • task_goal — TEXT
  • task_type — ENUM('FIXED', 'ADDITIONAL') — NOT NULL
  • learning_material_type — ENUM('COLUMN', 'PDF')
  • pdf_file_url — VARCHAR(255)
  • column_content — TEXT
  • is_fixed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

과제_제출 (subject_submit)

  • completion_id — BIGINT
  • task_id — BIGINT — 외래 키 → 과제.task_id
  • study_time — INT
  • completion_photo_url — VARCHAR(255)
  • completed_at — TIMESTAMP
  • is_completed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

교과목 (subject)

  • subject_id — BIGINT
  • subject_name — VARCHAR(20) — NOT NULL
  • subject_code — VARCHAR(10) — NOT NULL

멘토_멘티 (mentor_mentee)

  • mentor_mentee_id — BIGINT
  • mentor_id — BIGINT — 외래 키 → 사용자.user_id
  • mentee_id — BIGINT — 외래 키 → 사용자.user_id
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

사용자 (user)

  • user_id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('MENTOR', 'MENTEE') — NOT NULL
  • created_at — TIMESTAMP

주간_학습_통계 (weekly_study_report)

  • statistics_id — BIGINT
  • mentee_id — BIGINT — 외래 키 → 사용자.user_id
  • mentor_review — TEXT
  • weekly_achievements — TEXT
  • next_week_feedback — TEXT
  • week_start_date — DATE — NOT NULL
  • week_end_date — DATE — NOT NULL
  • total_study_time — INT
  • completion_rate — DECIMAL(5,2)
  • task_count — INT
  • completed_task_count — INT
  • created_at — TIMESTAMP

피드백 (feedback)

  • feedback_id — BIGINT
  • task_id — BIGINT — 외래 키 → 과제.task_id
  • mentor_id — BIGINT — 외래 키 → 사용자.user_id
  • mentee_id — BIGINT — 외래 키 → 사용자.user_id
  • subject_id — BIGINT — 외래 키 → 교과목.subject_id
  • feedback_date — DATE — NOT NULL
  • detail_content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP