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