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