블레이버스
테이블 (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