yumyumyum

Tables (12)

ai_recommendations

  • recommendation_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • condition — VARCHAR(255)
  • recommended_menu — VARCHAR(255)
  • alternative_options — TEXT
  • reason_by_llm — TEXT

comments

  • comment_id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → posts.post_id — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • comment_text — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

group_chats

  • message_id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → user_groups.group_id — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • sent_at — DATETIME — NOT NULL
  • message — TEXT

group_members

  • group_id — INT — Foreign key → user_groups.group_id — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • joined_at — DATETIME — NOT NULL

health_logs

  • log_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • log_date — DATE — NOT NULL
  • medication_taken — TINYINT(1)
  • dosage — DECIMAL(10,2)
  • weight — DECIMAL(5,2)
  • water_intake_ml — INT
  • supplements — TEXT

meal_logs

  • log_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • meal_time — DATETIME — NOT NULL
  • photo_url — VARCHAR(255)
  • satisfaction_score — DECIMAL(3,1)
  • emotional_state — VARCHAR(50)
  • fullness_level — VARCHAR(50)
  • nausea — TINYINT(1)
  • bloating — TINYINT(1)

missions

  • mission_id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → user_groups.group_id — NOT NULL
  • week — INT
  • mission_desc — TEXT
  • success_rate_percent — INT

post_reactions

  • reaction_id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → posts.post_id — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • reaction_type — VARCHAR(50) — NOT NULL

posts

  • post_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • group_id — INT — Foreign key → user_groups.group_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • photo_url — VARCHAR(255)
  • ai_summary — TEXT
  • satisfaction — INT
  • had_side_effect — TINYINT(1)

preferences

  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • allergies — TEXT
  • dislikes — TEXT
  • preferred_textures — TEXT
  • preferred_flavors — TEXT

user_groups

  • group_id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • target_weight — VARCHAR(50)
  • current_week — INT
  • dose_level — VARCHAR(50)

users

  • user_id — VARCHAR(100) — Primary key — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • height — INT
  • weight — DECIMAL(5,2)
  • gender — VARCHAR(10)
  • age — INT
  • persona_type — VARCHAR(50)
  • onboarding_date — DATE