모래

테이블 (9)

daily_question

  • id — BIGINT
  • question_date — DATE — NOT NULL
  • question_text — TEXT — NOT NULL
  • question_type — VARCHAR(20) — NOT NULL
  • interest_id — INT
  • created_at — DATETIME — NOT NULL
  • CHECK — (question_type IN ('normal','milestone'))

diary_analysis

  • id — BIGINT
  • diary_entry_id — BIGINT — NOT NULL
  • emotions — TEXT
  • keywords — TEXT
  • sentiment_score — DOUBLE
  • color_code — VARCHAR(7)
  • analyzed_at — DATETIME — NOT NULL

diary_entry

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • question_id — BIGINT — NOT NULL
  • entry_date — DATE — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • CHECK — (is_deleted IN (0,1))

friendship

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • friend_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • CHECK — (user_id <> friend_id)
  • CHECK — (status IN ('pending','accepted','rejected'))

interest

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

notification_setting

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • question_time — TIME
  • push_enabled — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • CHECK — (push_enabled IN (0,1))

periodic_analysis

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • period_type — VARCHAR(20) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • emotion_trends — TEXT
  • keyword_trends — TEXT
  • comparison_data — TEXT
  • similar_region — TEXT
  • contour_data — TEXT
  • created_at — DATETIME — NOT NULL
  • CHECK — (period_type IN ('daily','weekly','monthly','yearly','total'))

user_interest

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • interest_id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(50)
  • provider — VARCHAR(50)
  • provider_id — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • CHECK — (is_active IN (0,1))