5월29일까지ERD
테이블 (16)
agent_chat_rooms
- agent_room_id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL — 채팅방
- room_name — VARCHAR(100) — NOT NULL — 에이전트
- created_at — TIMESTAMP — NOT NULL — 방
agents
- agent_id — BIGSERIAL
- agent_room_id — BIGINT — 외래 키 → agent_chat_rooms.agent_room_id — NOT NULL — 소속된
- name — VARCHAR(30) — NOT NULL — AI
- role — VARCHAR(50) — NOT NULL — AI
- persona — VARCHAR(1000) — NOT NULL — AI
- tone — VARCHAR(100) — AI
- goal — VARCHAR(200) — 에이전트가
- created_at — TIMESTAMP — NOT NULL — 설정
chat_messages
- message_id — BIGSERIAL
- agent_room_id — BIGINT — 외래 키 → agent_chat_rooms.agent_room_id — NOT NULL — 메시지가
- agent_id — BIGINT — 외래 키 → agents.agent_id — 답변한
- content — TEXT — NOT NULL — 채팅
- sender — VARCHAR(255) — NOT NULL — 메시지
- created_at — TIMESTAMP — NOT NULL — 메시지
material_feedbacks
- feedback_id — BIGSERIAL
- material_id — BIGINT — 외래 키 → materials.material_id — NOT NULL — 학습
- feedback_data — TEXT — AI
- created_at — TIMESTAMP — NOT NULL — 생성
material_memos
- memo_id — BIGSERIAL
- material_id — BIGINT — 외래 키 → materials.material_id — NOT NULL — 학습
- content — TEXT — 사용자
- created_at — TIMESTAMP — NOT NULL — 작성
- updated_at — TIMESTAMP — NOT NULL — 수정
material_questions
- question_id — BIGSERIAL
- material_id — BIGINT — 외래 키 → materials.material_id — NOT NULL — 학습
- user_question — VARCHAR(1000) — NOT NULL — 사용자
- ai_answer — TEXT — AI
- created_at — TIMESTAMP — NOT NULL — 생성
material_quizzes
- quiz_id — BIGSERIAL
- material_id — BIGINT — 외래 키 → materials.material_id — NOT NULL — 학습
- difficulty — VARCHAR(255) — 퀴즈
- question_count — INT — 생성된
- page_range — VARCHAR(255) — 문제
- quiz_data — TEXT — 퀴즈
- created_at — TIMESTAMP — NOT NULL — 생성
material_summaries
- summary_id — BIGSERIAL
- material_id — BIGINT — 외래 키 → materials.material_id — NOT NULL — 학습
- overview — TEXT — AI
- core_contents — TEXT — AI
- created_at — TIMESTAMP — NOT NULL — 생성
materials
- material_id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL — 소유
- title — VARCHAR(255) — NOT NULL — 자료 제목
- material_type — VARCHAR(50) — NOT NULL — 자료 타입
- keywords — VARCHAR(1000) — 핵심 키워드
- study_date — DATE — 학습 날짜
- learning_content — TEXT — 학습 요약
- next_plan — TEXT — 향후 학습 계획
- original_file_name — VARCHAR(255) — 서버
- stored_file_name — VARCHAR(255) — S3에
- s3_file_url — VARCHAR(500) — S3
- file_size — BIGINT — 파일
- extracted_text — TEXT — PDF
- extraction_status — VARCHAR(255) — NOT NULL — 텍스트
- uploaded_at — TIMESTAMP — NOT NULL — 업로드
- updated_at — TIMESTAMP — NOT NULL — 수정
refresh_tokens
- token_id — BIGSERIAL
- email — VARCHAR(100) — NOT NULL — 사용자
- token — VARCHAR(500) — NOT NULL — 리프레시
- expiry_date — TIMESTAMP — NOT NULL — 토큰
roadmap_steps
- step_id — BIGSERIAL
- roadmap_id — BIGINT — 외래 키 → roadmaps.roadmap_id — NOT NULL — 상위
- step_order — INT — NOT NULL — 단계
- title — VARCHAR(255) — NOT NULL — 단계별
- description — VARCHAR(255) — 단계별
roadmap_tasks
- task_id — BIGSERIAL
- step_id — BIGINT — 외래 키 → roadmap_steps.step_id — NOT NULL — 소속된
- task_order — INT — NOT NULL — 행동
- content — VARCHAR(1000) — NOT NULL — 행동
- is_completed — BOOLEAN — NOT NULL — 행동
roadmaps
- roadmap_id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL — 로드맵
- material_id — BIGINT — 외래 키 → materials.material_id — 기반이
- title — VARCHAR(255) — NOT NULL — 로드맵
- goal — VARCHAR(255) — 최종
- summary — TEXT — AI
- created_at — TIMESTAMP — NOT NULL — 생성
timers
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL — 사용자
- start_time — TIMESTAMP — NOT NULL — 측정
- end_time — TIMESTAMP — 측정
- duration_seconds — BIGINT — 측정된
- status — VARCHAR(255) — NOT NULL — 타이머
- created_at — TIMESTAMP — NOT NULL — 데이터
- updated_at — TIMESTAMP — NOT NULL — 데이터
todos
- todo_id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL — 사용자
- text — VARCHAR(255) — NOT NULL — 할
- completed — BOOLEAN — NOT NULL — 완료
- start_date — TIMESTAMP — 일정
- end_date — TIMESTAMP — 일정
- created_at — TIMESTAMP — NOT NULL — 생성
users
- user_id — BIGSERIAL
- email — VARCHAR(100) — NOT NULL — 사용자
- password — VARCHAR(255) — NOT NULL — 암호화된
- display_name — VARCHAR(50) — NOT NULL — 서비스
- photo_url — VARCHAR(255) — 프로필
- major — VARCHAR(50) — 전공/학과
- status — VARCHAR(20) — NOT NULL — 사용자
- is_subscribed — BOOLEAN — NOT NULL — 구독
- created_at — TIMESTAMP — NOT NULL — 계정