음식 칼로리 기록장

테이블 (3)

foods

  • food_id — varchar(10) — 기본 키 — NOT NULL
  • food_code — varchar(50)
  • food_name — varchar(255)
  • energy_kcal — float
  • carbohydrate_g — float
  • protein_g — float
  • fat_g — float
  • sugar_g — float
  • sodium_mg — float
  • calcium_mg — float
  • iron_mg — float
  • potassium_mg — float
  • vitamin_a_ug — float
  • vitamin_c_mg — float
  • vitamin_d_ug — float
  • cholesterol_mg — float
  • saturated_fat_g — float
  • trans_fat_g — float

records

  • record_id — varchar(10) — 기본 키 — NOT NULL
  • id (id2) — varchar(10) — 외래 키 → users.id — NOT NULL
  • food_id — varchar(10) — 외래 키 → foods.food_id — NOT NULL
  • quantity — float
  • record_date — date

users

  • id — varchar(10) — 기본 키 — NOT NULL
  • username — varchar(10)
  • password — varchar(10)
  • name — varchar(100)