nyam

Tables (5)

Diet (식단)

  • DietId (식단아이디) — NOT NULL — Primary key — NOT NULL
  • UserId (유저아이디) — NOT NULL — Foreign key → User.UserId — NOT NULL

Food (음식)

  • FoodId (음식아이디) — NOT NULL — Primary key — NOT NULL
  • Name (음식 이름) — NOT NULL
  • Calories (음식 칼로리) — NOT NULL
  • Fat (지방) — NOT NULL
  • Protein (단백질) — NOT NULL
  • Carbs (탄수화물) — NOT NULL
  • Vitamin (비타민) — NOT NULL
  • Natrium (나트륨) — NOT NULL
  • Sugar (당류) — NOT NULL

JOIN (식단_)

  • DietId (식단아이디) — NOT NULL — Foreign key → Diet.DietId — NOT NULL
  • FoodId (음식아이디) — NOT NULL — Foreign key → Food.FoodId — NOT NULL

Review (리뷰)

  • ReviewId (리뷰아이디) — NOT NULL — Primary key — NOT NULL
  • UserId (유저아이디) — NOT NULL — Foreign key → User.UserId — NOT NULL
  • Score (평점) — NOT NULL
  • Comment (리뷰)

User (유저)

  • UserId (유저아이디) — NOT NULL — Primary key — NOT NULL
  • Weight (체중) — NOT NULL
  • Height (키) — NOT NULL
  • Age (나이) — NOT NULL
  • BloodSugar (혈당) — NOT NULL
  • Allergic (알러지유무) — NOT NULL