dd
Tables (10)
Average_by_age_gender
- age_group — NUMBER
- gender — NUMBER(1)
- avg_sleep_time — INTERVAL
- avg_steps — NUMBER
- avg_weight — NUMBER
- avg_height — NUMBER
Food
- food_name — VARCHAR2(255)
- calories_per_gram — NUMBER
Food_log
- user_id — VARCHAR2(255)
- food_name — VARCHAR2(255)
- food_weight — NUMBER
- food_calories — NUMBER
- time — TIMESTAMP
- recorded_at — TIMESTAMP
User
- user_id — VARCHAR2(255) — Primary key
- user_password — VARCHAR2(255)
- user_name — VARCHAR2(255)
- email — VARCHAR2(255)
body_info
- user_id — VARCHAR2(255)
- gender — NUMBER(1)
- age — NUMBER
- birth — TIMESTAMP
- height — NUMBER
- activity_factor — NUMBER
- blood_pressure_systolic — NUMBER
- blood_pressure_diastolic — NUMBER
heart_rate
- user_id — VARCHAR2(255)
- heart_rate — NUMBER
- time — TIMESTAMP
- recorded_at — TIMESTAMP
sleep_actual
- user_id — VARCHAR2(255)
- actual_start_sleep_time — TIMESTAMP
- actual_end_sleep_time — TIMESTAMP
- actual_sleep_time — INTERVAL
- recorded_at — TIMESTAMP
steps
- user_id — VARCHAR2(255)
- steps — NUMBER
- time — TIMESTAMP
- recorded_at — TIMESTAMP
target
- user_id — VARCHAR2(255)
- weight — NUMBER
- sleep — INTERVAL
- steps — NUMBER
- food — NUMBER
weight_log
- user_id — VARCHAR2(255)
- weight — NUMBER
- bmi — NUMBER
- time — TIMESTAMP
- recorded_at — TIMESTAMP