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