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