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)