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 — 계정