02
Tables (9)
diet_logs
- id — INT
- user_id — INT — NOT NULL
- meal_type — VARCHAR(20)
- food_description — TEXT — NOT NULL
- photo_url — VARCHAR(255)
- log_date — DATE — NOT NULL
exercise_logs
- id — INT
- user_id — INT — NOT NULL
- exercise_id — INT
- program_id — INT
- log_date — DATE — NOT NULL
- duration_minutes — INT
- intensity — VARCHAR(50)
- calories_burned — INT
- mood — VARCHAR(50)
- notes — TEXT
exercises
- id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- difficulty — VARCHAR(50)
- duration_minutes — INT
- body_part — VARCHAR(100)
- video_url — VARCHAR(255)
- exercise_type — VARCHAR(50)
favorites
- id — INT
- user_id — INT — NOT NULL
- exercise_id — INT
- program_id — INT
- created_at — TIMESTAMP
program_exercises
- program_id — INT
- exercise_id — INT
- day_of_week — INT
- sequence — INT
programs
- id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- category — VARCHAR(100)
reviews
- id — INT
- user_id — INT — NOT NULL
- exercise_id — INT
- program_id — INT
- rating — INT
- comment — TEXT — EX
- created_at — TIMESTAMP
user_profiles
- user_id — INT
- age — INT
- gender — VARCHAR(10)
- height — DECIMAL(5, 2)
- weight — DECIMAL(5, 2)
- chronic_disease — VARCHAR(255)
- activity_level — VARCHAR(50)
- mental_health_status — VARCHAR(255)
- health_goals — TEXT
users
- id — INT
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP