fusion_project
Tables (5)
daily_exercise
- date — DATE — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_info.user_id — NOT NULL
- exercise_name — VARCHAR(45) — Foreign key → exercise_category.exercise_name — NOT NULL
daily_food
- date — DATE — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user_info.user_id — NOT NULL
- food_name — VARCHAR(45) — Foreign key → food_category.food_name — NOT NULL
exercise_category
- exercise_name — VARCHAR(45) — Primary key — NOT NULL
- calorie_hour — BIGINT — NOT NULL
food_category
- food_name — VARCHAR(45) — Primary key — NOT NULL
- calorie_food — BIGINT — NOT NULL
user_info
- user_id — BIGINT — Primary key — NOT NULL
- password — VARCHAR(45) — NOT NULL
- name — VARCHAR(45) — NOT NULL
- weight — VARCHAR(45) — NOT NULL
- age — VARCHAR(45) — NOT NULL
- sex — TINYINT — NOT NULL