Food

Tables (6)

Appraisal (Untitled6)

  • Review (리뷰) — CHAR(30)
  • Grade (평점) — CHAR(5)

Food (Untitled4)

  • Food_name (음식이름) — CHAR(10) — Primary key — NOT NULL
  • Id (아이디) — CHAR(20) — Foreign key → User.Id — NOT NULL
  • Ingredient (재료) — CHAR(15)
  • Food_cal (음식칼로리) — INTEGER

Goal (Untitled3)

  • G_num (목표식별번호) — CHAR(15) — Primary key — NOT NULL
  • G_date (목표날짜) — CHAR(10)
  • G_kg (목표몸무게) — INTEGER
  • Daily_cal (권장칼로리) — INTEGER

Recipe (Untitled5)

  • Re_number (레시피식별번호) — CHAR(15) — Primary key — NOT NULL
  • Food_name (음식이름) — CHAR(10) — Foreign key → Food.Food_name — NOT NULL
  • Id (아이디) — CHAR(20) — Foreign key → Food.Id — NOT NULL
  • Cook (요리방법) — CHAR(30)
  • Time (소요시간) — CHAR(10)
  • Level (요리난이도) — CHAR(5)

Recodes (Untitled2)

  • R_num (제출내역 식별번호) — CHAR(12) — Primary key — NOT NULL
  • Kg (몸무게) — INTEGER
  • BMI — INTEGER
  • Body_fat (체지방률) — INTEGER
  • Basal_met (기초대사량칼로리) — INTEGER
  • Medical_history (병력정보) — CHAR(20)

User (Untitled)

  • Id (아이디) — CHAR(20) — Primary key — NOT NULL
  • Name (사용자이름) — CHAR(5)
  • Ind_number (생년월일) — CHAR(6)
  • Age (나이) — INTEGER
  • Password (비밀번호) — CHAR(15)
  • Sex (성별) — CHAR(3)