YumYum

Tables (3)

DietLog (DietLogDto)

  • logId (dietLogId) — int — Primary key — NOT NULL
  • email (memberEmail) — String — Foreign key → Member.email — NOT NULL
  • logDate (dietLogDate) — String
  • logMealType (dietLogMealType) — String
  • foods (diestLogFoods) — List<FoodDto>

Food (FoodDto)

  • code (foodCode) — String — Primary key — NOT NULL
  • logId (dietLogId) — int — Foreign key → DietLog.logId — NOT NULL
  • name (foodName) — String
  • energy (foodEnergy) — double
  • carb (foodCarb) — double
  • protein (foodProtein) — double
  • fat (foodFat) — double
  • weight (foodWeight) — String

Member (MemberDto)

  • email (memberEmail) — String — Primary key — NOT NULL
  • password (memberPasswordHash) — String
  • name (memberName) — String
  • height (memberHeight) — int
  • weight (memberWeight) — int
  • disease (memberDisease) — List<String>
  • follower (memberFollower) — Set<String>
  • following (memberFollowing) — Set<String>