deepiary

Tables (5)

chat_sessions

  • chat_id — BIGINT — Primary key
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id
  • user_id — BIGINT — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • result_text — TEXT

diary_entries

  • diary_id — BIGINT — Primary key
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id
  • user_id — BIGINT — NOT NULL
  • content — TEXT
  • emotion_summary — VARCHAR(255)
  • emotion_json — JSON
  • created_at — DATETIME
  • updated_at — DATETIME

inquiries

  • inquiry_id — BIGINT — Primary key
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • created_at — DATETIME
  • answered — BOOLEAN

users

  • user_id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • profile_image — VARCHAR(255)
  • role — ENUM('USER', 'ADMIN')
  • withdrawn — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

withdrawal_logs

  • log_id — BIGINT — Primary key
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id
  • user_id — BIGINT
  • reason — TEXT
  • created_at — DATETIME