연습장
테이블 (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