음식 칼로리 기록장
테이블 (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)