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)