MIND Sensation

Tables (5)

tb_ai_result (AI 분석결과)

  • ai_result_id — BIGINT — Primary key — NOT NULL
  • entry_id (entry_id2) — BIGINT — Foreign key → tb_diary.entry_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → tb_diary.user_id — NOT NULL
  • entry_id — BIGINT
  • feedback_emotion — TEXT
  • model_name — VARCHAR
  • summary — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

tb_diary (일기)

  • entry_id — BIGINT — Primary key — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL
  • entry_date — date
  • content — text
  • user_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

tb_entry_answer (일기 답변)

  • answer_id — BIGINT — Primary key — NOT NULL
  • ai_result_id (ai_result_id2) — BIGINT — Foreign key → tb_ai_result.ai_result_id — NOT NULL
  • entry_id (entry_id2) — BIGINT — Foreign key → tb_ai_result.entry_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → tb_ai_result.user_id — NOT NULL
  • entry_id — BIGINT
  • ai_result_id — BIGINT NULL
  • question_id — BIGINT — NOT NULL
  • option_id — BIGINT NULL
  • free_text — TEXT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

tb_music_item (음악 아이템)

  • music_id — BIGINT — Primary key — NOT NULL
  • ai_result_id (ai_result_id2) — BIGINT — Foreign key → tb_ai_result.ai_result_id — NOT NULL
  • entry_id (entry_id2) — BIGINT — Foreign key → tb_ai_result.entry_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → tb_ai_result.user_id — NOT NULL
  • ai_result_id — BIGINT
  • title — VARCHAR
  • artist — VARCHAR
  • platform — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

tb_user (사용자)

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR
  • nickname — VARCHAR
  • oauth_provider — VARCHAR
  • password_hash — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME