연습장

테이블 (10)

ai_conversations

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE', 'ANALYZING', 'COMPLETED') — NOT NULL
  • purge_at — DATETIME(6) — 대화 원문 삭제 예정 시각
  • completed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

ai_messages

  • id — BIGINT — 기본 키 — NOT NULL
  • conversation_id — BIGINT — 외래 키 → ai_conversations.id — NOT NULL
  • client_message_id — VARCHAR(36) — 사용자 메시지 재전송 중복 방지 ID
  • sequence_no — BIGINT — NOT NULL
  • sender_type — ENUM('USER', 'AI', 'SYSTEM') — NOT NULL
  • status — ENUM('PENDING', 'SENT', 'FAILED') — NOT NULL
  • content — TEXT — NOT NULL
  • failure_code — VARCHAR(50)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

anonymoud_chats (익명 채팅)

  • id — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → anonymous_rooms.id — NOT NULL
  • Field

anonymous_rooms

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • product_id — 외래 키 → products.id — NOT NULL
  • questioner_user_id — BIGINT — NOT NULL
  • recipient_user_id — BIGINT — NOT NULL
  • opened_at — DATETIME(6

events

  • id — BIGINT — 기본 키 — NOT NULL
  • owner_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • friend_id — BIGINT — 외래 키 → friends.id
  • source_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • event_date — DATE — NOT NULL
  • external_event_id — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

friends

  • id — BIGINT — 기본 키 — NOT NULL
  • owner_user_id — BIGINT — NOT NULL
  • linked_user_id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • profile_image_url — VARCHAR(2048)
  • is_favorite — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

notifications

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id
  • friend_id — BIGINT — 외래 키 → friends.id
  • anonymous_room_id — BIGINT — 외래 키
  • actor_user_id — BIGINT
  • recipient_user_id — BIGINT — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — VARCHAR(500)
  • idempotency_key — VARCHAR(255) — NOT NULL
  • read_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

products (상품)

  • id — 기본 키 — NOT NULL
  • Field

taste_analyses

  • id — BIGINT — 기본 키 — NOT NULL
  • conversation_id — BIGINT — 외래 키 → ai_conversations.id — NOT NULL
  • status — ENUM('QUEUED', 'RUNNING', 'SUCCEEDED', 'FAILED') — NOT NULL
  • progress — TINYINT — NOT NULL
  • progress_message — VARCHAR(255)
  • candidate_result — JSON — 사용자 승인 전 임시 분석 결과
  • decision — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
  • failure_code — VARCHAR(50)
  • started_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • decided_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

users (사용자)

  • id — BIGINT — 기본 키 — NOT NULL
  • Field