toy_diary
Tables (4)
diary (일기장)
- id (Key) — int — Primary key — NOT NULL
- user_id (key) — Foreign key → user.id — NOT NULL
- date (날자) — date
- drink_water (마신 물) — int
- target_water (마실 물) — int
- condition (그날상태) — int
diat (식단)
- id (Key) — int — Primary key — NOT NULL
- diary_id (Key2) — int — Foreign key → diary.id — NOT NULL
- time (시간) — datetime
- food (음식) — varchar
- calorie (칼로리) — int
- tansu (탄수화물) — int
- danback (단백질) — int
- zibang (지방) — int
food (음식)
- Key — Primary key — NOT NULL
- time (시간) — datetime
- name (음식이름) — varchar
- calorie (칼로리) — int
- tansu (탄수화물) — int
- danback (단백질) — int
- zibang (지방) — int
user (사용자)
- id (Key) — Primary key — NOT NULL
- login_id (아이디) — varchar
- password (비밀번호) — varchar