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