dd

Tables (15)

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)

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_image_url — VARCHAR(2048)
  • cooking_time_minutes — INT
  • servings — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

dish_ingredient

  • dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
  • ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
  • required_grams — DECIMAL(10, 2) — 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

ingredient

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

ingredient_product

  • ingredient_product_id — BIGINT — Primary key — NOT NULL
  • ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
  • product_name — VARCHAR(255) — NOT NULL
  • store_name — VARCHAR(100)
  • package_grams — DECIMAL(10, 2) — NOT NULL
  • price — INT — NOT NULL
  • product_url — VARCHAR(2048)
  • refreshed_at — DATETIME
  • is_active — BOOLEAN — NOT NULL

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
  • start_date — DATE — 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_product_id — BIGINT — Foreign key → ingredient_product.ingredient_product_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