someday

Tables (9)

chat_message

  • id — CHAR(36)
  • session_id — CHAR(36) — Foreign key → chat_session.id — NOT NULL
  • sender_type — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

chat_session

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • session_date — DATE — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP

cheer_message

  • id — CHAR(36)
  • sender_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • receiver_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • jenga_block_id — CHAR(36) — Foreign key → jenga_block.id — NOT NULL
  • message — TEXT — NOT NULL
  • cheer_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

jenga_block

  • id — CHAR(36)
  • tower_id — CHAR(36) — Foreign key → jenga_tower.id — NOT NULL
  • analysis_id — CHAR(36) — Foreign key → mental_analysis.id
  • floor_index — INT — NOT NULL
  • position_index — INT — NOT NULL
  • block_type — VARCHAR(20) — NOT NULL
  • message — TEXT
  • created_at — TIMESTAMP — NOT NULL

jenga_tower

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • week_start_date — DATE — NOT NULL
  • total_floors — INT — NOT NULL
  • stability_score — INT — NOT NULL
  • collapsed — BOOLEAN — NOT NULL

mental_analysis

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • session_id — CHAR(36) — Foreign key → chat_session.id — NOT NULL
  • analysis_date — DATE — NOT NULL
  • internal_calculation — TEXT — NOT NULL
  • stability_score — INT — NOT NULL
  • stacked_blocks — INT — NOT NULL
  • extracted_stressors — TEXT — NOT NULL
  • mental_state — VARCHAR(100) — NOT NULL
  • action_mission — TEXT — NOT NULL
  • food_recommendation — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

my_profile

  • id — CHAR(36)
  • avatar_emoji — VARCHAR(20)
  • title — VARCHAR(50)
  • consecutive_days — INT — NOT NULL
  • total_layers — INT — NOT NULL
  • cheers_sent — INT — NOT NULL
  • cheers_received — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

recovery_mission

  • id — CHAR(36)
  • mission_date — DATE — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • mission_type — VARCHAR(30) — NOT NULL
  • completed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • id — CHAR(36)
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • gender — VARCHAR(20)
  • 나이 (Field)
  • 취침시간 (Field2)
  • Field3