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