Healthymeal_2.0

Tables (3)

food (식품)

  • id (식별번호) — bigint — Primary key — NOT NULL
  • Field

meal_info (식단기록)

  • id (식별번호) — bigint — Primary key — NOT NULL
  • user_id (사용자명) — varchar(255) — Foreign key → user.id — NOT NULL
  • img_path (이미지경로) — varchar(255)
  • meal_name (식단이름) — varchar(50)
  • taken_at (섭취시각) — datetime
  • diary (일기) — tinytext
  • last_modified_at (수정일시) — datetime

user (사용자)

  • id (사용자명) — varchar(255) — Primary key — NOT NULL
  • hashed_password (패스워드) — varchar(255)
  • email (이메일) — varchar(255)
  • birthday (생년월일) — date
  • gender (성별) — char(1)