nyamnyam

Tables (7)

food

  • food_id — BIGINT — Primary key
  • name_kor — VARCHAR(255) — NOT NULL
  • manufacturer — VARCHAR(255)
  • category — VARCHAR(100)
  • base_amount_g — DECIMAL(8,2)
  • is_liquid — TINYINT(1) — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_food_name
  • meal_id — BIGINT — Foreign key → meal_log.meal_id

food_nutrient

  • nutrient_code — VARCHAR(32) — Primary key — NOT NULL
  • food_id — BIGINT — Foreign key → food.food_id
  • amount_per_100 — DECIMAL(10,4) — NOT NULL

meal_log

  • meal_id — BIGINT — Primary key
  • meal_date — DATE — NOT NULL
  • meal_time — TIME
  • meal_type — ENUM('BREAKFAST','LUNCH','DINNER','SNACK') — NOT NULL
  • note — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_meal_user_date
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

user_condition

  • condition_code — VARCHAR(32) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • diagnosed_at — DATE
  • note — VARCHAR(255)

user_goal

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • goal_id — BIGINT
  • goal_type — ENUM('WEIGHT_LOSS','MUSCLE_GAIN','DISEASE_CONTROL','GENERAL') — NOT NULL
  • target_kcal — INT
  • target_protein_g — DECIMAL(6,2)
  • target_carb_g — DECIMAL(6,2)
  • target_fat_g — DECIMAL(6,2)
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_goal_user_active

user_profile

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • sex — ENUM('MALE','FEMALE','OTHER')
  • birthdate — DATE
  • height_cm — DECIMAL(5,2)
  • weight_kg — DECIMAL(5,2)
  • activity_level — ENUM('SEDENTARY','LIGHT','MODERATE','ACTIVE','VERY_ACTIVE')
  • updated_at — DATETIME — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(30)
  • status — ENUM('ACTIVE','INACTIVE','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL