ㅇㅇ

Tables (16)

daily_menu

  • daily_menu_id — BIGINT — Primary key — NOT NULL
  • weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id — NOT NULL
  • day_of_week — TINYINT — NOT NULL
  • daily_menu_highlight — VARCHAR(255)
  • daily_menu_image_url — VARCHAR(2048)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

daily_menu_dish

  • meal_type — ENUM('BREAKFAST', 'LUNCH', 'DINNER') — Primary key — NOT NULL
  • daily_menu_id — BIGINT — Foreign key → daily_menu.daily_menu_id — NOT NULL
  • dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL

dish

  • dish_id — BIGINT — Primary key — NOT NULL
  • dish_name — VARCHAR(100) — NOT NULL
  • dish_description — VARCHAR(1000)
  • dish_image_url — VARCHAR(2048)
  • cooking_time_minutes — INT
  • servings — INT — NOT NULL
  • source_name — VARCHAR(100)
  • source_url — VARCHAR(2048)
  • external_recipe_id — VARCHAR(255)
  • crawled_at — DATETIME
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

dish_ingredient

  • dish_ingredient_id — BIGINT — Primary key — NOT NULL
  • dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
  • ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id
  • raw_ingredient_name — VARCHAR(100) — NOT NULL
  • raw_amount_text — VARCHAR(100)
  • quantity — DECIMAL(10, 2)
  • unit — VARCHAR(50)
  • required_grams — DECIMAL(10, 2)
  • is_optional — BOOLEAN — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

dish_recipe_step

  • dish_recipe_step_id — BIGINT — Primary key — NOT NULL
  • dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
  • step_number — INT — NOT NULL
  • description — VARCHAR(1000) — NOT NULL
  • step_image_url — VARCHAR(2048)
  • timer_seconds — INT
  • cooking_tip — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ingredient

  • ingredient_id — BIGINT — Primary key — NOT NULL
  • ingredient_name — VARCHAR(100) — NOT NULL
  • normalized_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • ingredient_image_url — VARCHAR(2048)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ingredient_alias

  • ingredient_alias_id — BIGINT — Primary key — NOT NULL
  • ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
  • alias_name — VARCHAR(100) — NOT NULL
  • normalized_alias_name — VARCHAR(100) — NOT NULL
  • source_name — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

ingredient_price

  • ingredient_price_id — BIGINT — Primary key — NOT NULL
  • ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • source_item_code — VARCHAR(100)
  • region_name — VARCHAR(100)
  • market_name — VARCHAR(100)
  • unit_name — VARCHAR(50) — NOT NULL
  • unit_grams — DECIMAL(10, 2) — NOT NULL
  • price — INT — NOT NULL
  • price_date — DATE — NOT NULL
  • refreshed_at — DATETIME — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

ingredient_request

  • ingredient_request_id — BIGINT — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
  • ingredient_name — VARCHAR(100) — NOT NULL
  • memo — VARCHAR(500)
  • status — ENUM('REQUESTED', 'APPROVED', 'REJECTED') — NOT NULL
  • created_at — DATETIME — NOT NULL

user_current_menu

  • user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
  • weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id — NOT NULL
  • created_at — DATETIME — NOT NULL

user_favorite_menu

  • user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
  • weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id — NOT NULL
  • saved_at — DATETIME — NOT NULL

user_ingredient

  • user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
  • ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
  • owned_grams — DECIMAL(10, 2) — NOT NULL
  • memo — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_preferred_dish

  • user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
  • dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
  • created_at — DATETIME — NOT NULL

user_shopping_list_item

  • shopping_list_item_id — BIGINT — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
  • ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
  • ingredient_price_id — BIGINT — Foreign key → ingredient_price.ingredient_price_id
  • quantity_grams — DECIMAL(10, 2) — NOT NULL
  • is_checked — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • user_id — CHAR(36) — Primary key — NOT NULL
  • user_name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

weekly_menu

  • weekly_menu_id — BIGINT — Primary key — NOT NULL
  • owner_user_id — CHAR(36) — Foreign key → users.user_id
  • source_weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id
  • weekly_menu_name — VARCHAR(100) — NOT NULL
  • weekly_menu_explanation — VARCHAR(500)
  • weekly_menu_highlight — VARCHAR(255)
  • weekly_menu_image_url — VARCHAR(2048)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL