yumyum
Tables (3)
food_log
- food_log_pk — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- food_pk — BIGINT — Foreign key → foods.food_pk — NOT NULL
- eat_date — DATE — NOT NULL
- meal_type — VARCHAR(10) — NOT NULL
- quantity — DOUBLE — NOT NULL
- created_at — DATETIME — NOT NULL
foods
- food_pk — BIGINT
- food_code — VARCHAR(50) — NOT NULL
- food_name — VARCHAR(255) — NOT NULL
- major_category_name — VARCHAR(100)
- nutrition_base_amount — VARCHAR(100)
- energy_kcal — DOUBLE
- protein_g — DOUBLE
- fat_g — DOUBLE
- carb_g — DOUBLE
- sugars_g — DOUBLE
- sodium_mg — DOUBLE
- sat_fat_g — DOUBLE
- trans_fat_g — DOUBLE
- food_weight — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT
- 닉네임 (nickname) — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- height_cm — DOUBLE — NOT NULL
- weight_kg — DOUBLE — NOT NULL
- gender — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME