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