DearMe
Tables (4)
ai_reply (AI 답장)
- ai_reply_id (응답 ID) — NOTNULL — Primary key — NOT NULL
- client_id (고유 ID) — NOTNULL — Foreign key → client.client_id — NOT NULL
- stress_score (스트레스 지수) — NOTNULL
- reply_text (응답 내용) — NOTNULL
- model (gemini ai 모델명) — NULL
- prompt_snapshot (프롬프트) — NULL
- duration_ms (응답 소요 시간) — NULL
- status (성공/대체 여부) — NULL
- fail_reason (실패 원인) — NULL
- created_at (생성일) — NOTNULL DEFAULT CURRENT_TIMESTAMP
ai_reply_memo (AI 답장 - 감정 메모)
- memo_id (메모 ID) — NOTNULL — Foreign key → memo.memo_id — NOT NULL
- ai_reply_id (응답 ID) — NOTNULL — Foreign key → ai_reply.ai_reply_id — NOT NULL
client (사용자)
- client_id (고유 ID) — NOTNULL — Primary key — NOT NULL
- created_at (생성일) — NOTNULL DEFAULT CURRENT_TIMESTAMP
memo (감정 메모)
- memo_id (메모 ID) — NOTNULL AUTO_INCREMENT — Primary key — NOT NULL
- client_id (고유 ID) — NOTNULL — Foreign key → client.client_id — NOT NULL
- date (작성 날짜) — NOTNULL
- emoji (감정 이모지) — NOTNULL
- emotion_score (감정 점수) — NOTNULL
- title (제목) — NOTNULL
- content (내용) — NOTNULL
- created_at (메모 생성일) — NOTNULL DEFAULT CURRENT_TIMESTAMP