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