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