DB_NUTRIENT
테이블 (7)
Food (food)
- Food Id (food_id) — TEXT — 기본 키 — NOT NULL
- Field
- Calorie (kcal) — Int
- Protein (prot) — Int
- Carbohydrate (carb) — Int
- Fat (fat) — Int
- Sodium (sodi) — Int
- Suga (suga) — Int
Food Type (food type)
- Food Id (food_id)
- Food Type (food_type)
Insert (insert)
- Insert Id (insert_id) — TEXT — 기본 키 — NOT NULL
- Food Id (food_id) — TEXT — 기본 키 — NOT NULL
Nutrient (nutrient)
- Nutrient Id (nut_id) — TEXT — 기본 키 — NOT NULL
- Nutrient Name (nut_name) — NOT NULL
- Unit (unit) — NOT NULL — 각 영양 성분에 해당되는 단위
Recommended Amount (recommended amount)
- recommended amount (rec_amount)
Search (search)
- Search Id (search_id) — TEXT — 기본 키 — NOT NULL — 검색 ID
- Food Id (food_id) — TEXT — 기본 키 — NOT NULL — 음식 ID
- Nutrient Id (nut_id) — TEXT — 기본 키 — NOT NULL — 영양성분 ID
- Search Date (Search_date) — TEXT — NOT NULL — 검색일자
User(삭제예정) (user)
- User Id (user_id) — TEXT — 기본 키 — NOT NULL
- User Name (user_name) — VARCHAR(20) — NOT NULL
- E-Mail (email) — VARCHAR(20) — NOT NULL