eatwise
Tables (9)
Auth
- auth_id — BIGINT
- user_id — BIGINT
- email — VARCHAR(255)
- verification_code — VARCHAR(100)
- expires_at — DATETIME
- verified — BOOLEAN
Food
- food_id — BIGINT
- food_name — VARCHAR(255) — NOT NULL
- category — VARCHAR(100)
- calories — DOUBLE
- carbs — DOUBLE
- protein — DOUBLE
- fat — DOUBLE
- image_url — VARCHAR(500)
Goal
- goal_id — BIGINT
- user_id — BIGINT — NOT NULL
- daily_calorie_target — DOUBLE
- carb_ratio — DOUBLE
- protein_ratio — DOUBLE
- fat_ratio — DOUBLE
- start_date — DATE
- end_date — DATE
MealRecord
- record_id — BIGINT
- user_id — BIGINT — NOT NULL
- food_id — BIGINT — NOT NULL
- intake_time — DATETIME
- intake_date — DATE
- quantity — DOUBLE
- total_calories — DOUBLE
Notification
- notification_id — BIGINT
- user_id — BIGINT — NOT NULL
- type — VARCHAR(50)
- message — TEXT
- created_at — DATETIME
- read_status — BOOLEAN
RecommendedFood
- rec_id — BIGINT
- user_id — BIGINT — NOT NULL
- food_id — BIGINT — NOT NULL
- reason — TEXT
- created_at — DATETIME
Report
- report_id — BIGINT
- user_id — BIGINT — NOT NULL
- report_date — DATE
- calories_consumed — DOUBLE
- nutrient_summary — TEXT
- feedback — TEXT
Restaurant
- restaurant_id — BIGINT
- name — VARCHAR(255)
- address — VARCHAR(255)
- phone — VARCHAR(50)
- latitude — DOUBLE
- longitude — DOUBLE
- image_url — VARCHAR(500)
User
- user_id — BIGINT
- username — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- age — INT
- gender — VARCHAR(10)
- height — DOUBLE
- weight — DOUBLE
- created_at — DATETIME