yumyum

Tables (5)

diet_log (diet)

  • id — bigint — Primary key — NOT NULL
  • calories — int
  • carbohydrate — float
  • fat — float
  • image_url — varchar(255)
  • meal_type — varchar(255)
  • protein — float
  • record_time — date
  • user_id — bigint

diet_log_item (Untitled)

  • id — bigint — Primary key — NOT NULL
  • diet_log_id — bigint
  • food_code — varchar(255)
  • quantity — float

point

  • id — bigint — NOT NULL
  • daily_point — int
  • points_earned — int
  • record_date — date
  • user_id — bigint

target

  • id — bigint — Primary key — NOT NULL
  • calories — float
  • carbohydrate — float
  • fat — float
  • protein — float
  • user_id — bigint

users

  • id — bigint — Primary key — NOT NULL
  • birthdate — date
  • current_point — int
  • email — varchar(255)
  • gender — varchar(255)
  • height — float
  • password — varchar(255)
  • username — varchar(255)
  • weight — float