Remood

Tables (5)

emotionLog

  • log_id — BIGINT — Primary key — NOT NULL
  • question — TEXT
  • answer — TEXT
  • ai_feedback — TEXT
  • is_bookmarked — BOOLEAN
  • log_date — DATE
  • created_at — DATETIME
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • emotiontype_id — BIGINT — Foreign key → emtionType.emotiontype_id — NOT NULL

emotionLog_keyword

  • log_id — BIGINT — Foreign key → emotionLog.log_id — NOT NULL
  • keyword_id — INTEGER — Foreign key → keyword.keyword_id — NOT NULL

emtionType (emotionType)

  • emotiontype_id — BIGINT — Primary key — NOT NULL
  • emotion_name — VARCHAR(30)
  • emoji — VARCHAR(30)
  • emotion_category — VARCHAR(30)

keyword

  • keyword_id — INTEGER — Primary key — NOT NULL
  • word — VARCHAR(20)

user

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(50)
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30)
  • nickname — VARCHAR(30)
  • provider — VARCHAR(10)
  • provider_id — VARCHAR(100)
  • created_at — DATETIME