3333

Tables (16)

agent_chat_rooms

  • agent_room_id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 채팅방을
  • room_name — VARCHAR(100) — NOT NULL — 채팅방
  • created_at — TIMESTAMP — NOT NULL — 채팅방

agents

  • agent_id — BIGSERIAL
  • agent_room_id — BIGINT — Foreign key → 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) — 답변
  • goal — VARCHAR(200) — AI
  • created_at — TIMESTAMP — NOT NULL — 에이전트

chat_messages

  • message_id — BIGSERIAL
  • agent_room_id — BIGINT — Foreign key → agent_chat_rooms.agent_room_id — NOT NULL — 메시지가
  • agent_id — BIGINT — Foreign key → 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 — Foreign key → materials.material_id — NOT NULL — 학습
  • feedback_data — TEXT — AI
  • created_at — TIMESTAMP — NOT NULL — 생성

material_memos

  • memo_id — BIGSERIAL
  • material_id — BIGINT — Foreign key → 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 — Foreign key → 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 — Foreign key → 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 — Foreign key → materials.material_id — NOT NULL — 학습
  • overview — TEXT — 전체
  • core_contents — TEXT — 핵심
  • created_at — TIMESTAMP — NOT NULL — 생성

materials

  • material_id — BIGSERIAL
  • user_id — BIGINT — Foreign key → 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_file_url — VARCHAR(500) — S3
  • file_size — BIGINT — 파일
  • extracted_text — TEXT — 파일에서
  • 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 — Foreign key → 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 — Foreign key → 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 — Foreign key → users.user_id — NOT NULL — 로드맵
  • material_id — BIGINT — Foreign key → materials.material_id — 기반
  • title — VARCHAR(255) — NOT NULL — 로드맵
  • goal — VARCHAR(255) — 최종
  • summary — TEXT — 로드맵
  • created_at — TIMESTAMP — NOT NULL — 생성

timers

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → 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 — Foreign key → 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 — 계정