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