webprog
Tables (4)
Goal (Untitled2)
- 유저Id (userId) — long — Foreign key → User.유저Id — NOT NULL
- 칼로리 (goalCalories) — integer — NOT NULL — kcal
- 단백질 (goalProtein) — integer — g
- 지방 (goalFat) — integer — g
- 탄수화물 (goalCarbon) — integer — g
- 당 (goalSugar) — integer — g
- 콜레스테롤 (goalChole) — integer — mg
- 생성 날짜 (createdAt) — localDate
- 수정 날짜 (modifiedAt) — localDate
Tracking (Untitled3)
- 추척Id (trackingId) — long — Primary key — NOT NULL
- 날짜 (date) — localdate — NOT NULL
- 총 섭취 칼로리 (totalCalories) — integer — NOT NULL
- 목표 달성 여부 (isSuccess) — boolean — NOT NULL
- 생성 날짜 (createdAt) — localDate — NOT NULL
- 수정날짜 (modifiedAt) — localDate — NOT NULL
- 유저Id (userId) — long — Foreign key → User.유저Id — NOT NULL
TrackingDetails (Untitled4)
- 추적디테일 id (detailId) — long — Primary key — NOT NULL
- 추척Id (trackingId) — long — Foreign key → Tracking.추척Id — NOT NULL
- 식사종류 (mealtype) — enum — NOT NULL — breakfast, lunch, dinner
- 식사이름 (foodName) — String
- 섭취 칼로리 (eatCalories) — integer — NOT NULL
- 섭취 단백질 (eatProtein) — integer
- 섭취 지방 (eatFat) — integer
- 섭취 탄수화물 (eatCarbon) — integer
- 섭취 당 (eatSugar) — integer
- 섭취 콜레스테롤 (eatChole) — integer
- 생성날짜 (createdAt) — localDate — NOT NULL
- 수정날짜ㅊ (modifiedAt) — localdate — NOT NULL
User (Untitled)
- 유저Id (userId) — long — Primary key — NOT NULL
- 비밀번호 (userPw) — String — NOT NULL
- 유저이름 (userName) — String — NOT NULL
- 유저성별 (userSex) — enum — NOT NULL — male, female
- 유저나이 (userAge) — integer — NOT NULL
- 유저몸무게 (userWeight) — long — NOT NULL
- 유저키 (userHeight) — long — NOT NULL